Site icon IT Tutorial

RMAN-06429: RCVCAT database is not compatible with this version of RMAN

Hi,

When connect to RMAN catalog databasei you can get RMAN-06429: RCVCAT database is not compatible with this version of RMAN error because of version incompatibility between RMAN catalog database and Production database.

 

RMAN> connect catalog rman/rman123@CATALOG_DB

connected to recovery catalog database
PL/SQL package RMAN.DBMS_RCVCAT version 11.02.00.04 in RCVCAT database is too old

RMAN> Register Database;

PL/SQL package RMAN.DBMS_RCVCAT version 11.02.00.04 in RCVCAT database is too old
PL/SQL package RMAN.DBMS_RCVCAT version 11.02.00.04 in RCVCAT database is too old
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of register command at 01/20/2017 15:23:52
RMAN-06429: RCVCAT database is not compatible with this version of RMAN

 

Then go to Catalog Database server and connect to catalog database, execute following scripts to solve this problem.

 

SQL> @?/rdbms/admin/dbmsrmansys.sql


SQL> @?/rdbms/admin/dbmsrmanvpc.sql

 

 

RMAN> connect catalog rman/rman123@CATALOG_DB

connected to recovery catalog database
PL/SQL package RMAN.DBMS_RCVCAT version 11.02.00.04 in RCVCAT database is too old

RMAN> upgrade catalog;

recovery catalog owner is RMAN
enter UPGRADE CATALOG command again to confirm catalog upgrade
RMAN> upgrade catalog;

error creating modify_bdf_pdb_key_not_null
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06004: ORACLE error from recovery catalog database: ORA-02296: cannot enable (RMAN.) - null values found

RMAN> exit

If you got above errors you need to delete table bdf table like below.

 

SQL> delete RMAN.bdf where not exists (select 1 from rman.dbinc where dbinc.dbinc_key = bdf.dbinc_key);
SQL> delete RMAN.bcf where not exists (select 1 from rman.dbinc where dbinc.dbinc_key = bcf.dbinc_key);
commit;

 

Then try to Upgrade catalog again.

 

 

RMAN> upgrade catalog;

recovery catalog owner is RMAN
enter UPGRADE CATALOG command again to confirm catalog upgrade

RMAN> upgrade catalog;

recovery catalog upgraded to version 12.01.00.02
DBMS_RCVMAN package upgraded to version 12.01.00.02
DBMS_RCVCAT package upgraded to version 12.01.00.02.

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/

 1,744 views last month,  1 views today

Exit mobile version