其他
Oracle 12c系列(九) | 通过unplug与plug方式升级pdb数据库
作者 杨禹航·沃趣科技高级数据库技术专家
出品 沃趣科技
对于Oracle数据库升级操作，每个版本之间的升级步骤均相似，首先升级Oracle软件，然后升级数据库内的数据字典表。
在Oracle12c中，当我们通过容器的方式对数据库进行整合后，其升级方式变得更加灵活，整合后我可以选择对容器中的所有PDB数据库进行升级，也可以通过克隆/移动以及unplug/plug的方式对其中的某一个PDB数据库进行升级从而不影响容器中的其他PDB数据库。
如下将演示如何通过unplug/plug的方式升级pdb数据库。
原环境为：
目标环境：
这里将12.1版本的容器oradb中pdb1通过unplug/plug方式插入到容器ora12c中，以此方式完成对pdb1数据库的升级。
过程如下：
1.原平台测试数据准备
sys. oradb>alter session set container=pdb1;
Session altered.
Elapsed: 00:00:00.05
sys. oradb>create tablespace tbs01 datafile size 200M;
Tablespace created.
Elapsed: 00:00:03.68
sys. oradb>create user yyh identified by yyh default tablespace tbs01;
User created.
Elapsed: 00:00:00.10
sys. oradb>grant dba to yyh;
Grant succeeded.
Elapsed: 00:00:00.06
sys. >conn yyh/yyh@pdb1
Connected.
yyh. pdb1>create table t(id number, name varchar2(20));
Table created.
Elapsed: 00:00:00.06
yyh. pdb1>insert into t values(0,'QData');
1 row created.
Elapsed: 00:00:00.05
yyh. pdb1>commit;
Commit complete.
Elapsed: 00:00:00.01
yyh. pdb1>select * from t;
ID NAME
---------- ------------------------------
0 QData
Elapsed: 00:00:00.00
yyh. pdb1>
2.卸载Oracle APEX
Oracle APEX在12.1.0.2.0中默认安装，而在12.2.0.1.0未默认安装，如果不进行APEX卸载，在12.2.0.1.0中plug 12.1.0.2.0版本的pdb将报如下ORA-65346错误：
当然，如果您有使用到APEX，需要在12.2.0.1.0中安装APEX，而无需卸载12.1.0.2.0中的APEX。
卸载方式：
03:50:39 sys. oradb>select COMP_ID, STATUS from DBA_REGISTRY where COMP_ID='APEX';
COMP_ID STATUS
------------------------------ --------------------------------------------
APEX VALID
Elapsed: 00:00:00.02
03:50:41 sys. oradb>
03:53:56 sys. oradb>conn /as sysdba
Connected.
03:53:58 sys. oradb>@?/apex/apxremov_con.sql
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.01
Performing installation in multitenant container database in the background.
The installation progress is spooled into apxremov*_con*.log files.
Please wait...
catcon: ALL catcon-related output will be written to apxremov1_con_catcon_12393.lst
catcon: See apxremov1_con*.log files for output generated by scripts
catcon: See apxremov1_con_*.lst files for spool files, if any
catcon.pl: completed successfully
catcon: ALL catcon-related output will be written to apxremov2_con_catcon_12512.lst
catcon: See apxremov2_con*.log files for output generated by scripts
catcon: See apxremov2_con_*.lst files for spool files, if any
catcon.pl: completed successfully
Installation completed. Log files for each container can be found in:
apxremov*_con*.log
You can quickly scan for ORA errors or compilation errors by using a utility
like grep:
grep ORA- *.log
grep PLS- *.log
03:57:42 sys. oradb>03:57:42 sys. oradb>03:57:42 sys. oradb>
03:59:32 sys. oradb>select COMP_ID, STATUS from DBA_REGISTRY where COMP_ID='APEX';
no rows selected
Elapsed: 00:00:00.12
04:00:35 sys. oradb>select COMP_ID, STATUS from DBA_REGISTRY where COMP_ID='APEX';
no rows selected
Elapsed: 00:00:00.02
04:00:36 sys. oradb>
3.unplug生成pdb1的xml文件
sys. oradb>alter pluggable database pdb1 close;
Pluggable database altered.
Elapsed: 00:00:01.16
sys. oradb>alter pluggable database pdb1 unplug into '/tmp/pdb1.xml';
Pluggable database altered.
Elapsed: 00:00:17.88
sys. oradb>select pdb_id, pdb_name, status from dba_pdbs;
PDB_ID PDB_NAME STATUS
---------- ------------------------------ ---------
3 PDB1 UNPLUGGED
2 PDB$SEED NORMAL
Elapsed: 00:00:00.04
sys. oradb>DROP PLUGGABLE DATABASE pdb1 KEEP DATAFILES;
Pluggable database dropped.
Elapsed: 00:00:00.32
sys. oradb>show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
sys. oradb>
4.将pdb1 plug到12.2.0.1.0版本的容器ora12c中
sys. ora12c>create pluggable database pdb1 using '/tmp/pdb1.xml' nocopy;
Pluggable database created.
Elapsed: 00:00:01.12
sys. ora12c>show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 MOUNTED
sys. ora12c>select pdb_id, pdb_name, status from dba_pdbs;
PDB_ID PDB_NAME STATUS
---------- ------------------------------ ----------
2 PDB$SEED NORMAL
3 PDB1 NEW
Elapsed: 00:00:00.01
sys. ora12c>select name, MESSAGE from pdb_plug_in_violations order by time;
NAME MESSAGE
---------- ------------------------------------------------------------------------------------------------------------------------
PDB1 Database option APS mismatch: PDB installed version 12.1.0.2.0. CDB installed version 12.2.0.1.0.
PDB1 Database option CATALOG mismatch: PDB installed version 12.1.0.2.0. CDB installed version 12.2.0.1.0.
PDB1 Database option CATJAVA mismatch: PDB installed version 12.1.0.2.0. CDB installed version 12.2.0.1.0.
PDB1 Database option CATPROC mismatch: PDB installed version 12.1.0.2.0. CDB installed version 12.2.0.1.0.
PDB1 Database option CONTEXT mismatch: PDB installed version 12.1.0.2.0. CDB installed version 12.2.0.1.0.
PDB1 Database option DV mismatch: PDB installed version 12.1.0.2.0. CDB installed version 12.2.0.1.0.
PDB1 Database option JAVAVM mismatch: PDB installed version 12.1.0.2.0. CDB installed version 12.2.0.1.0.
PDB1 Database option OLS mismatch: PDB installed version 12.1.0.2.0. CDB installed version 12.2.0.1.0.
PDB1 Database option ORDIM mismatch: PDB installed version 12.1.0.2.0. CDB installed version 12.2.0.1.0.
PDB1 Database option OWM mismatch: PDB installed version 12.1.0.2.0. CDB installed version 12.2.0.1.0.
PDB1 Database option SDO mismatch: PDB installed version 12.1.0.2.0. CDB installed version 12.2.0.1.0.
PDB1 Database option XDB mismatch: PDB installed version 12.1.0.2.0. CDB installed version 12.2.0.1.0.
PDB1 Database option XML mismatch: PDB installed version 12.1.0.2.0. CDB installed version 12.2.0.1.0.
PDB1 Database option XOQ mismatch: PDB installed version 12.1.0.2.0. CDB installed version 12.2.0.1.0.
PDB1 CDB parameter memory_target mismatch: Previous 1200M Current 0
PDB1 CDB parameter compatible mismatch: Previous '12.1.0.2.0' Current '12.2.0'
16 rows selected.
Elapsed: 00:00:00.00
04:08:21 sys. ora12c>show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 MOUNTED
04:08:23 sys. ora12c>alter pluggable database pdb1 open;
Warning: PDB altered with errors.
Elapsed: 00:00:01.30
04:08:32 sys. ora12c>show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 MIGRATE YES
04:08:44 sys. ora12c>alter pluggable database pdb1 close;
Pluggable database altered.
Elapsed: 00:00:00.23
04:08:51 sys. ora12c>show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 MOUNTED
04:08:55 sys. ora12c>
5.升级pdb1的数据字典
[oracle@node1 ~]$ $ORACLE_HOME/bin/dbupgrade -c PDB1
Argument list for [/u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl]
Run in c = PDB1
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
RO User Tablespaces T = 0
Display Phases y = 0
Debug catcon.pm z = 0
Debug catctl.pl Z = 0
catctl.pl VERSION: [12.2.0.1.0]
STATUS: [production]
BUILD: [RDBMS_12.2.0.1.0_LINUX.X64_170125]
/u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/orahome = [/u01/app/oracle/product/12.2.0/dbhome_1]
/u01/app/oracle/product/12.2.0/dbhome_1/bin/orabasehome = [/u01/app/oracle/product/12.2.0/dbhome_1]
catctlGetOrabase = [/u01/app/oracle/product/12.2.0/dbhome_1]
Analyzing file /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catupgrd.sql
Log file directory = [/tmp/cfgtoollogs/upgrade20180801042325]
catcon: ALL catcon-related output will be written to [/tmp/cfgtoollogs/upgrade20180801042325/catupgrd_catcon_14054.lst]
catcon: See [/tmp/cfgtoollogs/upgrade20180801042325/catupgrd*.log] files for output generated by scripts
catcon: See [/tmp/cfgtoollogs/upgrade20180801042325/catupgrd_*.lst] files for spool files, if any
Number of Cpus = 1
Database Name = ora12c
DataBase Version = 12.2.0.1.0
catcon: ALL catcon-related output will be written to [/u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/ora12c/upgrade20180801042327/catupgrd_catcon_14054.lst]
catcon: See [/u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/ora12c/upgrade20180801042327/catupgrd*.log] files for output generated by scripts
catcon: See [/u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/ora12c/upgrade20180801042327/catupgrd_*.lst] files for spool files, if any
Log file directory = [/u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/ora12c/upgrade20180801042327]
PDB Parallel SQL Process Count = [2] is higher or equal to CPU Count = [1]
Concurrent PDB Upgrades defaulting to CPU Count [1]
Parallel SQL Process Count (PDB) = 2
Parallel SQL Process Count (CDB$ROOT) = 4
Concurrent PDB Upgrades = 1
Generated PDB Inclusion:[PDB1]
CDB$ROOT Open Mode = [OPEN]
Start processing of PDB1
[/u01/app/oracle/product/12.2.0/dbhome_1/perl/bin/perl /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl -c 'PDB1' -I -i pdb1 -n 2 -l /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/ora12c/upgrade20180801042327 /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catupgrd.sql]
Argument list for [/u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl]
Run in c = PDB1
Do not run in C = 0
Input Directory d = 0
Echo OFF e = 1
Simulate E = 0
Forced cleanup F = 0
Log Id i = pdb1
Child Process I = 1
Log Dir l = /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/ora12c/upgrade20180801042327
Priority List Name L = 0
Upgrade Mode active M = 0
SQL Process Count n = 2
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
RO User Tablespaces T = 0
Display Phases y = 0
Debug catcon.pm z = 0
Debug catctl.pl Z = 0
catctl.pl VERSION: [12.2.0.1.0]
STATUS: [production]
BUILD: [RDBMS_12.2.0.1.0_LINUX.X64_170125]
/u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/orahome = [/u01/app/oracle/product/12.2.0/dbhome_1]
/u01/app/oracle/product/12.2.0/dbhome_1/bin/orabasehome = [/u01/app/oracle/product/12.2.0/dbhome_1]
catctlGetOrabase = [/u01/app/oracle/product/12.2.0/dbhome_1]
Analyzing file /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catupgrd.sql
Log file directory = [/u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/ora12c/upgrade20180801042327]
catcon: ALL catcon-related output will be written to [/u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/ora12c/upgrade20180801042327/catupgrdpdb1_catcon_14189.lst]
catcon: See [/u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/ora12c/upgrade20180801042327/catupgrdpdb1*.log] files for output generated by scripts
catcon: See [/u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/ora12c/upgrade20180801042327/catupgrdpdb1_*.lst] files for spool files, if any
Number of Cpus = 1
Database Name = ora12c
DataBase Version = 12.2.0.1.0
Generated PDB Inclusion:[PDB1]
CDB$ROOT Open Mode = [OPEN]
Components in [PDB1]
Installed [APS CATALOG CATJAVA CATPROC CONTEXT DV JAVAVM OLS ORDIM OWM SDO XDB XML XOQ]
Not Installed [APEX EM MGW ODM RAC WK]
------------------------------------------------------
Phases [0-115] Start Time:[2018_08_01 04:23:32]
Container Lists Inclusion:[PDB1] Exclusion:[NONE]
------------------------------------------------------
*********** Executing Change Scripts ***********
Serial Phase #:0 [PDB1] Files:1 Time: 49s
*************** Catalog Core SQL ***************
Serial Phase #:1 [PDB1] Files:5 Time: 71s
Restart Phase #:2 [PDB1] Files:1 Time: 0s
*********** Catalog Tables and Views ***********
Parallel Phase #:3 [PDB1] Files:19 Time: 42s
Restart Phase #:4 [PDB1] Files:1 Time: 0s
************* Catalog Final Scripts ************
Serial Phase #:5 [PDB1] Files:6 Time: 23s
***************** Catproc Start ****************
Serial Phase #:6 [PDB1] Files:1 Time: 14s
***************** Catproc Types ****************
Serial Phase #:7 [PDB1] Files:2 Time: 10s
Restart Phase #:8 [PDB1] Files:1 Time: 0s
**************** Catproc Tables ****************
Parallel Phase #:9 [PDB1] Files:69 Time: 71s
Restart Phase #:10 [PDB1] Files:1 Time: 0s
************* Catproc Package Specs ************
Serial Phase #:11 [PDB1] Files:1 Time: 48s
Restart Phase #:12 [PDB1] Files:1 Time: 0s
************** Catproc Procedures **************
Parallel Phase #:13 [PDB1] Files:97 Time: 12s
Restart Phase #:14 [PDB1] Files:1 Time: 1s
Parallel Phase #:15 [PDB1] Files:118 Time: 18s
Restart Phase #:16 [PDB1] Files:1 Time: 0s
Serial Phase #:17 [PDB1] Files:13 Time: 2s
Restart Phase #:18 [PDB1] Files:1 Time: 0s
***************** Catproc Views ****************
Parallel Phase #:19 [PDB1] Files:33 Time: 51s
Restart Phase #:20 [PDB1] Files:1 Time: 0s
Serial Phase #:21 [PDB1] Files:3 Time: 10s
Restart Phase #:22 [PDB1] Files:1 Time: 0s
Parallel Phase #:23 [PDB1] Files:24 Time: 179s
Restart Phase #:24 [PDB1] Files:1 Time: 0s
Parallel Phase #:25 [PDB1] Files:11 Time: 78s
Restart Phase #:26 [PDB1] Files:1 Time: 0s
Serial Phase #:27 [PDB1] Files:1 Time: 0s
Serial Phase #:28 [PDB1] Files:3 Time: 4s
Serial Phase #:29 [PDB1] Files:1 Time: 0s
Restart Phase #:30 [PDB1] Files:1 Time: 0s
*************** Catproc CDB Views **************
Serial Phase #:31 [PDB1] Files:1 Time: 0s
Restart Phase #:32 [PDB1] Files:1 Time: 0s
Serial Phase #:34 [PDB1] Files:1 Time: 0s
***************** Catproc PLBs *****************
Serial Phase #:35 [PDB1] Files:283 Time: 21s
Serial Phase #:36 [PDB1] Files:1 Time: 0s
Restart Phase #:37 [PDB1] Files:1 Time: 0s
Serial Phase #:38 [PDB1] Files:1 Time: 2s
Restart Phase #:39 [PDB1] Files:1 Time: 0s
*************** Catproc DataPump ***************
Serial Phase #:40 [PDB1] Files:3 Time: 57s
Restart Phase #:41 [PDB1] Files:1 Time: 1s
****************** Catproc SQL *****************
Parallel Phase #:42 [PDB1] Files:13 Time: 112s
Restart Phase #:43 [PDB1] Files:1 Time: 0s
Parallel Phase #:44 [PDB1] Files:12 Time: 10s
Restart Phase #:45 [PDB1] Files:1 Time: 0s
Parallel Phase #:46 [PDB1] Files:2 Time: 2s
Restart Phase #:47 [PDB1] Files:1 Time: 0s
************* Final Catproc scripts ************
Serial Phase #:48 [PDB1] Files:1 Time: 6s
Restart Phase #:49 [PDB1] Files:1 Time: 0s
************** Final RDBMS scripts *************
Serial Phase #:50 [PDB1] Files:1 Time: 24s
************ Upgrade Component Start ***********
Serial Phase #:51 [PDB1] Files:1 Time: 0s
Restart Phase #:52 [PDB1] Files:1 Time: 0s
**************** Upgrading Java ****************
Serial Phase #:53 [PDB1] Files:1 Time: 261s
Restart Phase #:54 [PDB1] Files:1 Time: 0s
***************** Upgrading XDK ****************
Serial Phase #:55 [PDB1] Files:1 Time: 75s
Restart Phase #:56 [PDB1] Files:1 Time: 0s
********* Upgrading APS,OLS,DV,CONTEXT *********
Serial Phase #:57 [PDB1] Files:1 Time: 97s
***************** Upgrading XDB ****************
Restart Phase #:58 [PDB1] Files:1 Time: 0s
Serial Phase #:60 [PDB1] Files:3 Time: 10s
Serial Phase #:61 [PDB1] Files:3 Time: 2s
Parallel Phase #:62 [PDB1] Files:9 Time: 2s
Parallel Phase #:63 [PDB1] Files:24 Time: 3s
Serial Phase #:64 [PDB1] Files:4 Time: 9s
Serial Phase #:65 [PDB1] Files:1 Time: 0s
Serial Phase #:66 [PDB1] Files:30 Time: 3s
Serial Phase #:67 [PDB1] Files:1 Time: 0s
Parallel Phase #:68 [PDB1] Files:6 Time: 3s
Serial Phase #:69 [PDB1] Files:2 Time: 19s
Serial Phase #:70 [PDB1] Files:3 Time: 33s
Restart Phase #:71 [PDB1] Files:1 Time: 0s
********* Upgrading CATJAVA,OWM,MGW,RAC ********
Serial Phase #:72 [PDB1] Files:1 Time: 42s
**************** Upgrading ORDIM ***************
Restart Phase #:73 [PDB1] Files:1 Time: 1s
Serial Phase #:75 [PDB1] Files:1 Time: 0s
Parallel Phase #:76 [PDB1] Files:2 Time: 61s
Serial Phase #:77 [PDB1] Files:1 Time: 54s
Restart Phase #:78 [PDB1] Files:1 Time: 0s
Parallel Phase #:79 [PDB1] Files:2 Time: 11s
Serial Phase #:80 [PDB1] Files:2 Time: 1s
***************** Upgrading SDO ****************
Restart Phase #:81 [PDB1] Files:1 Time: 0s
Serial Phase #:83 [PDB1] Files:1 Time: 47s
Serial Phase #:84 [PDB1] Files:1 Time: 2s
Restart Phase #:85 [PDB1] Files:1 Time: 0s
Serial Phase #:86 [PDB1] Files:1 Time: 4s
Restart Phase #:87 [PDB1] Files:1 Time: 0s
Parallel Phase #:88 [PDB1] Files:3 Time: 156s
Restart Phase #:89 [PDB1] Files:1 Time: 0s
Serial Phase #:90 [PDB1] Files:1 Time: 2s
Restart Phase #:91 [PDB1] Files:1 Time: 0s
Serial Phase #:92 [PDB1] Files:1 Time: 1s
Restart Phase #:93 [PDB1] Files:1 Time: 1s
Parallel Phase #:94 [PDB1] Files:4 Time: 53s
Restart Phase #:95 [PDB1] Files:1 Time: 1s
Serial Phase #:96 [PDB1] Files:1 Time: 0s
Restart Phase #:97 [PDB1] Files:1 Time: 0s
Serial Phase #:98 [PDB1] Files:2 Time: 44s
Restart Phase #:99 [PDB1] Files:1 Time: 0s
Serial Phase #:100 [PDB1] Files:1 Time: 1s
Restart Phase #:101 [PDB1] Files:1 Time: 0s
*********** Upgrading Misc. ODM, OLAP **********
Serial Phase #:102 [PDB1] Files:1 Time: 14s
**************** Upgrading APEX ****************
Restart Phase #:103 [PDB1] Files:1 Time: 0s
Serial Phase #:104 [PDB1] Files:1 Time: 1s
Restart Phase #:105 [PDB1] Files:1 Time: 0s
*********** Final Component scripts ***********
Serial Phase #:106 [PDB1] Files:1 Time: 1s
************* Final Upgrade scripts ************
Serial Phase #:107 [PDB1] Files:1 Time: 125s
********** End PDB Application Upgrade *********
Serial Phase #:108 [PDB1] Files:1 Time: 1s
******************* Migration ******************
Serial Phase #:109 [PDB1] Files:1 Time: 38s
Serial Phase #:110 [PDB1] Files:1 Time: 4s
Serial Phase #:111 [PDB1] Files:1 Time: 30s
***************** Post Upgrade *****************
Serial Phase #:112 [PDB1] Files:1 Time: 106s
**************** Summary report ****************
Serial Phase #:113 [PDB1] Files:1 Time: 1s
Serial Phase #:114 [PDB1] Files:1 Time: 2s
Serial Phase #:115 [PDB1] Files:1 Time: 0s
------------------------------------------------------
Phases [0-115] End Time:[2018_08_01 05:00:52]
Container Lists Inclusion:[PDB1] Exclusion:[NONE]
------------------------------------------------------
Grand Total Time: 2243s [PDB1]
LOG FILES: (/u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/ora12c/upgrade20180801042327/catupgrdpdb1*.log)
Upgrade Summary Report Located in:
/u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/ora12c/upgrade20180801042327/upg_summary.log
Total Upgrade Time: [0d:0h:37m:23s]
Time: 2251s For PDB(s)
Grand Total Time: 2251s
LOG FILES: (/u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/ora12c/upgrade20180801042327/catupgrd*.log)
Grand Total Upgrade Time: [0d:0h:37m:31s]
[oracle@node1 ~]$
6.检查升级后的pdb1
通过unplug/plug方式将pdb1从oradb中拔出插入到ora12c中，完成pdb1从12.1.0.2.0到12.2.0.1.0的升级。
| 作者简介
杨禹航·沃趣科技高级数据库技术专家
熟悉Oracle数据库内部机制，丰富的数据库及RAC集群层故障诊断、性能调优、OWI、数据库备份恢复及迁移经验。
相关链接
更多干货，欢迎来撩~