Monday, November 13, 2017

ORA-19809: limit exceeded for recovery files

While trying to duplicate the database using RMAN we are encountering error below:


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '+DATA/qa1tst/datafile/system.593.959955191'

released channel: c1
released channel: c2
released channel: c3
released channel: c4
released channel: c5
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/13/2017 14:24:49
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
ORA-19870: error while restoring backup piece 933347_PRD1DAD_i7sjseoh_1_1
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 65011712 bytes disk space from 128849018880 limit

by looking at the alert logs for the instance we noticed the error that db_recovery_file_dest_size is fully used.

ORA-19815: WARNING: db_recovery_file_dest_size of 128849018880 bytes is 100.00% used, and has 0 remaining bytes available.


That is the reason for this error.

We have increased the size in init parameter while doing recovery and recovery has worked this time.

No comments: