I got ” PL/SQL package SYS.DBMS_BACKUP_RESTORE and SYS.DBMS_RCVMAN Version is Not Current in Oracle ” error in the Oracle database.
PL/SQL package SYS.DBMS_BACKUP_RESTORE and SYS.DBMS_RCVMAN Version is Not Current in Oracle
Details of error are as follows.
Recovery Manager: Release 220.127.116.11.0 - Production on Thu Sep 30 13:38:00 2021 Version 18.104.22.168.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.08.00.00 in TARGET database is not current PL/SQL package SYS.DBMS_RCVMAN version 19.08.00.00 in TARGET database is not current connected to target database: MSDB (DBID=2054866743)
RMAN or Alert.log showing messages:
PL/SQL package SYS.DBMS_BACKUP_RESTORE version is not current PL/SQL package SYS.DBMS_RCVMAN version 19
These errors were reported after applying a database patch.
It seems that these packages are not being compiled during the upgrade/patching process.
To solve this error, Recompile the RMAN packages and procedures by connecting to the target database as SYSDBA and execute as follows.
$ 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
25,028 views last month, 7 views today