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

I. Environment

12c ADG environment

II. Description of phenomena

The main database log switch is stuck (hang)

SQL > alter system switch logfile

Third, the processing process

1. View the log

$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 archiving 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 compression=dis able max_failure=0 max_connect ions=1 reopen=300 db_unique_na me= "orcl" net_timeout=10 Vali dudes 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= "+ DATADG/arch" Vali dudes for = (STANDBY_LOGFILE,STANDBY _ ROLE)

3. There is an obvious problem with the parameters. Open another session.

SQL > ALTER SYSTEM SET log_archive_dest_2='location= "+ DATADG/arch", valid_for= (ALL_LOGFILES,ALL_ROLES)'; System altered.SQL >

4. View the main database log

ALTER SYSTEM SET log_archive_dest_2='location= "+ DATADG/arch", valid_for= (ALL_LOGFILES,ALL_ROLES) 'SCOPE=BOTH Mon Jan 08 21:49:23 2018Archived Log entry 376added for thread 1 sequence 365ID 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 08 21:49:24 2018Destination LOG_ARCHIVE_DEST_1 no longer supports SYNCHRONIZATIONMon Jan 08 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 08 21:49:24 2018Archived Log entry 377 added for thread 1 sequence 366 ID 0x58e622f8 dest 2:Mon Jan 08 21:49:24 2018Archived Log entry 378 added for thread 1 sequence 367 ID 0x58e622f8 dest 2:Mon Jan 08 21:49:48 2018Destination LOG_ARCHIVE_DEST_1 is SYNCHRONIZEDMon Jan 08 21:49:49 2018Destination LOG_ARCHIVE_DEST_1 no longer Supports SYNCHRONIZATIONMon Jan 08 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/ORCLDG/ONLINELOG/group_2.404.962961191Mon Jan 08 21:49:49 2018Archived Log entry 383 added for thread 1 sequence 368 ID 0x58e622f8 dest 2:

5. Summary

To understand the specific meaning of local archive path parameters

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.