<<Back to Oracle DataGuard Main Page
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process happening on Physical Standby Database
CauseIn one of my Physical standby database version 12.1.0.2 the above error appeared. After spending an hour looking various RMAN setting and configuration I found that value of log_archive_dest_state_2 parameter was not enabled, which eventually caused this issue.
SQL> show parameter dest_state_2
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_2 string RESET
Solution:
Enable parameter log_archive_dest_state_2
SQL> alter system set log_archive_dest_state_2=enable;
System altered.
SQL> show parameter dest_state_2
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_2 string ENABLE
Comments
Post a Comment