While trying to register 19c database into RMAN catalog, the following errors occur:
$ rman target / catalog rman/xxxxxxxx@rman Recovery Manager: Release 18.104.22.168.0 - Production on Wed Sep 28 09:43:02 2022 Version 22.214.171.124.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. connected to target database: TESTDB (DBID=9998108000) recovery catalog database Password: connected to recovery catalog database PL/SQL package RMAN.DBMS_RCVCAT version 12.02.00.01. in RCVCAT database is too old RMAN> register database; PL/SQL package RMAN.DBMS_RCVCAT version 12.02.00.01. in RCVCAT database is too old PL/SQL package RMAN.DBMS_RCVCAT version 12.02.00.01. in RCVCAT database is too old RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of register command at 09/28/2022 09:43:21 RMAN-06429: RCVCAT database is not compatible with this version of RMAN
In this situation, The RMAN Oracle database version is 126.96.36.199, the catalog version is 12.02.00.01, and target database to be registered version is 188.8.131.52.0. Since the catalog version must be equal to or greater than the target version, so upgrade catalog is required.
SQL> select * from rman.rcver; VERSION --------------- VERSION ------------ 12.02.00.01
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 19.10.00.00.00 DBMS_RCVMAN package upgraded to version 19.10.00.00 DBMS_RCVCAT package upgraded to version 19.10.00.00. RMAN> register database; database registered in recovery catalog starting full resync of recovery catalog full resync complete
SQL> sqlplus / as sysdba SQL*Plus: Release 184.108.40.206.0 Production on Wed Sep 28 11:22:41 2022 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 220.127.116.11.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> select distinct status from dba_objects where owner='RMAN'; STATUS ------- VALID SQL> select * from rman.rcver; VERSION --------------- 19.10.00.00.00