Oracle 18c backup may show an error "TARGET database is not current" in the RMAN output section of the backup job log.
Article ID: 100048346
Updated On:
Description
Error Message
RMAN output in the job log will report the following error
PL/SQL package SYS.DBMS_BACKUP_RESTORE version 18.03.00.00 in TARGET database is not current
PL/SQL package SYS.DBMS_RCVMAN version 18.03.00.00 in TARGET database is not current
Cause
This issue can occur if the Oracle Database has been updated from Oracle 18.03 to 18.10.
Resolution
This error does not affect the backup operation. The backup job will be successful but RMAN output may display the above error.
To resolve this issue recompilation is required for existing databases that have been migrated from 18.03 to 18.10. Following scripts are required to run on the databases reporting this issue. Please consult Oracle DBA or Oracle Support for more information or assistance on running this scripts.
SQL> @?\rdbms\admin\dbmsrman.sql
SQL> @?\rdbms\admin\prvtrmns.plb
SQL> @?\rdbms\admin\dbmsbkrs.sql
SQL> @?\rdbms\admin\prvtbkrs.plb
Reference:- Oracle Support SR - SR 3-23475196301 : TARGET database not current after updating to 18.10 on Windows
Issue/Introduction
