Home > Oracle > ORA-19809: limit exceeded for recovery files during rman duplicate 11g r2

ORA-19809: limit exceeded for recovery files during rman duplicate 11g r2

RMAN  DUPLICATE command fails during media recovery with the following error


RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not mounted
ORA-06512: at "SYS.X$DBMS_RCVMAN", line 13466
ORA-06512: at line 1
RMAN-03015: error occurred in stored script Memory Script
RMAN-10035: exception raised in RPC:
ORA-19583: conversation terminated due to error
ORA-19870: error while restoring backup piece /rmanprod/oradata/ukprod/ora_df812148649_s75_s1
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 2488320 bytes disk space from 53687091200 limit
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 2338
RMAN-10031: RPC Error: ORA-19583  occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/09/2013 09:03:04
RMAN-05501: aborting duplication of target database

RMAN fails while it is trying to restore archivelogs that will be used for media recovery. It tells you that there is not
enough space in the FRA (of the auxiliary database) to restore the archivelogs, even when the FRA for the auxiliary database is totally empty.
The problem is due to a bug which makes RMAN to take the FRA usage (ignoring the value of reclaimable space) of the target database and
compare that to FRA size of the auxiliary database.

Workaround

If you cannot have the same FRA size for the auxiliary database as the target database, then the workaround we use to solve this problem with cloning databases, is to just increase the size of the FRA (parameter db_recovery_file_dest_size) on the auxiliary database to be bigger than the used space (including reclaimable space!) of the FRA for the target database.
If you don’t have enough physical disk space available for the FRA for the auxiliary database then you can  just temporarily
increase the db_recovery_file_dest_size parameter to a value that’s bigger than the physical available space.
It is just to make RMAN happy when it checks the FRA usage and it will proceed with the media recovery. After you have finished the
clone you can resize the db_recovery_file_dest_size parameter again to its original value.

Patch

This bug is registered by Oracle support as Bug 13741583 – RMAN duplication erroneously fails with ORA-19804 using fast recovery area [ID 13741583.8].

Advertisements
Categories: Oracle
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: