Search This Blog

Total Pageviews

Friday, 1 November 2024

PL/SQL package SYS.DBMS_BACKUP_RESTORE version in TARGET database is not current




RMAN> alter database open resetlogs;

Statement processed
PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.23.00.00 in TARGET database is not current
PL/SQL package SYS.DBMS_RCVMAN version 19.23.00.00 in TARGET database is not current



My backup was Oracle version  19.23 and restored on 19.24 binaries 




set linesize 400 pagesize 300

COLUMN status FORMAT A10
COLUMN description FORMAT A40
COLUMN source_version FORMAT A10
COLUMN target_version FORMAT A10


select CON_ID,
TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time,
PATCH_ID,
PATCH_TYPE,
ACTION,
DESCRIPTION,
SOURCE_VERSION,
TARGET_VERSION
from CDB_REGISTRY_SQLPATCH
order by CON_ID, action_time, patch_id;




run below command !!!

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




[oracle@srv1 RmanBackup]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Fri Nov 1 11:42:59 2024
Version 19.24.0.0.0

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

connected to target database: ORADB (DBID=2803372975)

RMAN>



no more error !!!!



Now apply datapatch again !!!!

 cd $ORACLE_HOME/OPatch
[oracle@srv1 OPatch]$ pwd
/u01/app/oracle/product/19.0.0/db_1/OPatch
[oracle@srv1 OPatch]$ ./datapatch -verbose
SQL Patching tool version 19.24.0.0.0 Production on Fri Nov  1 11:56:22 2024
Copyright (c) 2012, 2024, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_12423_2024_11_01_11_56_22/sqlpatch_invocation.log

Connecting to database...OK
Gathering database info...done

Note:  Datapatch will only apply or rollback SQL fixes for PDBs
       that are in an open state, no patches will be applied to closed PDBs.
       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
       (Doc ID 1585822.1)

Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of interim SQL patches:
Interim patch 31219897 (OJVM RELEASE UPDATE: 19.8.0.0.200714 (31219897)):
  Binary registry: Installed
  PDB CDB$ROOT: Applied successfully on 10-SEP-20 12.34.31.168250 PM
  PDB PDB$SEED: Applied successfully on 10-SEP-20 12.34.40.711871 PM
  PDB PDB1: Applied successfully on 10-SEP-20 12.41.43.472665 PM

Current state of release update SQL patches:
  Binary registry:
    19.24.0.0.0 Release_Update 240627235157: Installed
  PDB CDB$ROOT:
    Applied 19.23.0.0.0 Release_Update 240406004238 successfully on 20-APR-24 10.05.35.931655 PM
  PDB PDB$SEED:
    Applied 19.23.0.0.0 Release_Update 240406004238 successfully on 20-APR-24 10.09.18.365114 PM
  PDB PDB1:
    Applied 19.23.0.0.0 Release_Update 240406004238 successfully on 20-APR-24 10.09.18.242487 PM

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED PDB1
    No interim patches need to be rolled back
    Patch 36582781 (Database Release Update : 19.24.0.0.240716 (36582781)):
      Apply from 19.23.0.0.0 Release_Update 240406004238 to 19.24.0.0.0 Release_Update 240627235157
    No interim patches need to be applied

Installing patches...
Patch installation complete.  Total patches installed: 3

Validating logfiles...done
Patch 36582781 apply (pdb CDB$ROOT): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/36582781/25751445/36582781_apply_ORADB_CDBROOT_2024Nov01_11_58_41.log (no errors)
Patch 36582781 apply (pdb PDB$SEED): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/36582781/25751445/36582781_apply_ORADB_PDBSEED_2024Nov01_11_59_57.log (no errors)
Patch 36582781 apply (pdb PDB1): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/36582781/25751445/36582781_apply_ORADB_PDB1_2024Nov01_11_59_57.log (no errors)
SQL Patching tool complete on Fri Nov  1 12:01:43 2024
[oracle@srv1 OPatch]$





set linesize 400 pagesize 300

