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-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
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.