目的

测试通过热迁移的方式将12c database 升级到19c pdb

环境如下

将ORCL undo修改成本地undo

SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP UPGRADE;
SQL> ALTER DATABASE LOCAL UNDO ON;
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP;
select  name,value$ from props$ where name like '%UNDO%';
NAME
--------------------------------------------------------------------------------
VALUE$
--------------------------------------------------------------------------------
LOCAL_UNDO_ENABLED
TRUE

true 为本地undo
flase为共享undo

在目标库创建dblink

create database link db12c_orcl connect to system identified by oracle using 'orcl';

进行迁移

CREATE pluggable database pdbprod6 from non$cdb@db12c_orcl file_name_convert=('orcl','PRODCDB/PDBPROD6');

在源库进行数据插入测试

create table zhang(a int);
insert into zhang values('2');
commit;

创建完成后PDBPROD6是mount状态

SYS@PRODCDB>show pdbs
CON_ID CON_NAME			  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
	 2 PDB$SEED			  READ ONLY  NO
	 3 PDBPROD1			  READ WRITE NO
	 4 PDBPROD2			  READ WRITE NO
	 5 PDBPROD3			  READ WRITE NO
	 6 PDBPROD4			  READ WRITE NO
	 7 PDBPROD6			  MOUNTED 
	 8 PDBPROD5			  READ WRITE NO
	 		 

执行升级脚本

<host01:PRODCDB:/home/oracle>$which dbupgrade 
/u01/app/oracle/product/19.3.0/dbhome_1/bin/dbupgrade
<host01:PRODCDB:/u01/app/oracle/product/19.3.0/dbhome_1/bin> dbupgrade -c PDBPROD6

连入pdb执行脚本

SYS@PRODCDB>show pdbs
CON_ID CON_NAME			  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
	 2 PDB$SEED			  READ ONLY  NO
	 3 PDBPROD1			  READ WRITE NO
	 4 PDBPROD2			  READ WRITE NO
	 5 PDBPROD3			  READ WRITE NO
	 6 PDBPROD4			  READ WRITE NO
	 7 PDBPROD6			  MIGRATE    YES
	 8 PDBPROD5			  READ WRITE NO
SYS@PRODCDB>alter session set container=PDBPROD6;
Session altered.
执行如下两脚本
 @$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql
 @$ORACLE_HOME/rdbms/admin/utlrp.sql
 执行后重启pdb

连入pdb后查询相关组件

select comp_name,version,status from sys.dba_registry;
COMP_NAME																	            VERSION							    STATUS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------ ----------------------------------------------------------------------------------------
Oracle Database Catalog Views															            19.0.0.0.0						    VALID
Oracle Database Packages and Types														            19.0.0.0.0						    VALID
JServer JAVA Virtual Machine															            19.0.0.0.0						    VALID
Oracle XDK																	            19.0.0.0.0						    VALID
Oracle Database Java Packages															            19.0.0.0.0						    VALID
OLAP Analytic Workspace 															            19.0.0.0.0						    VALID
Oracle Real Application Clusters														            19.0.0.0.0						    OPTION OFF
Oracle XML Database																            19.0.0.0.0						    VALID
Oracle Workspace Manager															            19.0.0.0.0						    VALID
Oracle Text																	            19.0.0.0.0						    VALID
Oracle Multimedia																            19.0.0.0.0						    VALID

COMP_NAME																	            VERSION							    STATUS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------ ----------------------------------------------------------------------------------------
Spatial 																	            19.0.0.0.0						    VALID
Oracle OLAP API 																            19.0.0.0.0						    VALID
Oracle Label Security																            19.0.0.0.0						    VALID
Oracle Database Vault																            19.0.0.0.0						    VALID

15 rows selected.

查询在迁移时候进行数据插入的数据

<host01:PRODCDB:/u01/app/oracle/product/19.3.0/dbhome_1/bin>$sqlplus system/oracle_4U@PDBPROD6

SYSTEM@PDBPROD6>SELECT * FROM ZHANG;
	 A
----------
	 2