COLUMN status FORMAT A10
COLUMN description FORMAT A70
COLUMN source_version FORMAT A15
COLUMN target_version FORMAT A15


select CON_ID,
TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time,
PATCH_ID,
PATCH_TYPE,
ACTION,
DESCRIPTION,
SOURCE_VERSION,
TARGET_VERSION
from CDB_REGISTRY_SQLPATCH
order by CON_ID, action_time, patch_id;


    CON_ID ACTION_TIME                     PATCH_ID PATCH_TYPE ACTION          DESCRIPTION                                                            SOURCE_VERSION  TARGET_VERSION
---------- ----------------------------- ---------- ---------- --------------- ---------------------------------------------------------------------- --------------- ---------------
         1 01-NOV-2024 11:59:39            36582781 RU         APPLY           Database Release Update : 19.24.0.0.240716 (36582781)                  19.23.0.0.0     19.24.0.0.0
         1 03-SEP-2020 00:49:24            29517242 RU         APPLY           Database Release Update : 19.3.0.0.190416 (29517242)                   19.1.0.0.0      19.3.0.0.0
         1 10-SEP-2020 12:34:31            31219897 INTERIM    APPLY           OJVM RELEASE UPDATE: 19.8.0.0.200714 (31219897)                        19.3.0.0.0      19.3.0.0.0
         1 10-SEP-2020 12:34:31            31281355 RU         APPLY           Database Release Update : 19.8.0.0.200714 (31281355)                   19.3.0.0.0      19.8.0.0.0
         1 20-APR-2024 00:32:33            34429835 RUR        APPLY           Database Release Update Revision : 19.15.2.0.221018 (34429835)         19.8.0.0.0      19.15.2.0.0
         1 20-APR-2024 20:42:02            34429835 RUR        ROLLBACK        Database Release Update Revision : 19.15.2.0.221018 (34429835)         19.15.2.0.0     19.15.0.0.0
         1 20-APR-2024 20:42:03            34419443 RU         APPLY           Database Release Update : 19.17.0.0.221018 (34419443)                  19.15.0.0.0     19.17.0.0.0
         1 20-APR-2024 22:05:35            36233263 RU         APPLY           Database Release Update : 19.23.0.0.240416 (36233263)                  19.17.0.0.0     19.23.0.0.0
         3 01-NOV-2024 12:00:49            36582781 RU         APPLY           Database Release Update : 19.24.0.0.240716 (36582781)                  19.23.0.0.0     19.24.0.0.0
         3 03-SEP-2020 00:58:10            29517242 RU         APPLY           Database Release Update : 19.3.0.0.190416 (29517242)                   19.1.0.0.0      19.3.0.0.0
         3 10-SEP-2020 12:41:43            31219897 INTERIM    APPLY           OJVM RELEASE UPDATE: 19.8.0.0.200714 (31219897)                        19.3.0.0.0      19.3.0.0.0
         3 10-SEP-2020 12:41:43            31281355 RU         APPLY           Database Release Update : 19.8.0.0.200714 (31281355)                   19.3.0.0.0      19.8.0.0.0
         3 20-APR-2024 00:32:47            34429835 RUR        APPLY           Database Release Update Revision : 19.15.2.0.221018 (34429835)         19.8.0.0.0      19.15.2.0.0
         3 20-APR-2024 20:42:06            34429835 RUR        ROLLBACK        Database Release Update Revision : 19.15.2.0.221018 (34429835)         19.15.2.0.0     19.15.0.0.0
         3 20-APR-2024 20:42:08            34419443 RU         APPLY           Database Release Update : 19.17.0.0.221018 (34419443)                  19.15.0.0.0     19.17.0.0.0
         3 20-APR-2024 22:09:18            36233263 RU         APPLY           Database Release Update : 19.23.0.0.240416 (36233263)                  19.17.0.0.0     19.23.0.0.0

16 rows selected.

SQL> SQL> SQL>


No comments:

Oracle DBA

anuj blog Archive