Pages

Wednesday, 3 June 2015

ORA-19809: limit exceeded for recovery files ORA-19804: cannot reclaim

During RMAN restoration on UAT got the below error.

ERROR:
RMAN-03002: failure of restore command at 06/03/2015 09:42:32
ORA-19870: error while restoring backup piece /dump/RMANBK/backupfile/Db_.39373.1.881387571.20150603.bak
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 18874368 bytes disk space from 32212254720 limit

Solution:
Increase the size of DB_RECOVERY_FILE_DEST_SIZE in initSID.ora file and then restart the recovery.
SQL> shut immediate
#Increase the value DB_RECOVERY_FILE_DEST_SIZE in init file
SQL> startup nomount
RMAN>  start the recovery.

Note: If you use spfile then change using

alter system set DB_RECOVERY_FILE_DEST_SIZE=g scope=BOTH;
then start the recovery

No comments:

Post a Comment