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/

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

2 comments

  1. Good blog post. Things i would like to bring up is that laptop memory is required to be purchased in case your computer can’t cope with that which you do with it. One can put in two random access memory boards containing 1GB each, for example, but not certainly one of 1GB and one having 2GB. One should make sure the manufacturer’s documentation for the PC to make sure what type of storage it can take.

  2. Your RMAN-06429 references TARGET. Since your database is TARGET, the resolution to your RMAN-06429 will be to correct the compatibility problem between the database and RMAN.

Leave a Reply

Your email address will not be published. Required fields are marked *