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