PL/SQL package RCAT.DBMS_RCVCAT version 11.02.00.04 in RCVCAT database is too old’ in 19c database

Cause:

Your rman executable is too old for 19c database to perform rman backups

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

Workaround:

If you are not sure what you do,then enable guaranteed flashback restore point if it is an enterprise edition

SQL> create restore point GUA guarantee flashback database;

Restore point created.

SQL> select current_scn from v$database;

CURRENT_SCN
-----------
    2280317

SQL> select scn_to_timestamp(2280317) from dual;

SCN_TO_TIMESTAMP(2280317)
---------------------------------------------------------------------------
28-JUL-21 09.44.20.000000000 PM

Upgrade the catalog to new version

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.

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