ORACLE 10G flash_recovery_area

(我的学习笔记)

今天查看错误日志法相 flash_recovery_area  区域已经满了。flash_recovery_area  区域是在默认的情况下保存RMAN和ARCHIVELOG的地方 默认大小为2G 所以会经常出现不足的情况，当然处理方法有4种、

You have the following choices to free up space from
flash recovery area:
1. Consider changing your RMAN retention policy.
   If you are using dataguard, then consider changing your
   RMAN archivelog deletion policy.
2. Backup files to tertiary device such as tape using the
   RMAN command BACKUP RECOVERY AREA.
3. Add disk space and increase the db_recovery_file_dest_size
   parameter to reflect the new space.
4. Delete unncessary files using the RMAN DELETE command.
   If an OS command was used to delete files, then use
   RMAN CROSSCHECK and DELETE EXPIRED commands.

我删除了物理级别的RMAN信息后 查看

SQL> select substr(name,1,30) name,space_limit as quota,space_used as used,
  2  space_reclaimable as reclaimable,number_of_files as files from v$recovery_file_dest;

NAME                                                              QUOTA
------------------------------------------------------------ ----------
      USED RECLAIMABLE      FILES
---------- ----------- ----------
E:\flash_recovery_area                                       4294967296
1746919424           0          2

任然有记录，所以可以看出这个参数应该是查看的控制文件信息，即使你使用物理级别的删除，控制文件并没有更新所以使用：

CROSSCHECK BACKUP;

DELETE EXPIRED BACKUP; 来删除控制文件中的备份信息。