I was in the process of building a physical standby that had to be put on hold for a few days while other more pressing priorities were handled. I thought it would be sufficient to change the below parameter:
NAME TYPE VALUE log_archive_dest_state_2 string DEFER
However, I then noticed that the time taken by the archived log backup script had increased from a couple of minutes to over three hours. This was because the archived logs were no longer being deleted as RMAN was displaying the below message:
channel disk2: backup set complete, elapsed time: 00:01:35 channel disk2: deleting archived log(s) RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archived log file name=/archlogs/1_3426_959714474.arc thread=1 sequence=3426 RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archived log file name=/archlogs/1_3427_959714474.arc thread=1 sequence=3427
In order to resolve this issue I had to remove the entry for the physical standby in the below parameter:
NAME TYPE VALUE log_archive_dest_2 string
After this was done, the next run of the archived log backup process completed in a few minutes and subsequent runs returned to the expected couple of minutes execution time.
