ORA-19815: WARNING: db_recovery_file_dest_size of 5218762752 bytes is 100.00% used

平台:

OS:CentOS release 5.5 (Final) 64bit

DB Version:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production RAC

 

现象:

磁盘空间100%,adump目录一直增长

查看alert.log文件

ORA-19815: WARNING: db_recovery_file_dest_size of 5218762752 bytes is 100.00% used, and has 0 remaining bytes available.
************************************************************************
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
   then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
   BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
   reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
   system command was used to delete files, then use RMAN CROSSCHECK and
   DELETE EXPIRED commands.
************************************************************************

 

解决办法:

因此RAC未设定RMAN备份策略

delete  archivelog all completed before 'sysdate - 7' ;

 

再次查看:

sys@RAC>col name format a40
sys@RAC>/

NAME      SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
---------------------------------------- ----------- ---------- ----------------- ---------------
+RECOVERY      5218762752 1018167296   0        46

 

adump audit文件不再产生,后续需设定RMAN备份策略,定期删除归档.