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 database

I 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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s