一、环境描述
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_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
三、官网文档参考
while deleting archived logs from standby (文档 ID 2169282.1)
