log file switch (archiving needed) 等待事件一例

大佬教程收集整理的这篇文章主要介绍了log file switch (archiving needed) 等待事件一例，大佬教程大佬觉得挺不错的，现在分享给大家，也给大家做个参考。

一、环境描述@H_450_1@Oracle 11g RAC

二、问题描述@H_450_1@客户执行批处理长时间无法完成。

三、问题处理过程

1、查看等待事件
sql> select inst_id,event,count(*) from gv$session where wait_class<>'IDle' group by inst_ID,event order by 1,2;

   INST_ID EVENT                                 COUNT(*)
---------- ----------------------------------- ----------
         2 sql*Net message to clIEnt                    1
         2 buffer busy waits                            4
         2 log file switch (archiving needed)           5

sql> 

2、查看告警日志
2018-04-15 10:33:02.004000 +08:00
Suppressing further error logging of LOG_ARCHIVE_DEST_1.
Suppressing further error logging of LOG_ARCHIVE_DEST_1.
ARCH: Archival stopped,error occurred. Will conTinue retrying
OracLE Instance orcl2 - Archival Error
ORA-16038: log 22 SEQUENCE# 274 cAnnot be archived
ORA-19504: Failed to create file ""
ORA-00312: online log 22 thread 2: '+DATADG/orcl/onlinelog/redo22_01.log'
Archiver process freed from errors. No longer stopped
ARC4: LGWR is actively archiving desTination log_archive_dest_2
ARCH: Archival stopped,error occurred. Will conTinue retrying
OracLE Instance orcl2 - Archival Error
ORA-16014: log 22 SEQUENCE# 274 not archived,no available desTinations
ORA-00312: online log 22 thread 2: '+DATADG/orcl/onlinelog/redo22_01.log'

3、查看ASM磁盘组
[root@roIDb2 ~]# su - grID
<roIDb2:+ASM2:/home/grID>$asmcmd -p
ASMCMD [+] > lsdg
State    Type    Rebal  Sector  Block       AU  total_mb  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  VoTing_files  name
MOUNTED  norMAL  N         512   4096  1048576     12288    11362             4096            3633              0             Y  CRSDG/
MOUNTED  EXTERN  N         512   4096  1048576      6144       76                0              76              0             N  DATADG/
ASMCMD [+] > 

4、通过以上信息发现ASM磁盘组空间已被耗尽，无法进行归档操作，清理部分归档日志即可解决问题。这里我们通过查看等待事件很容易定位到问题。

四、参考官方文档

Resolving Issues Where 'log file switch (archiving needed)' Waits Occur Because Log has not yet been Archived (文档 ID 1476444.1)

大佬总结

以上是大佬教程为你收集整理的log file switch (archiving needed) 等待事件一例全部内容，希望文章能够帮你解决log file switch (archiving needed) 等待事件一例所遇到的程序开发问题。

如果觉得大佬教程网站内容还不错，欢迎将大佬教程推荐给程序员好友。

本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ：384754419，请注明来意。