ORAARCH running out of space...

[LeonardoAraujo]

I've installed my SAP instance and it has been running fine for a few weeks. Now I cannot log on to it anymore since the log file seems full. The disk I allocated for it is only 5gb and it is 100% full.

The log shows the following errors:

Database error 257 at CON

Database > ORA-000257 archive error. Connect internally only until free.

I check my OS directory at F:\ORACLE\III\ORAARCH I am full of files like this:

IIIARCHARC01550.001 around 50 MB each.

1 - How can I delete this log since I cannot log on anymore?

2 - Which setup can I do in the system to periodically purge old log records?

Thanks

Message was edited by: Leonardo De Araujo

[Former Member]

Move the files from your ORAARCH directory to another disk, that logging in should succeed.

[eddy_declercq]

Hi,

Pls check this forum thread:

Eddy

[LeonardoAraujo]

Eddy,

That answers the problem I have with .001 files. Thanks

Still, what do I do with the log file. It keeps building. How can I periodically purge the SAP System log?

[eddy_declercq]

Hi,

I would suggest Log switching. See http://help.sap.com/saphelp_nw04/helpdata/en/1f/8312144bc511d189750000e8322d00/frameset.htm

for this.

Check also http://help.sap.com/saphelp_nw04/helpdata/en/1f/8311784bc511d189750000e8322d00/frameset.htm

Eddy