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	 .00	196

删除archivelog释放空间.

再次查询

				     space    space    reclm
				     limit     used    space
file name			      (mb)     (mb)	(mb)  files
-------------------------------- --------- -------- -------- ------
+FRA				  10240.00  4734.00	 .00	196

查询使用情况,确认已生效

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