RMAN Catalog Upgrade - DBMS.RCVCAT Version in RCVCAT database is not Current
RMAN Catalog Upgrade
Oracle Database upgrade is routine activity for Oracle DBA and with new database versions coming upgrading Database has become important to make sure you database does not go out of support. In this blog , We will discuss about a common problem which faced by DBA post DB upgrade. When your RMAN catalog is at the lower version WRT to you client Database then you get error "PL/SQL Package DBMS.RCVCAT Version in RCVCAT database is not Current" .
In order to resolve this issue , We need to upgrade our RMAN Catalog. Below are the Steps to upgrade RMAN Catalog:
1) Take
the export backup of RMAN catalog owner account.
expdp catlog_own/******* directory=dump1 dumpfile=RMANcatalog_own.dmp
2) Connect to RMAN Catalog and any client with higher version of the DB.
rman target / catalog catalog_own/******@catalogdb.WORLD
3) Perform Catalog upgrade.
RMAN> upgrade catalog;
Recovery catalog owner is CATALOG_OWN
enter UPGRADE CATALOG command again to confirm catalog upgrade
Note – At this step the catalog will reconfirm whether you really want to upgrade. Run the upgrade catalog command again.
RMAN> upgrade catalog;
recovery catalog upgraded to version 12.02.00.03
DBMS_RCVMAN package upgraded to version 12.02.00.03
DBMS_RCVCAT package upgraded to version 12.02.00.03
You can learn more about oracle database administration:
Pro Oracle GoldenGate for the DBA
Oracle Security Tools Installation and Configuration
Comments
Post a Comment
Please do not enter any spam link in comment Section suggestions are Always Appreciated. Thanks.. !