【RMAN】Archive Log Not Deleted As It Is Still Needed Rman-08137
在dataGuarad的primary庫,rman中使用backup archivelog all delete input 命令刪除已經歸檔並且已經成功傳送到備庫並且在standby上應用的日誌是遇到
RMAN-08137: WARNING: archive log not deleted as it is still needed
archive log filename=/ora03/oraflsh/RMANCCB/1_3740_580667843.dbf thread=1 sequence=3740
主庫和備庫的alter日誌裡面也會出現 標記為APPLIED='NO'的歸檔日誌初始化失敗。此時儘管日誌已經備份了,但是由於不能刪除導致磁碟空間被佔滿最終會導致資料庫hang住,因為不能產生任何的歸檔日誌了。
在主庫上執行如下語句,最少有一個archivelog 的APPLIED的值為NO:
alter session set nls_date_format='dd-mon-rr hh24:mi:ss';
select recid, dest_id, thread#, sequence#, first_time, completion_time, creator, registrar, archived, applied, deleted, status
from v$archived_log where standby_dest='YES' and status='A';
遇到此類問題的原因是因為主庫的日誌雖然傳送到了備庫並且成功應用,但是對應的在主庫上的日誌條目 在v$archived_log.applied並沒有被更新為‘YES’正是由於該欄位的值為NO ,當使用rman 執行delete input 操作時,rman認為該日誌沒有歸檔且沒有被備庫應用。知道此問題的原因,我們可以使用如下方法解決:
1 檢查備庫和主庫是否有日誌的中斷,如果有,則解決該中斷問題!再次在主庫執行上述sql 語句檢視是否依然有 applied='NO'的日誌條目
2 如果還有歸檔日誌 標記為applied='NO' 並且此日誌已經被備庫應用,主備庫之間沒有gap,我們可以使用os 命令刪除那些歸檔日誌,然後執行:
RMAN>crosscheck archivelog all;
RMAN>delete expired archivelog all;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22664653/viewspace-709064/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 關於RMAN-08137: WARNING: archive log not deleted as it is still needed問題的分析Hivedelete
- RMAN-08137: WARNING: archived log not deleted, needed for standby or upstreamHivedelete
- RMAN-08137: WARNING: Archived Log Not DeletedHivedelete
- How to config (no)archivelog mode and manage archive log files by RMANHive
- RMAN中刪除歸檔時報錯RMAN-08137
- Managing multiple archive log destinations with RMAN (Doc ID 443814.1)Hive
- log_archive_dest與log_archive_dest_n區別Hive
- 處理Oracle的RMAN-08137 RMAN-08515錯誤Oracle
- 11g 上RMAN-08137的處理
- 【轉】詳解log_archive_dest與log_archive_dest_n區別Hive
- 關於 log_archive_dest與log_archive_dest_n a的區別Hive
- rman 刪除v$archive_log檢視裡的記錄(Removing entries in v$archived_log)HiveREM
- Windows 下備份 archive logWindowsHive
- archive log 歸檔日誌Hive
- alter system archive log current noswitch!!Hive
- alter system archive log current / all / switch logfileHive
- Archive Log模式下Redo Log、Check Point和Switch LogHive模式
- logminer工具對redo log或archive log的挖掘Hive
- [Rman]RMAN-06207 WARNING:2 objects could not be deleted for DISK channel(s) dueObjectdelete
- ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DESTHive
- standby_archive_dest和log_archive_dest_n區別Hive
- 使用LOGMNR工具分析Oracle Redo Log和Archive Log教程Oracle RedoHive
- LOG_ARCHIVE_DEST_n詳解Hive
- oracle archive log 歸檔日誌OracleHive
- Nobody is needed
- rman restore archivelog logRESTHive
- Archive log mining steps(logminer to html)HiveHTML
- alter system archive log current和alter system switch logfileHive
- OBIEE 11g users still able to login even with invalid password
- Archivelog & Noarchivelog mode in RMANHive
- Bug 5483067: UNSHIPPED LOGS DELETED DELETION POLICY TO APPLIEDdeleteAPP
- Enabling Archive Log mode in OracleHiveOracle
- Oracle archive log 歸檔日誌管理OracleHive
- db_writer_processes-log_archive_max_processesHive
- alter system switch log file 與 archive log current/all 區別Hive
- RMAN-06207: WARNING: 286 objects could not be deleted for DISK channel(s)Objectdelete
- oracle rman catalogOracle
- 測試log_archive_dest_1與log_archive_format對生成的歸檔檔名的影響HiveORM