重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛

标题: RMAN-08137 while Deleting Archived Logs from Standby [打印本页]

作者: 刘泽宇 时间: 4 天前
标题: RMAN-08137 while Deleting Archived Logs from Standby
现象：
Getting below error while deleting archived log from standby even though archived logs have been applied on standby and there is no streams / golden gate configured.

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process .

改动：
Database has been upgraded recently from 11.2.0.4 to 12.1.0.2.

原因：
log_archive_dest_2 on standby which points to primary database was deferred :

log_archive_dest_2 <SERVICE_NAME> ASYNC NOAFFIRM valid_for=(online_logfile,primary_role) db_unique_name=<db_unique_name>
log_archive_dest_state_2= DEFER

This is functionality change in Oracle12c with fix of <bug 16082541>:  RMAN DELETES ARCHIVELOGS WHICH HAVE NOT BEEN APPLIED TO A DEFERRED STANDBY

处理方法：
1.  Enable the destination:

SQL>alter system set log_archive_dest_state_2 = ENABLE;

Once destination 2 is enabled , then Please run the archivelog deletion command on standby from RMAN .

NOTE:  There is no harm in enabling the log_archive_dest_2 on standby , redo will be transported only when standby becomes primary.
2.  If the destination should not be considered, unset the destination rather setting it's state to DEFER.

欢迎光临重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)