Skip to main content

Need Help Using Spok Knowledge? 

Spok

ORA-00257

Oracle has its own built-in error codes, which can be found online or via the "oerr" command.


[amcom@amcom1 ~]$ oerr ora 00257

ORA-00257:    archiver error.  Connect internal only, until freed.

Cause:     The archiver process received an error while trying to archive a redo log.  If the problem is not resolved soon, the database will stop executing transactions.  The most likely cause of this message is the destination device is out of space to store the redo log file.

Action:     Check archiver trace file for a detailed description of the problem.  Also verify that the device specified in the initialization parameter ARCHIVE_LOG_DEST is set up properly for archiving.


So, the Oracle error 00257 occurs when there is not enough space on the drive that the database is attempting to store archive redo files on.  In Smart Suite, this is /u06 on a physical server.  On a VM, the files are still within /u06, but the whole server is on a / partition, so it could be anything else.

The Oracle instance itself does not need any attention and will allow logins as soon as there is adequate space.  If the issue isn't ISOs being stored or the nightly backup, it could be that the RMAN backups aren't being cleared appropriately and must be cleaned up, which is not in the scope of this document at this time.


KB26742