1.Relocate PDB from 18C to 19C 2.Upgrade PDB on 19C side 3.Open Relocated PDB on 19C side. 4.Wait for 10 mins to check if there is block corruption on relocated PDB on 19C side
Environment :
source DB: 18C
Target DB: 19C
Source DB: A
Target DB: B
Source DB_NAME=cdb
Target DB_NAME=orcl
Detailed Steps:
Steps.
Source 18C: DB A (DB_NAME=cdb)
Target 19C : DB A (DB_NAME=orcl)
1
Enable archivelog
Enable archivelog
2
alter pluggable datbaase testpdb. close abort instances=all; drop pluggable database testpdb including datafiles; create pluggable database testpdb admin user admin identified by admin; alter pluggable databasetestpdb open instances=all; alter pluggable datbaasetestpdb close immediate instances=all; alter pluggable database testpdb open; alter user system identified by systempasswd; grant CREATE SESSION,connect, sysoper, create pluggable database to SYSTEM container=all;
Argument list for [$ORACLE_HOME/rdbms/admin/catctl.pl] For Oracle internal use only A = 0 Run in c = pdbrelocate Do not run in C = 0 Input Directory d = 0 Echo OFF e = 1 Simulate E = 0 Forced cleanup F = 0 Log Id i = 0 Child Process I = 0 Log Dir l = 0 Priority List Name L = 0 Upgrade Mode active M = 0 SQL Process Count n = 0 SQL PDB Process Count N = 0 Open Mode Normal o = 0 Start Phase p = 0 End Phase P = 0 Reverse Order r = 0 AutoUpgrade Resume R = 0 Script s = 0 Serial Run S = 0 Classic Upgrade t = 0 RO User Tablespaces T = 0 Upgrade PDBs in Upgrade mode x = 0 Display Phases y = 0 Debug catcon.pm z = 0 Debug catctl.pl Z = 0
Steps1.Relocate PDB from 18C to 19C2.Upgrade PDB on 19C side3.Open Relocated PDB on 19C side.4.Wait for 10 mins to check if there is block corruption on relocated PDB on 19C sideEnvironment :source DB: 18CTarget DB: 19CSource DB: ATarget DB.