平台:
OS:Red Hat Enterprise Linux Server release 5.5
DB:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
现象:
space space reclm
limit used space
file name (mb) (mb)(mb) files
-------------------------------- --------- -------- -------- ------
+FRA 10240.00 4734.00 .00196
删除archivelog释放空间.
再次查询
space space reclm
limit used space
file name (mb) (mb)(mb) files
-------------------------------- --------- -------- -------- ------
+FRA 10240.00 4734.00 .00196
查询使用情况,确认已生效
SQL> select sum(percent_space_used)*4/100 from v$flash_recovery_area_usage;
SUM(PERCENT_SPACE_USED)*4/100
-----------------------------
1.8492
解决方法:
检查archivelog状态,删除失效信息.
rman target / crosscheck archivelog all; delete expired archivelog all; 再次查询
space space reclm
limit used space
file name (mb) (mb)(mb) files
-------------------------------- --------- -------- -------- ------
+FRA 10240.00 1241.00 .00 46