环境: oracle linux 6.6
oracle 11.2.0.4 rac双机 故障现象: 查询表空间时卡住,过了很久没有反应。 处理过程: 1、尝试清理回收站,命令:purge recyclebin; ,作用:清理回收站,但也是卡住。 2、查看cup与内存状态,都是正常的。 3、查看系统告警日志。 1)命令:select value from v$diag_info where name='Diag Trace';,作用:获取告警日志路径 比如:/u01/app/oracle/diag/rdbms/racdb/racdb1/trace 2)切换到该路径后,命令:tail -1000 alert_[sid].log,作用:查看最后1000条告警日志,发现许多类似告警日志: Mon Sep 14 11:33:07 2020
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance racdb1 - Archival Error
ORA-16038: log 6 sequence# 87016 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 6 thread 1: '+FLASH/racdb/onlinelog/group_6.292.877222559'
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance racdb1 - Archival Error
ORA-16014: log 6 sequence# 87016 not archived, no available destinations
ORA-00312: online log 6 thread 1: '+FLASH/racdb/onlinelog/group_6.292.877222559' 4、查看归档 1)命令:select dest_name,status ,target ,archiver,destination from v$archive_dest;,作用:查看归档文件存放路径与状态,发现其状态是error DEST_NAME STATUS TARGET ARCHIVER DESTINATION
------------------------------ --------------------------- --------------------- ------------------------------ ------------------------------
LOG_ARCHIVE_DEST_1 ERROR PRIMARY ARCH +FLASH
2)命令:lsdg,作用:查看空间使用情况,发现剩余空间只有327m,出现空间不足。 State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 3744768 109691 0 109691 0 N DATA/
MOUNTED EXTERN N 512 4096 1048576 706560 327 0 327 0 N FLASH/
MOUNTED HIGH N 512 4096 4194304 3600 2228 1800 142 0 Y HWOCR_VOTE/
5、登陆rman清理归档文件 1)命令:rlwrap rman target /,作用:用rman登陆当前系统 2)命令:delete archivelog all completed before 'sysdate - 7'; ,作用:删除系统时间7天以前的归档日志,不会删除闪回区有效的归档日志,经过清理后,用命令:lsdg,再次查看空间,发现剩余空间有658145m,至此所有问题都解决了。 |