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/