ORACLE RAC归档磁盘组空间满的表现

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

对于ADG的归档清理，建议在主备库使用rman target /，然后执行delete archive all ，让rman来判断并自助决定哪些归档可以删除；或者使用DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7';命令删除7天前的归档文件。切勿使用rm -rf *.arc 这样会导致主从同步中断。