IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
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/
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.
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.