ORA-00257: archiver error. Connect internal only, until freed
今天使用oracle用户登录DB，报错
ORA-00257: archiver error. Connect internal only, until freed
在切换日志后，发现alter system switch logifle
Errors in file /u01/sys_software/grid/diag/rdbms/xhhdb/xhhdb1/trace/xhhdb1_arc0_4322.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 35651584 bytes disk space from 4070572032 limit
ARC0: Error 19809 Creating archive log file to '+ARCHDG'
Tue Jan 29 10:58:13 2013
Archived Log entry 153 added for thread 1 sequence 86 ID 0xda512fb7 dest 1:
Archiver process freed from errors. No longer stopped
Tue Jan 29 10:58:13 2013
Thread 1 advanced to log sequence 88 (LGWR switch)
Current log# 2 seq# 88 mem# 0: +DATADG/xhhdb/onlinelog/group_2.262.804356927
Current log# 2 seq# 88 mem# 1: +ARCHDG/xhhdb/onlinelog/group_2.258.804356927
Tue Jan 29 10:58:14 2013
Archived Log entry 154 added for thread 1 sequence 87 ID 0xda512fb7 dest 1:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 35651584 bytes disk space from 4070572032 limit
ARC0: Error 19809 Creating archive log file to '+ARCHDG'
Tue Jan 29 10:58:13 2013
Archived Log entry 153 added for thread 1 sequence 86 ID 0xda512fb7 dest 1:
Archiver process freed from errors. No longer stopped
Tue Jan 29 10:58:13 2013
Thread 1 advanced to log sequence 88 (LGWR switch)
Current log# 2 seq# 88 mem# 0: +DATADG/xhhdb/onlinelog/group_2.262.804356927
Current log# 2 seq# 88 mem# 1: +ARCHDG/xhhdb/onlinelog/group_2.258.804356927
Tue Jan 29 10:58:14 2013
Archived Log entry 154 added for thread 1 sequence 87 ID 0xda512fb7 dest 1:
查询v$flash_recovery_area_usage得知，原来是archdg的问题
以oracle用户进入rman
1、crosscheck archivelog all;
2、DELETE ARCHIVELOG ALL COMPLETED BEFORE ‘SYSDATE-2′;
2、DELETE ARCHIVELOG ALL COMPLETED BEFORE ‘SYSDATE-2′;
删除了前面的日志，系统正常。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8541492/viewspace-753476/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
