Oracle 12c系列(九) | 通过unplug与plug方式升级pdb数据库

心已赠人 2022-05-17 08:55 148阅读 0赞

对于Oracle数据库升级操作，每个版本之间的升级步骤均相似，首先升级Oracle软件，然后升级数据库内的数据字典表。

在Oracle12c中，当我们通过容器的方式对数据库进行整合后，其升级方式变得更加灵活，整合后我可以选择对容器中的所有PDB数据库进行升级，也可以通过克隆/移动以及unplug/plug的方式对其中的某一个PDB数据库进行升级从而不影响容器中的其他PDB数据库。

如下将演示如何通过unplug/plug的方式升级pdb数据库。

原环境为：

![70][]

目标环境：

![70 1][]

这里将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错误：

![70 2][]

当然，如果您有使用到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**

**![70 3][]**

**![70 4][]**

通过unplug/plug方式将pdb1从oradb中拔出插入到ora12c中，完成pdb1从12.1.0.2.0到12.2.0.1.0的升级。

### **| 作者简介** ###

**杨禹航·沃趣科技高级数据库技术专家**

熟悉Oracle数据库内部机制，丰富的数据库及RAC集群层故障诊断、性能调优、OWI、数据库备份恢复及迁移经验。

[70]: /images/20220517/350c81c6eb8e4b1d9981bcff2d0a9725.png
[70 1]: /images/20220517/88d3f328ab3d4fcfbd16c4925be33ff4.png
[70 2]: /images/20220517/7cb7e231749a413789d55082b11068b6.png
[70 3]: /images/20220517/d3864646888842368eb178e1a5bc5d7e.png
[70 4]: /images/20220517/53e14c075ee749bd9eefc40ea6a03ef9.png

发表评论取消回复

表情：

评论列表（有 0 条评论，148人围观）

还没有评论，来说两句吧...

相关阅读

相关 Oracle12c Centos7 创建，删除CDB与PDB

官方文档地址：[https://docs.oracle.com/database/121/ADMIN/create.htm\ADMIN14032][https_docs.ora

秒速五厘米/ 2023年07月13日 12:29/ 0 赞/ 127 阅读

相关 Oracle 12c CDB & PDB

Oracle 12c CDB & PDB 查看当前容器 SQL> show con\_name; CON\_NAME \----------------------

拼搏现实的明天。/ 2022年12月23日 00:42/ 0 赞/ 184 阅读

相关 oracle11g数据库pdb,Oracle11g数据库迁移到Oracle12C的PDB（使用impdp/expdp）

\[email protected\]:1531/hrdb as sysdba \--创建目录 create or replace directory exp\_dir a

r囧r小猫/ 2022年10月21日 04:54/ 0 赞/ 297 阅读

相关 PDB创建之plug pdb into other cdb

通过plug方式创建pdb数据库，如下图描述 ![Center][] 现在需要把oracle12中的pdb2插入到cdb1容器中 C:\\Users\\

太过爱你忘了你带给我的痛/ 2022年08月06日 06:13/ 0 赞/ 231 阅读

相关 Oracle 12c 基于PDB种子数据库创建PDB

在Oracle中基于PDB种子复制数据库的方式，这个与SQLServert中直接创建数据库比较类似。在SQLServer中有一个model数据库，这个库的功能就和PDB种子数据

旧城等待，/ 2022年06月14日 08:14/ 0 赞/ 390 阅读

相关 Oracle 12C -- 使用seed PDB创建新的pdb

pdb:/data/pdb/datafile@oracle>sqlplus / as sysdba SQL\Plus: Release 12.2.0.1.0 Prod

墨蓝/ 2022年06月12日 05:54/ 0 赞/ 344 阅读

相关 Oracle 12c系列(二)｜PDB的创建

作者杨禹航出品沃趣技术 PDB数据库的创建可以从现存的数据库中复制数据文件，包括种子容器、可插拔数据库、non-CDB数据库，创建时可以使用CREA

布满荆棘的人生/ 2022年05月31日 13:50/ 0 赞/ 312 阅读

相关 Oracle 12c系列(九) | 通过unplug与plug方式升级pdb数据库

对于Oracle数据库升级操作，每个版本之间的升级步骤均相似，首先升级Oracle软件，然后升级数据库内的数据字典表。在Oracle12c中，当我们通过容器的方式对数据库进

心已赠人/ 2022年05月17日 08:55/ 0 赞/ 149 阅读

相关 ORACLE 12c PDB 基础

--建立连接 --进入cdb sqlplus /nolog conn sys/sys as dba --// sqlplus s

Dear 丶/ 2022年04月13日 12:45/ 0 赞/ 266 阅读

相关块设备层request plug/unplug机制

转载至博客：[http://blog.chinaunix.net/xmlrpc.php?r=blog/article&uid=14528823&id=4778396][http

谁践踏了优雅/ 2022年03月10日 00:45/ 0 赞/ 166 阅读