Shulou(Shulou.com)06/01 Report--

I. description of the environment

12c has changed a lot. at present, more and more systems are online, and we need to constantly update their knowledge base.

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

Second, the processing process

1. The archive cannot be deleted because the log has not been applied.

2. Improper parameter setting. This example is a parameter setting problem.

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).... Slightly 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... Slightly 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 21240 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 21242 A 2018-01-13 21:11:25 Name: + ARCHDG/ESBDG/ARCHIVELOG/2018_01_13/thread_2_seq_1242.497.965341443747 21243 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 21245 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

Third, the official website document reference

While deleting archived logs from standby (document ID 2169282.1)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.