12c Oracle ADG Log switch Hang

First, the environment
12c ADG Environment

Ii. description of the phenomenon

Main Library Log switch stuck (hang)

SQL> alter system switch logfile;

Third, the processing process
1. View Logs

<roidb02:orcldg:/u01/app/oracle/diag/rdbms/orcldg/orcldg/trace>$tail -f al*.logMon Jan 08 21:04:20 2018ARC0: LGWR is scheduled to archive destination LOG_ARCHIVE_DEST_1 after log switchMon Jan 08 21:11:21 2018ARC3: LGWR is scheduled to archive destination LOG_ARCHIVE_DEST_1 after log switchMon Jan 08 21:19:21 2018ARC0: LGWR is scheduled to archive destination LOG_ARCHIVE_DEST_1 after log switchMon Jan 08 21:26:22 2018ARC3: LGWR is scheduled to archive destination LOG_ARCHIVE_DEST_1 after log switchMon Jan 08 21:34:22 2018ARC0: LGWR is scheduled to archive destination LOG_ARCHIVE_DEST_1 after log switchMon Jan 08 21:42:19 2018ARC0: LGWR is scheduled to archive destination LOG_ARCHIVE_DEST_1 after log switch

2. Consider the archive parameters

Sql> Show parameter Log_archive_destname TYPE VALUE-----------------------------                   ------------------------------------------------log_archive_dest stringlog_archive_dest_1 String service= "Orcl", SYNC affirm de lay=0 optional compress                                                 Ion=dis Able Max_failure=0 Max_connect                                                  Ions=1 reopen=300 db_unique_na me= "ORCL" net_timeout=10, Vali                                                 D_for= (online_logfile,all_role                  s) log_archive_dest_10 Stringlog_archive_dest_11 Stringlog_archive_dest_12 Stringname TYPE VALUE--------------------------------------------------- --------------------------log_archive_dest_13 stringlog_archive_dest_14 stringlog_archive_dest_15                  Stringlog_archive_dest_16 stringlog_archive_dest_17 stringlog_archive_dest_18 stringlog_archive_dest_19 stringlog_archive_dest_2 string location= "+dat                                                 Adg/arch ", Vali d_for= (standby_logfile,standby _role)

3, the parameter obviously has the problem, opens another session

SQL> ALTER SYSTEM SET log_archive_dest_2=‘location="+DATADG/arch",  

4. View the main library log

ALTER SYSTEM SET log_archive_dest_2= ' location= "+datadg/arch", valid_for= (all_logfiles,all_roles) ' Scope=both; Mon Jan 21:49:23 2018Archived Log entry 376 added for thread 1 sequence 365 ID 0x58e622f8 dest 2:krse_arc_driver_core: Successful archiving of previously failed Orlmon Jan 08 21:49:23 2018************************************************** Lgwr:setting ' active ' Archival for destination log_archive_dest_1********************************** Mon Jan 21:49:24 2018Destination log_archive_dest_1 no longer supports Synchronizationmon Jan 21:49:24 2018Thread 1 advanced to log sequence 368 (LGWR switch) Current log# 1 seq# 368 mem# 0 : +datadg/orcldg/onlinelog/group_1.399.962961189 Current log# 1 seq# 368 mem# 1: +datadg/orcldg/onlinelog/group_  1.402.962961189Mon Jan 21:49:24 2018Archived Log Entry 377 added for thread 1 sequence 366 ID 0x58e622f8 dest 2:mon Jan 21:49:24 2018Archived Log Entry 378 added for thread 1 sequence 367 ID 0x58e622f8 dest 2:mon Jan 21:49:48 2018Destination log_archive_dest_1 is synchronizedmon Jan 21:49:49 2018Desti Nation log_archive_dest_1 no longer supports Synchronizationmon Jan 21:49:49 2018Thread 1 advanced to LOG sequence 369  (LGWR switch) Current log# 2 seq# 369 mem# 0: +datadg/orcldg/onlinelog/group_2.401.962961191 current log# 2 seq# 369 mem# 1: +DATADG/OR Cldg/onlinelog/group_2.404.962961191mon Jan 21:49:49 2018Archived Log entry 383 added for thread 1 sequence 368 ID 0x58 E622f8 dest 2:

5. Summary
To understand the specific meaning of the local archive path parameter

12c Oracle ADG Log switch Hang