While trying to register 19c database into RMAN catalog, the following errors occur:
$ rman target / catalog rman/xxxxxxxx@rman
Recovery Manager: Release 19.0.0.0.0 - Production on Wed Sep 28 09:43:02 2022
Version 19.10.0.0.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
SOLUTION
In this situation, The RMAN Oracle database version is 12.1.0.2, the catalog version is 12.02.00.01, and target database to be registered version is 19.10.0.0.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 12.1.0.2.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 12.1.0.2.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