RMAN-20052 error run the resync catalog command

Today I have a problem  when running a backup on a database, this database is a RAC. The error occurs when executing a RESYNC CATALOG command. The output from rman is the following

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of resync command on default channel at 07/15/2013 16:30:39
RMAN-20052: invalid datafile create SCN

Investigating the error, it seems that there is a difference between what we have in the controlfile and what is in the catalog. Looking references at MOS (formerly known as Metalink). I see a bug where we hit, This issue is due to bug 13000553

The solution is to apply the patch that solves it. We have two workarounds;

  •  Make backup using controlfile.
  •  Unregister and register databasethe in catalog may solve this issue.

Of course, the problem is in these two alternatives is that you lose information, such as scripts, historical (the CF has  CONTROL_FILE_RECORD_KEEP_TIME = 30) with “keep forever” clause.



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 )

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s