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

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

Discover more from XscalibaL

Subscribe now to keep reading and get access to the full archive.

Continue reading