Wednesday, December 16, 2020

How to fix error SYS.DBMS_BACKUP_RESTORE version 18.11.00.00 in TARGET database is not current

Even if you're not using a recovery catalog, you may encounter this issue if you have recently patched your database. Simply by connecting to the target database as sysdba, you can verify that you need to update your internal packages:
oracle@myserver.mydomain.com:[proddb01]# rman target / nocatalog

Recovery Manager: Release 18.0.0.0.0 - Production on Wed Dec 16 13:51:43 2020
Version 18.12.0.0.0

Copyright (c) 1982, 2018, Oracle and/or its affiliates.  All rights reserved.

PL/SQL package SYS.DBMS_BACKUP_RESTORE version 18.11.00.00 in TARGET database is not current
PL/SQL package SYS.DBMS_RCVMAN version 18.11.00.00 in TARGET database is not current
connected to target database: PRODDB01 (DBID=1234567890)
using target database control file instead of recovery catalog
Solution: Follow Doc ID 888818.1: "Rman 06190 Connecting to target database after upgrade" In short, connect to the database as sysdba, and run the following scripts:
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

2 comments:

  1. after the execution of these scripts the error is still displayed in the alertlog any solution ?
    thank you in advance

    ReplyDelete
  2. After the execution of the following
    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

    now 08:46:15.223 DBMS cx70 -- Unexpected Exception while executing compile statement for DBMS_BACKUP_RESTORE using 'ALTER PACKAGE SYS.DBMS_BACKUP_RESTORE COMPILE BODY': ORA-01031: insufficient privileges

    ReplyDelete