ORA-19815-Oracle11g RAC 停机

来源：互联网发布：淘宝开店虚拟商品编辑：程序博客网时间：2024/04/27 11:56

平台:

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    spacefile name      (mb)     (mb)(mb)  files-------------------------------- --------- -------- -------- ------+FRA  10240.00  4734.00 .00196

删除archivelog释放空间.

再次查询

     space    space    reclm     limit     used    spacefile 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    spacefile name      (mb)     (mb)(mb)  files-------------------------------- --------- -------- -------- ------+FRA  10240.00  1241.00 .00 46