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备份后，未正确清理归档日志导致的。

检查 db_recovery_file_dest 大小与存放目录，确认目录占用空间大小是否已达到配置值；

sqlplus / as sysdba
show parameter db_recovery 

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest
db_recovery_file_dest_size

临时处理办法：
1、手工将归档日志临时移动到备份目录；

2、校验归档日志

rman target /
crosscheck archivelog all;

3、清理过期归档日志

delete expired archivelog all;

4、下一步，需要排查导致归档日志未正常清理的原因