oracle数据库日常维护中,服务器的资源使用情况很重要,尤其是CPU、内存、磁盘空间、IO等。这里贡献一个oracle 11g rac 归档磁盘组空间满的一个报错日志,看到这种报错代码,就可以定义为归档磁盘空间满,应采取清理归档文件,但是对于复杂的环境,如ADG等,要视情况而定,切莫盲目清理,否则将出现严重的问题,如ADG重建。
2022-04-14T13:17:14.334334+08:00 Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl02/trace/orcl02_arc0_58664.trc: ORA-19504: failed to create file "+ARCH" ORA-17502: ksfdcre:4 Failed to create file +ARCH ORA-15041: diskgroup "ARCH" space exhausted ARC0 (PID:58664): Error 19504 Creating archive log file to '+ARCH' ARC0 (PID:58664): Stuck archiver: insufficient local LADs ARC0 (PID:58664): Stuck archiver condition declared 2022-04-14T13:17:14.359223+08:00 Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl02/trace/orcl02_arc0_58664.trc: ORA-16038: log 10 sequence# 4558 cannot be archived ORA-19504: failed to create file "" ORA-00312: online log 10 thread 2: '+DATA/orcl/redo10.log' ORA-00312: online log 10 thread 2: '+DATA/orcl/redo10_2.log' ARC0 (PID:58664): Archival error occurred on a closed thread, archiver continuing 2022-04-14T13:17:14.359304+08:00 ORACLE Instance orcl02, archival error, archiver continuing
对于ADG的归档清理,建议在主备库使用rman target /,然后执行delete archive all ,让rman来判断并自助决定哪些归档可以删除;或者使用 DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7';命令删除7天前的归档文件。切勿使用rm -rf *.arc 这样会导致主从同步中断。