The Oracle Blog in Spanish

PL/SQL package .DBMS_BACKUP_RESTORE Version is Not Current

If ever after applying a database patch you get one of the following errors in the Alert.log or when connecting to rman:


The version package PL/SQL package .DBMS_BACKUP_RESTORE is not up to date
The version of package PL/SQL package .DBMS_RCVMAN (19.17.00.00) is too old

You should connect to the database as sysdba and execute the following:

sqlplus / as sysdba
SQL> @$ORACLE_HOME/rdbms/admin/dbmsrman.sql
SQL> @$ORACLE_HOME/rdbms/admin/dbmsbkrs.sql
SQL> @$ORACLE_HOME/rdbms/admin/prvtrmns.plb
SQL> @$ORACLE_HOME/rdbms/admin/prvtbkrs.plb

If you then connect to the rman catalog and receive the following error:
"RMAN.DBMS_RCVCAT / CAT.DBMS_RCVMAN version in RCVCAT database is not current error".

Follow the steps outlined in this link:
https://oracleconraul.com/index.php/2024/08/25/rcvcat-database-is-not-current-version/

Oracle ACE Associate