關於RMAN-08137: WARNING: archive log not deleted as it is still needed問題的分析

今天檢查資料庫的備份情況：

SELECT STATUS,OPERATION,TO_CHAR(END_TIME,'YYYY-MM-DD HH24:MI:SS'),COMMAND_ID  FROM V$RMAN_STATUS ORDER BY 4 DESC;

STATUS	OPERATION	TO_CHAR(END_TIME,'YYYY-MM-DDHH	COMMAND_ID
COMPLETED	DELETE	2011-10-31 04:03:37	2011-10-31T02:00:02
COMPLETED	CONTROL FILE AND SPFILE AUTOBACK	2011-10-31 03:58:42	2011-10-31T02:00:02
COMPLETED	RMAN	2011-10-31 04:03:37	2011-10-31T02:00:02
COMPLETED	CONTROL FILE AND SPFILE AUTOBACK	2011-10-31 04:03:34	2011-10-31T02:00:02
COMPLETED	BACKUP	2011-10-31 03:58:42	2011-10-31T02:00:02
COMPLETED WITH WARNINGS	BACKUP	2011-10-31 04:03:34	2011-10-31T02:00:02

發現有個告警資訊，通過檢視備份日誌，發現：

released channel: ORA_DISK_1
released channel: ORA_DISK_2
piece handle=/ora01/db_bak/9rmqc9u3_1_1 tag=TAG20111030T035751 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:04:57
RMAN-08137: WARNING: archive log not deleted as it is still needed

經過研究後確認是由於這個資料庫上配置了oracle stream replication，因為在備份完後進行刪除時，這個歸檔日誌還沒有被capture process解析完，因此就不能刪除，出這樣的告警。

具體的解釋可以參考：Usage of RMAN in Streams Environment [ID 421176.1]

 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/12129601/viewspace-709997/，如需轉載，請註明出處，否則將追究法律責任。