Oracle 19c PDB克隆后出现Warning: PDB altered with errors受限模式处理

原创

于 2024-11-13 16:04:01 发布 · 1.6k 阅读

8 ·

CC 4.0 BY-SA版权

文章标签：

#ffmpeg

在进行一次19c PDB克隆过程中，发现克隆结束，在打开后出现了报错，PDB变成受限模式，以下是分析处理过程

09:25:48 SQL> alter pluggable database test1113 open instances=all;

Warning: PDB altered with errors.

Elapsed: 00:00:28.91
09:26:31 SQL>

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 MB_UTF MOUNTED
4 TEST1113 READ WRITE YES

报错处理：
源库组件安装信息：

NAME CAUSE TYPE MESSAGE STATUS
-------------------- ---------- ---------- -------------------------------------------------- ------------------
PDB$SEED SQL Patch ERROR '19.3.0.0.0 Release_Update 1904101227' is installe RESOLVED
d in the CDB but no release updates are installed
in the PDB

目标库组件报错信息：

NAME CAUSE TYPE MESSAGE STATUS
-------------------- ---------- ---------- -------------------------------------------------- ---------
TEST1113 OPTION ERROR Database option DV mismatch: PDB installed version PENDING
19.0.0.0.0. CDB installed version NULL.

TEST1113 OPTION ERROR Database option OLS mismatch: PDB installed versio PENDING
n 19.0.0.0.0. CDB installed version NULL.

TEST1113 Sync Failu WARNING Sync PDB failed with ORA-04068 while performing 'D PENDING
re ROP USER "C##CLONES_HLW"'

TEST1113 Parameter WARNING CDB parameter processes mismatch: Previous 10000 C RESOLVED
urrent 12800

TEST1113 Parameter WARNING CDB parameter sga_max_size mismatch: Previous 200G RESOLVED
Current 140G

TEST1113 Parameter WARNING CDB parameter pga_aggregate_target mismatch: Previ RESOLVED
ous 50G Current 80G

TEST1113 SQL Patch ERROR '19.15.0.0.0 Release_Update 2203311254' is install PENDING
ed in the CDB but '19.3.0.0.0 Release_Update 19041
01227' is installed in the PDB

TEST1113 Oracle Opa WARNING Oracle opatch mismatch: opatch