Friday, September 3, 2021

PL/SQL package SYS.DBMS_BACKUP_RESTORE version is not current && PL/SQL package SYS.DBMS_RCVMAN version 19.03.00.00 is too old

After upgrading (using AutoUpgrade) from Oracle 12c (12.1.0.2) to Oracle 19c (19.3) and applied patch Oracle 19c (19.12) . Below are the messages in alert log.
  • PL/SQL package SYS.DBMS_BACKUP_RESTORE version  is not current
  • PL/SQL package SYS.DBMS_RCVMAN version 19.03.00.00 is too old
Try to connect rman 

[oracle@primary ~]$ rman target / nocatalog
Recovery Manager: Release 19.0.0.0.0 - Production on Fri Sep 3 04:49:15 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.03.00.00 in TARGET database is not current
PL/SQL package SYS.DBMS_RCVMAN version 19.03.00.00 in TARGET database is not current
connected to target database: ORCLDB (DBID=2506522584)
using target database control file instead of recovery catalog
RMAN>

Connect to the target database and execute the following scripts:

[oracle@primary ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Sep 3 04:50:07 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2021, Oracle.  All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0

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

[oracle@primary ~]$ rman target / nocatalog
Recovery Manager: Release 19.0.0.0.0 - Production on Fri Sep 3 04:50:50 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
connected to target database: ORCLDB (DBID=2506522584)
using target database control file instead of recovery catalog
RMAN>

Hope it helps...

No comments:

Post a Comment