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.