Showing results for 
Search instead for 
Did you mean: 

oracle error 257

oracle error 257

Hi everyone

The Oracle database has complained with an error 257 which means that the output device is full...sure enough the /var/opt/oracle/oradata/archive directory is at 100%. I am unable to start openview, but Im not too sure what all the .arc files in that directory are. Can I delete some to make some space there? Is there somewhere documentation related to this issue?

Thanks for your help
what are we going to do tonight Brain?
Alan Casey
Trusted Contributor

Re: oracle error 257

You should compress the files, and should be able to delete the old ones.

You should only delete files from before your last Full oracle export.

These files are created as the database is in archive mode.
Justo Exposito
Esteemed Contributor

Re: oracle error 257

Hi Kylie,

I suppose that this is your archive logs directory for Oracle database, then you must copy the files to other disk or to a tape, then you can remove it.


Help is a Beatiful word
A. Clay Stephenson
Acclaimed Contributor

Re: oracle error 257


You can copy the lower sequenced files to another directory and then start the database. You really should have a cron process to remove these old archives or your problem will reoccur.
If it ain't broke, I can fix that.