7 Eylül 2012 Cuma
ORA-19809: limit exceeded for recovery files
Problem:
Errors in file /home/oracle11g/diag/rdbms/necodb/trace/necodb_arc3_27348.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 790890496 bytes disk space from 4070572032 limit
ARC3: Error 19809 Creating archive log file to '/home/oracle11g/flash_recovery_area/ANKDB/archivelog/2012_09_07/o1_mf_1_9_%u_.arc'
Solution:
increase DB_RECOVERY_FILE_DEST_SIZE(Database recovery files size limit )
alter system set parameter DB_RECOVERY_FILE_DEST_SIZE=integer;
You don't need to restart the instance,this parameter is dynamic:))
Kaydol:
Kayıt Yorumları (Atom)
Hiç yorum yok:
Yorum Gönder