空间限制导致日志不能归档

Errors in file /opt/oracle/diag/rdbms/iptvcms/iptvcms/trace/iptvcms_arc3_7565.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 3247616 bytes disk space from 2147483648 limit
ARC3: Error 19809 Creating archive log file to '/opt/oracle/flash_recovery_area/IPTVCMS/archivelog/2012_10_14/o1_mf_1_8_%u_.arc'

 

从上面的日志看是空间不足导致。通知如下语句查看

select × from v$flash_recovery_area_usage;

 

增加空间

alter system set db_recovery_file_dest_size=4g scope=both;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28263989/viewspace-746371/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28263989/viewspace-746371/