Monday 30 March 2015

ORA -00257 Archiver Error

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 the 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.


you may encounter  with ORA-00257 while connecting to the database.
In this case you have probably suffered  a resource problem in the flash recovery area (FRA) or db_recovery_file_dest_size or in the system.  

Firstly, check if there is enough space in disk.

After then; control archive settings and check the system resources with these related settings :


SQL> archive log list;
SQL> show parameter db_recovery_file_dest;
SQL> SELECT * FROM V$RECOVERY_FILE_DEST;

After correcting system resources related with these settings you should switch log file:
SQL> alter system switch logfile;


and problem solves..

No comments:

Post a Comment