2011.1.13報錯。.ORA-00257: archiver error. Connect internal only, until freed.

ORA-00257: archiver error. Connect internal only, until freed.錯誤

 

檢視crontab自動備份，發現資料庫已經有很多天沒有備份了。沒有備份說明歸檔日誌一直沒有刪除，查詢dba_data_files資料字典無法成功。

檢視actlog：

jldcdb01:/oracle/admin/dcmds01/bdump$ tail -5000 alert_dcmds01.log|pg
************************************************************************
Wed Jan 12 21:04:12 2011
Errors in file /oracle/admin/dcmds01/udump/dcmds01_ora_324346.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 429496729600 bytes is 95.61% used, and has 18860736512 remaining bytes available.
Wed Jan 12 21:04:12 2011
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
   then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
   BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
   reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
   system command was used to delete files, then use RMAN CROSSCHECK and
   DELETE EXPIRED commands.

 

隨著時間分秒過去最後歸檔將快速恢復區漲滿。

Thu Jan 13 03:29:24 2011
ORACLE Instance dcmds01 - Archival Error
Thu Jan 13 03:29:24 2011
ORA-16014: log 2 sequence# 37547 not archived, no available destinations
ORA-00312: online log 2 thread 1: '+ORADG/dcmds01/redo02.log'
Thu Jan 13 03:29:24 2011
Errors in file /oracle/admin/dcmds01/bdump/dcmds01_arc0_434230.trc:
ORA-16014: log 2 sequence# 37547 not archived, no available destinations
ORA-00312: online log 2 thread 1: '+ORADG/dcmds01/redo02.log'
Thu Jan 13 03:34:24 2011
ARCH: Archival stopped, error occurred. Will continue retrying
Thu Jan 13 03:34:24 2011
ORACLE Instance dcmds01 - Archival Error

 

 

解決辦法：

很明顯是db_recovery_file_dest 的空間滿了。

執行rman> delete archivelog until time 'sysdate-1' ;

刪除不需要的archive log檔案。一切OK。

之後手動跑一遍rman備份。一切正常。

收穫經驗，快速閃回區一定要定期檢查。