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:))

Hiç yorum yok:

Yorum Gönder