[Solved] Issue: PL/SQL package SYS.DBMS_BACKUP_RESTORE version 18.03.00.00 in TARGET database is not current

Administration, Backup & Recovery / 14/07/2022

Recentemente apliquei um PSU ao meu banco de laboratório 18C, e no momento que logo no RMAN, a mensagem abaixo é reportada:

[oracle@oel8 ~]$ rman target /
 
Recovery Manager: Release 18.0.0.0.0 - Production on Wed Mar 24 04:29:41 2021
Version 18.13.0.0.0
 
Copyright (c) 1982, 2018, Oracle and/or its affiliates.  All rights reserved.
 
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
connected to target database: RMANDB (DBID=3825250984)
 
RMAN> exit
 
 
Recovery Manager complete.

É possível notarmos que o RMAN ainda está trabalhando na 18.03, sendo que o database está na 18.13:

[oracle@oel8 OPatch]$ pwd
/oracle/18.0.0/product/OPatch
[oracle@oel8 OPatch]$ ./opatch lsinventory | grep escript
ARU platform description:: Linux x86-64
Patch description:  "Database Release Update : 18.13.0.0.210119 (32204699)"
Patch description:  "OJVM RELEASE UPDATE: 18.3.0.0.180717 (27923415)"
Patch description:  "OCW RELEASE UPDATE 18.3.0.0.0 (28090553)"

Apesar da nota “PL/SQL package SYS.DBMS_BACKUP_RESTORE Version is Not Current (Doc ID 2741760.1)” ser da 19C para cima, o conceito para recompilar os objetos do RMAN e seu upgrade são os mesmos. Link AQUI.

Iniciando processo descrito na nota que se resume em:

$ 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

Execução:

[oracle@oel8 OPatch]$ sqlplus / as sysdba
 
SQL*Plus: Release 18.0.0.0.0 - Production on Wed Mar 24 04:39:07 2021
Version 18.13.0.0.0
 
Copyright (c) 1982, 2018, Oracle.  All rights reserved.
 
 
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.13.0.0.0
 
SQL> @$ORACLE_HOME/rdbms/admin/dbmsrman.sql
 
Session altered.
 
 
Package created.
 
 
PL/SQL procedure successfully completed.
 
 
PL/SQL procedure successfully completed.
 
 
PL/SQL procedure successfully completed.
 
 
Grant succeeded.
 
 
Grant succeeded.
 
 
Grant succeeded.
 
 
Grant succeeded.
 
 
Grant succeeded.
 
 
PL/SQL procedure successfully completed.
 
 
Synonym dropped.
 
 
View dropped.
 
 
Function dropped.
 
 
Type dropped.
 
 
Type dropped.
 
 
Type dropped.
 
 
Type created.
 
 
Type created.
 
 
Type created.
 
 
Type body created.
 
 
Function created.
 
 
View created.
 
 
Synonym created.
 
 
Synonym created.
 
 
Grant succeeded.
 
 
Synonym dropped.
 
 
View dropped.
 
 
Synonym dropped.
 
 
View dropped.
 
 
Synonym dropped.
 
 
View dropped.
 
 
Function dropped.
 
 
Type dropped.
 
 
Type dropped.
 
 
Type dropped.
 
 
Type created.
 
 
Type created.
 
 
Type created.
 
 
Type body created.
 
 
Function created.
 
 
View created.
 
 
View created.
 
 
Synonym created.
 
 
Synonym created.
 
 
View created.
 
 
View created.
 
 
Synonym created.
 
 
Synonym created.
 
 
View created.
 
 
View created.
 
 
Synonym created.
 
 
Synonym created.
 
 
Grant succeeded.
 
 
Grant succeeded.
 
 
Grant succeeded.
 
 
View created.
 
 
Synonym created.
 
 
Grant succeeded.
 
 
View created.
 
 
Synonym created.
 
 
Grant succeeded.
 
 
View created.
 
 
Synonym created.
 
 
Grant succeeded.
 
 
View created.
 
 
Synonym created.
 
 
Grant succeeded.
 
 
View created.
 
 
Synonym created.
 
 
Grant succeeded.
 
 
View created.
 
 
Synonym created.
 
 
Grant succeeded.
 
 
View created.
 
 
Synonym created.
 
 
Grant succeeded.
 
 
View created.
 
 
Synonym created.
 
 
Grant succeeded.
 
 
View created.
 
 
Synonym created.
 
 
Grant succeeded.
 
 
View created.
 
 
Synonym created.
 
 
Grant succeeded.
 
 
View created.
 
 
Synonym created.
 
 
Grant succeeded.
 
 
View created.
 
 
Synonym created.
 
 
Grant succeeded.
 
 
View created.
 
 
Synonym created.
 
 
Grant succeeded.
 
 
View created.
 
 
Synonym created.
 
 
Grant succeeded.
 
 
View created.
 
 
Synonym created.
 
 
Grant succeeded.
 
 
View created.
 
 
Synonym created.
 
 
Grant succeeded.
 
 
View created.
 
 
Synonym created.
 
 
Grant succeeded.
 
 
View created.
 
 
Synonym created.
 
 
Grant succeeded.
 
 
View created.
 
 
Synonym created.
 
 
Grant succeeded.
 
 
View created.
 
 
Synonym created.
 
 
Grant succeeded.
 
 
View created.
 
 
Synonym created.
 
 
Grant succeeded.
 
 
View created.
 
 
Synonym created.
 
 
Grant succeeded.
 
 
Session altered.
 
SQL>

SQL> @$ORACLE_HOME/rdbms/admin/dbmsbkrs.sql
 
Session altered.
 
 
Package created.
 
 
Session altered.

SQL> @$ORACLE_HOME/rdbms/admin/prvtrmns.plb
 
Session altered.
 
 
Package body created.
 
 
Session altered.

SQL> @$ORACLE_HOME/rdbms/admin/prvtbkrs.plb
 
Session altered.
 
 
Package body created.
 
 
Session altered.

Item resolvido com sucesso:

[oracle@oel8 OPatch]$ rman target /
 
Recovery Manager: Release 18.0.0.0.0 - Production on Wed Mar 24 04:42:17 2021
Version 18.13.0.0.0
 
Copyright (c) 1982, 2018, Oracle and/or its affiliates.  All rights reserved.
 
connected to target database: RMANDB (DBID=3825250984)
 
RMAN>

Leave a Comment

Your email address will not be published.

pt Portuguese
en Englishpt Portuguesees Spanish