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

I. description of the environment

Oracle 11g RAC

Second, problem description

The customer cannot complete the batch execution for a long time.

III. Problem handling process

1. Check the waiting event SQL > select inst_id,event,count (*) from gv$session where wait_class'Idle' group by inst_id,event order by 1Pol 2 INST_ID EVENT COUNT (*)-2 SQL*Net message to client 1 2 buffer busy waits 4 2 log file switch (archiving needed) 5SQL > 2, View alarm log 2018-04-15 10 332.004000 + 08:00Suppressing further error logging of LOG_ARCHIVE_DEST_1.Suppressing further error logging of LOG_ARCHIVE_DEST_1.ARCH: Archival stopped Error occurred. Will continue retryingORACLE Instance orcl2-Archival ErrorORA-16038: log 22 sequence# 274 cannot be archivedORA-19504: failed to create file "" ORA-00312: onlinelog 22 thread 2:'+ DATADG/orcl/onlinelog/redo22_01.log'Archiver process freed from errors. No longer stoppedARC4: LGWR is actively archiving destination LOG_ARCHIVE_DEST_2ARCH: Archival stopped, error occurred. Will continue retryingORACLE Instance orcl2-Archival ErrorORA-16014: log 22 sequence# 274 not archived No available destinationsORA-00312: onlinelog 22 thread 2:'+ DATADG/orcl/onlinelog/redo22_01.log'3, View ASM disk group [root@roidb2 ~] # su-grid$asmcmd-pASMCMD [+] > lsdgState Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files NameMOUNTED NORMAL N 512 4096 1048576 12288 11362 4096 3633 0 Y CRSDG/MOUNTED EXTERN N 512 4096 1048576 6144 76 0760N DATADG/ASMCMD [+] > 4. Based on the above information, it is found that the ASM disk group space has been exhausted. The archiving operation cannot be performed, and cleaning up some of the archived logs will solve the problem. Here we can easily locate the problem by looking at the wait event.

IV. Refer to the official documents

Resolving Issues Where 'log file switch (archiving needed)' Waits Occur Because Log has not yet been Archived (document ID 1476444.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.