标题: db_recovery_file_dest恢复区的空间保留问题 [打印本页] 作者: jiawang 时间: 6 天前 标题: db_recovery_file_dest恢复区的空间保留问题 恢复区保留问题：
Files being deleted in the flash recovery area, messages in the alert log Deleted Oracle managed file filename (Doc ID 1369341.1)
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 4
Next log sequence to archive 6
Current log sequence 6
SQL> show parameter reco;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
db_recovery_file_dest string +RECOC1
db_recovery_file_dest_size big integer 4T
11.2版本以后，默认空间使用率达到80%以后就开始删除文件（归档日志）
查询空间使用率：
select * from V$FLASH_RECOVERY_AREA_USAGE;
SELECT substr(name, 1, 30) name
, space_limit/(1073741824) AS Quota_GB
, space_used/(1073741824) AS Used_GB
, space_reclaimable/(1073741824) AS Reclaimable_GB
, number_of_files AS files
FROM V$RECOVERY_FILE_DEST ;
如果空间紧张，可以通过调整下面参数，比如设置90%后才会删除归档日志
alter system set event='19823 trace name context forever,level 90' scope=spfile sid='*';