oracle rac 停机,ORA-19815-Oracle11g RAC 停机

平台:

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