Post applying the database patch sometimes you may get below error in the alert log or RMAN prompt.
PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.05.00.00 in TARGET database is not current
PL/SQL package SYS.DBMS_RCVMAN version 19.05.00.00 in TARGET database is not current
Index
Recent Changes
The above-mentioned errors were reported post applying the database patch.
Cause
Might be that these packages are not being compiled during the upgrade/patching process.
Solution
You need to recompile the RMAN packages and procedures by connecting to the target database as SYSDBA and execute:
$ 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
Before recompilation of the packages –
$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Tue Apr 12 14:13:01 2022 Version 19.14.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.05.00.00 in TARGET database is not current
PL/SQL package SYS.DBMS_RCVMAN version 19.05.00.00 in TARGET database is not current
After recompilation of the packages –
$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Tue Apr 12 14:18:35 2022 Version 19.14.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Hope this document will help you to resolve the SYS.DBMS_BACKUP_RESTORE / SYS.DBMS_RCVMAN related error.
Views: 492