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、下一步,需要排查导致归档日志未正常清理的原因