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:

 

查询v$flash_recovery_area_usage得知，原来是archdg的问题

 

以oracle用户进入rman

1、crosscheck archivelog all;
2、DELETE ARCHIVELOG ALL COMPLETED BEFORE ‘SYSDATE-2′;

 

删除了前面的日志，系统正常。

 

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8541492/viewspace-753476/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8541492/viewspace-753476/