今天检查数据库的备份情况：

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博客

关于RMAN-08137: WARNING: archive log not deleted as it is still needed问题的分析

最新文章