Flash Recovery Area(db_recovery_file_dest_size)

alert文件出错信息如下：

Errors in file /opt/apps/database/diag/rdbms/iknew/IKNEW1/trace/IKNEW1_arc0_19882.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 429496729600 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.
************************************************************************
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 899678208 bytes disk space from 429496729600 limit
ARC0: Error 19809 Creating archive log file to '+FRA'
ARCH: Archival stopped, error occurred. Will continue retrying

db_recovery_file_dest_size的空间被占用完了，删除多余的归档文件

通过select * from v$recovery_file_dest; 可以查询使用的情况。

打开RMAN  
  
rman target /  
  
RMAN>crosscheck archivelog all;  
    
RMAN>delete expired archivelog all;  

发现并没有设置retention。
  
直接用一个指定的日期来删除  
  
RMAN>delete noprompt archivelog until time "sysdate -7"; 

强制释放了一部分空间。

一般遇到此类问题 的原因是闪回恢复区太小造成的，我这里是因为没有做备份，闪回区已经很大了，所以删除一些归档日志并重新配置策略就可以了。

处理类型问题 的原则：

1 增加闪回区的大小

ALTER SYSTEM SET db_recovery_file_dest_size=size scope=both;

2 归档路径设置到其他的地方

alter system set log_archive_dest = 其他路径；

3  删除或者转移归档日志