19c 标准版 PDB 如何迁移至企业版？

[TOC]

⭐️ 前文，我们测试了 《19c 企业版 PDB 如何迁移至标准版？》，那么本文我们在测试一下19c 标准版 PDB 如何迁移至企业版？

👉 前文参考：https://www.modb.pro/db/1826077812319596544

一、环境介绍

二、需求

将19.3 标准版 中的PDB 迁移到 19.3 的企业版中。

三、迁移方式

我们这里是测试环境，细节部分不在描述。

1. 使用数据泵方式

没问题，我们就不演示了，略。。。

2. 使用dblink克隆 pdb

2.1 源端创建用户（给目标库创建dblink用）

-- CDB下创建
SYS@ORCLCDB2> create user c##clone identified by clone  container=all;

User created.

SYS@ORCLCDB2> grant dba, create pluggable database to c##clone  container=all;

Grant succeeded.
复制

2.2 目标端的CDB中创建dblink，连接到pdb

SYS@ORCLCDB> create public database link LINK_ORCLPDB connect to c##clone identified by clone using '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.88.0.3)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCLPDB)))';

Database link created.

-- 测试dblink
SYS@ORCLCDB> select name from v$pdbs @LINK_ORCLPDB;

NAME
-----------------------------------------------------------
ORCLPDB
复制

2.3 目标端的CDB中远程克隆pdb

-- 我们这里从源端的pdb:orclpdb 克隆到目标端的 pdb:orclpdb
[oracle@ora19c ~]$ mkdir -p /opt/oracle/oradata/ORCLCDB/orclpdb

SYS@ORCLCDB> create pluggable database orclpdb from orclpdb@LINK_ORCLPDB  CREATE_FILE_DEST = '/opt/oracle/oradata/ORCLCDB/orclpdb';

Pluggable database created.

-- 打开PDB正常
SYS@ORCLCDB> alter pluggable database orclpdb open;

Pluggable database altered.

SYS@ORCLCDB> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ORCLPDB                        READ WRITE NO
复制

2.4 检查升级状态

-- 通过视图pdb_plug_in_violations检查PDB是否有错误
SYS@ORCLCDB> set line222
SYS@ORCLCDB> col NAME for a10
SYS@ORCLCDB> col CAUSE for a20
SYS@ORCLCDB> col MESSAGE for a100
SYS@ORCLCDB>  select name,cause, type, message from pdb_plug_in_violations where status='PENDING'order by time desc;

NAME       CAUSE                TYPE               MESSAGE
---------- -------------------- ------------------ ----------------------------------------------------------------------------------------------------
ORCLPDB    OPTION               WARNING            Database option XOQ mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0.
ORCLPDB    OPTION               WARNING            Database option SDO mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0.
ORCLPDB    OPTION               WARNING            Database option OLS mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0.
ORCLPDB    OPTION               WARNING            Database option DV mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0.
ORCLPDB    OPTION               WARNING            Database option APS mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0.
ORCLPDB    DB Release Edition   WARNING            CDB is Enterprise Edition (8), but PDB is not Enterprise Edition (4)
ORCLPDB    Parameter            WARNING            CDB parameter pga_aggregate_target mismatch: Previous 256M Current 100M
ORCLPDB    Parameter            WARNING            CDB parameter processes mismatch: Previous 300 Current 640

8 rows selected.

-- 查看组件状态，仍然保持和标准版时候一样
SYS@ORCLCDB> alter session set container=ORCLPDB;

Session altered.

SYS@ORCLCDB> select comp_id, version,status from dba_registry;

COMP_ID                        VERSION                        STATUS
------------------------------ ------------------------------ ------------------------------
CATALOG                        19.0.0.0.0                     VALID
CATPROC                        19.0.0.0.0                     VALID
RAC                            19.0.0.0.0                     OPTION OFF
JAVAVM                         19.0.0.0.0                     VALID
XML                            19.0.0.0.0                     VALID
CATJAVA                        19.0.0.0.0                     VALID
APS                            19.0.0.0.0                     OPTION OFF
XDB                            19.0.0.0.0                     VALID
OWM                            19.0.0.0.0                     VALID
CONTEXT                        19.0.0.0.0                     VALID
ORDIM                          19.0.0.0.0                     VALID
SDO                            19.0.0.0.0                     OPTION OFF
XOQ                            19.0.0.0.0                     OPTION OFF
OLS                            19.0.0.0.0                     OPTION OFF
DV                             19.0.0.0.0                     OPTION OFF

15 rows selected.
复制

针对上面的WARNING，参考mos文档：

OPTION WARNING Database option mismatch: PDB installed version NULL" in PDB_PLUG_IN_VIOLATIONS (Doc ID 2020172.1)

从文档最后可以看到，可以忽略WARNING ，但是不能忽略error错误。

2.5 升级数据字典

-- 推荐执行
SYS@ORCLCDB> alter session set container=ORCLPDB;

Session altered.

@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql

@?/rdbms/admin/utlrp.sql
复制

结论：

1. 通过克隆的方式，可以将标准版的PDB克隆到企业版中，且组件状态保持和标准版中一样；

2. 克隆的PDB，open时候，因组件状态差异，导致存在WARNING信息，根据文档ID 2020172.1，warning可以忽略。