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; 來刪除控制檔案中的備份資訊。