Site icon IT Tutorial

PL/SQL package SYS.DBMS_BACKUP_RESTORE and SYS.DBMS_RCVMAN Version is Not Current in Oracle

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 19.0.0.0.0 - Production on Thu Sep 30 13:38:00 2021
Version 19.11.0.0.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

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

Exit mobile version