12c ADG無(wú)法刪除備庫(kù)歸檔RMAN-08137

一、環(huán)境描述
12c 變化很大，目前上線的系統(tǒng)越來(lái)越多，大家需要不斷更新自己的知識(shí)庫(kù)。

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 

二、處理過(guò)程
1、備庫(kù)無(wú)法刪除歸檔可能是日志沒(méi)有應(yīng)用
2、參數(shù)設(shè)置不當(dāng)，本例是參數(shù)設(shè)置問(wèn)題

SYS@esbdg> show parameter log_archive_dest_2

NAME                                 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                  string
log_archive_dest_29                  string
SYS@esbdg> show parameter log_archive_dest_state_2

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_2             string      RESET
log_archive_dest_state_20            string      enable
...略
log_archive_dest_state_28            string      enable
log_archive_dest_state_29            string      enable

SYS@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_2

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2                   string
log_archive_dest_20                  string
log_archive_dest_21                  string
log_archive_dest_22                  string
log_archive_dest_23                  string
log_archive_dest_24                  string
log_archive_dest_25                  string
log_archive_dest_26                  string
log_archive_dest_27                  string
log_archive_dest_28                  string
log_archive_dest_29                  string
SYS@esbdg> show parameter log_archive_dest_state_2

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_2             string      ENABLE
log_archive_dest_state_20            string      enable
log_archive_dest_state_21            string      enable
log_archive_dest_state_22            string      enable
log_archive_dest_state_23            string      enable
log_archive_dest_state_24            string      enable
log_archive_dest_state_25            string      enable
log_archive_dest_state_26            string      enable
log_archive_dest_state_27            string      enable
log_archive_dest_state_28            string      enable
log_archive_dest_state_29            string      enable
SYS@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.965332721

739     2    1239    A 2018-01-13 19:52:36
        Name: +ARCHDG/ESBDG/ARCHIVELOG/2018_01_13/thread_2_seq_1239.428.965336957

740     2    1240    A 2018-01-13 21:11:05
        Name: +ARCHDG/ESBDG/ARCHIVELOG/2018_01_13/thread_2_seq_1240.418.965336957

742     2    1241    A 2018-01-13 21:11:06
        Name: +ARCHDG/ESBDG/ARCHIVELOG/2018_01_13/thread_2_seq_1241.549.965336973

746     2    1242    A 2018-01-13 21:11:25
        Name: +ARCHDG/ESBDG/ARCHIVELOG/2018_01_13/thread_2_seq_1242.497.965341443

747     2    1243    A 2018-01-13 22:25:43
        Name: +ARCHDG/ESBDG/ARCHIVELOG/2018_01_13/thread_2_seq_1243.351.965341451

749     2    1244    A 2018-01-13 22:25:54
        Name: +ARCHDG/ESBDG/ARCHIVELOG/2018_01_13/thread_2_seq_1244.615.965341451

750     2    1245    A 2018-01-13 22:26:00
        Name: +ARCHDG/ESBDG/ARCHIVELOG/2018_01_14/thread_2_seq_1245.529.965421539

Do you really want to delete the above objects (enter YES or NO)? yes

三、官網(wǎng)文檔參考

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