Mar 12 14:07:17 hnjf18 last message repeated 12 times
Mar 12 14:07:48 hnjf18 SC[SUNWscor.oracle_server.monitor]:hn_acct_db_rg:hn_acct_db_rs:
[ID 440290 local7.error] Archive log destination USE_DB_RECOVERY_FILE_DEST has error condition
'ORA-19809: limit exceeded for recovery files'. Fault monitor transactions will be disabled until the error condition
is cleared
原因:
系统的闪回空间不足引起(闪回空间存放一些备份文件)
调整这个参数db_recovery_file_dest_size 后问题解决
set linesize 400
col name for a40
select substr(name,1.30) name,space_limit as quota,space_used used,space_reclaimable reclaimable,
number_of_files files from v$recovery_file_dest;
NAME QUOTA USED RECLAIMABLE FILES
---------------------------------------- ---------- ---------- ----------- ----------
/xzflash_recovery_area 6.4425E+10 5.3525E+10 0 108
检查使用状况
select * from v$flash_recovery_area_usage;
show parameter DB_RECOVERY
alter system set DB_RECOVERY_FILE_DEST_SIZE=70g;
修改闪回存放的路径：
alter system set db_recovery_file_dest='c:\life';
RMAN> delete archivelog all;
手工逻辑删除归档日至，在这里也就是释放了闪回空间
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22779291/viewspace-667542/ ，如需转载，请注明出处，否则将追究法律责任。
