ORA-00257 归档日志写入失败异常

ORA-00257 归档日志写入失败异常

问题描述

应用程序连接数据库时提示 ORA-00257 错误

问题分析：

oerr ora 00257
00257, 00000, "Archiver error. Connect AS SYSDBA only until resolved."
// *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 that the destination device is out of space to store the
//       redo log file. Another possible cause is that a destination marked
//       as MANDATORY has failed.
// *Action:  Check the alert log and trace files for detailed error
//        information.

解决办法：

此问题主要是因为rman备份后，未正确清理归档日志导致的。