12c ADG无法删除备库归档RMAN-08137

一、环境描述
12c 变化很大，目前上线的系统越来越多，大家需要不断更新自己的知识库。

On : 12.1.0.2 version, RAC can't delete archivelog ERROR ----------------------- RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archived log file name=+ARCHDG/ESBDG/ARCHIVELOG/2018_01_11/thread_1_seq_1416.987.965165573 thread=1 sequence=1416 RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archived log file 

二、处理过程
1、备库无法删除归档可能是日志没有应用
2、参数设置不当，本例是参数设置问题

SYS@esbdg> show parameter log_archive_dest_2NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------log_archive_dest_2                   string      service="esbdg", SYNC AFFIRM d                                                 elay=0 optional compression=di                                                 sable max_failure=0 max_connec                                                 tions=1 reopen=300 db_unique_n                                                 ame="esbdg" net_timeout=30, va                                                 lid_for=(online_logfile,all_ro                                                 les)....略log_archive_dest_28                  stringlog_archive_dest_29                  stringSYS@esbdg> show parameter log_archive_dest_state_2NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------log_archive_dest_state_2             string      RESETlog_archive_dest_state_20            string      enable...略log_archive_dest_state_28            string      enablelog_archive_dest_state_29            string      enableSYS@esbdg> alter system set log_archive_dest_2='';System altered.SYS@esbdg> alter system set log_archive_dest_state_2=enable;System altered.SYS@esbdg> SYS@esbdg> show parameter log_archive_dest_2NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------log_archive_dest_2                   stringlog_archive_dest_20                  stringlog_archive_dest_21                  stringlog_archive_dest_22                  stringlog_archive_dest_23                  stringlog_archive_dest_24                  stringlog_archive_dest_25                  stringlog_archive_dest_26                  stringlog_archive_dest_27                  stringlog_archive_dest_28                  stringlog_archive_dest_29                  stringSYS@esbdg> show parameter log_archive_dest_state_2NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------log_archive_dest_state_2             string      ENABLElog_archive_dest_state_20            string      enablelog_archive_dest_state_21            string      enablelog_archive_dest_state_22            string      enablelog_archive_dest_state_23            string      enablelog_archive_dest_state_24            string      enablelog_archive_dest_state_25            string      enablelog_archive_dest_state_26            string      enablelog_archive_dest_state_27            string      enablelog_archive_dest_state_28            string      enablelog_archive_dest_state_29            string      enableSYS@esbdg> RMAN> delete archivelog until time 'sysdate-3';737     2    1238    A 2018-01-13 06:42:30        Name: +ARCHDG/ESBDG/ARCHIVELOG/2018_01_13/thread_2_seq_1238.366.965332721739     2    1239    A 2018-01-13 19:52:36        Name: +ARCHDG/ESBDG/ARCHIVELOG/2018_01_13/thread_2_seq_1239.428.965336957740     2    1240    A 2018-01-13 21:11:05        Name: +ARCHDG/ESBDG/ARCHIVELOG/2018_01_13/thread_2_seq_1240.418.965336957742     2    1241    A 2018-01-13 21:11:06        Name: +ARCHDG/ESBDG/ARCHIVELOG/2018_01_13/thread_2_seq_1241.549.965336973746     2    1242    A 2018-01-13 21:11:25        Name: +ARCHDG/ESBDG/ARCHIVELOG/2018_01_13/thread_2_seq_1242.497.965341443747     2    1243    A 2018-01-13 22:25:43        Name: +ARCHDG/ESBDG/ARCHIVELOG/2018_01_13/thread_2_seq_1243.351.965341451749     2    1244    A 2018-01-13 22:25:54        Name: +ARCHDG/ESBDG/ARCHIVELOG/2018_01_13/thread_2_seq_1244.615.965341451750     2    1245    A 2018-01-13 22:26:00        Name: +ARCHDG/ESBDG/ARCHIVELOG/2018_01_14/thread_2_seq_1245.529.965421539Do you really want to delete the above objects (enter YES or NO)? yes

三、官网文档参考

while deleting archived logs from standby (文档 ID 2169282.1)