Sunday, September 30, 2018

RMAN Recovery Catalog Issues after 12.2 Upgrade


Well, after the upgrade of the DB to 12.2 the next step is to upgrade the RMAN Recovery Catalog to the same version in order to be able to run backups using it. The process is pretty straight forward.
.    Connect to RMAN using target and catalog
.    Execute upgrade catalog

RMAN> upgrade catalog;

This finishes correctly. But then we try to resync the catalog we got below error:

RMAN> resync catalog;

starting full resync of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of resync command on default channel at 06/07/2018 22:15:36
ORA-01403: no data found


This is due to a bug 27013146. The solution is to apply this patch to the newly upgraded Oracle Home and re-run the upgrade catalog again.

More information can be found in MOS Note 2341947.1.

Everything is cool now, right? Well, now the old 12.1.0.2 database backups are failing with below error:

RMAN-03008: error while performing automatic resync of recovery catalog

For that, the solution is outlined in MOS Doc Id 2291791.1.

Happy 12.2 upgrades!

Thanks,
Alfredo


No comments:

Post a Comment