DOES ORACLE 19C CATALOG DATABASE COMPATIBLE WITH 11G DATABASE?
Often there is a misconception, when we upgrade a database from 11g or 12c to 19c higher database version, backup fails due to compatibility errors or older rman executables. We have to upgrade catalog database in parallel during 19c upgrade. Otherwise backup fails with error ‘PL/SQL package RCAT.DBMS_RCVCAT version 11.02.00.04 in RCVCAT database is too old‘ in 19c database
After upgrade i tried to connect to catalog database with older RCAT.DBMS_RCVCAT version. I couldnot take backup as well
[oracle@orcl19x ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Wed Jul 28 20:46:13 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL19X1 (DBID=2012336792)
RMAN> connect catalog rcat/password@orcl19x1;
connected to recovery catalog database
PL/SQL package RCAT.DBMS_RCVCAT version 11.02.00.04 in RCVCAT database is too old
I upgraded the catalog from 19c database using below command. Most probably,we get recommendations in post check script during upgrade itself. So its always better to upgrade the catalog database. If not you might get into trouble of backup failures
RMAN> upgrade catalog;
recovery catalog owner is RCAT
enter UPGRADE CATALOG command again to confirm catalog upgrade
RMAN> upgrade catalog;
recovery catalog upgraded to version 19.03.00.00.00
DBMS_RCVMAN package upgraded to version 19.03.00.00
DBMS_RCVCAT package upgraded to version 19.03.00.00.Connect to the catalog from 11g database if any running on the same system
[oracle@orcl19x admin]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Wed Jul 28 19:17:42 2021
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL11X (DBID=3093583854)
RMAN> connect catalog rcat/password@orcl19x1;
connected to recovery catalog databaseI registered the 19c catalog database to 11g which didnot throw any error
RMAN> create catalog;
recovery catalog already exists
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
I tested a backup to ensure that i dont run into future backup hurdles
RMAN> list backup of database;
specification does not match any backup in the repository
RMAN> backup as compressed backupset database;
Try connecting from sqlplus and check the catalog version
SQL> connect rcat/password@orcl19x1;
SQL> select * from rcver;
VERSION
---------------
19.03.00.00.00
Below is the compatibility matrix from oracle documents
If the database version is greater than 10.2.0.3 then 19x catalog version will be supported
19.x = target database executable >= 10.2.0.3