实验目标:
- 12cR1通过unplug与plug方式升级PDB数据库到19c
实验环境:
- 数据库:升级前版本Oracle 12c R1 ,升级前版本Oracle 19c,同一台服务器
- 操作系统:AIX 7.1
实验步骤:
1、版本检查
##12c
SQL> select BANNER from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE 12.1.0.2.0 Production
TNS for IBM/AIX RISC System/6000: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production
##19c
SQL> select BANNER from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
2、12c克隆PDB2(可选)
为保障升级过程中数据的安全,通过克隆生成一份一样的数据进行升级。建议有空间都这样操作,以免方便回退。
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO
4 PDB2 READ WRITE NO
##关闭pdb2并打开为只读
SQL> alter pluggable database PDB2 close immediate;
Pluggable database altered.
SQL> ALTER PLUGGABLE DATABASE PDB2 OPEN READ ONLY;
Pluggable database altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO
4 PDB2 READ ONLY NO
#查看datafile路径
SQL> select a.FILE_NAME FROM containers(DBA_DATA_FILES) a where a.con_id=4;
FILE_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/oradata/orainst/64C038920FCF0268E0530A160C038C6B/datafile/sysaux.422.967635337
/oradata/orainst/64C038920FCF0268E0530A160C038C6B/datafile/system.421.967635337
/oradata/orainst/64C038920FCF0268E0530A160C038C6B/datafile/users.424.967636177
/oradata/orainst/64C038920FCF0268E0530A160C038C6B/datafile/slivven.426.967721775
/oradata/orainst/64C038920FCF0268E0530A160C038C6B/datafile/PDB2002.dbf
/oradata/orainst/64C038920FCF0268E0530A160C038C6B/datafile/PDB2004.dbf
6 rows selected.
SQL> select a.FILE_NAME FROM containers(DBA_TEMP_FILES) a where a.con_id=4;
FILE_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/oradata/orainst/datafile/ORAINST/64C038920FCF0268E0530A160C038C6B/datafile/o1_mf_temp_gosx00w4_.tmp
##克隆生成pdb2_c
SQL> create pluggable database PDB2_C from PDB2 file_name_convert=('/oradata/orainst/64C038920FCF0268E0530A160C038C6B/datafile','/new_oradata/TESTINST/PDB2/datafile','/oradata/orainst/datafile/ORAINST/64C038920FCF0268E0530A160C038C6B/datafile','/new_oradata/TESTINST/PDB2/tempfile');
create pluggable database PDB2_C from PDB2 file_name_convert=('/oradata/orainst/64C038920FCF0268E0530A160C038C6B/datafile','/new_oradata/TESTINST/PDB2/datafile','/oradata/orainst/datafile/ORAINST/64C038920FCF0268E0530A160C038C6B/datafile','/new_oradata/TESTINST/PDB2/tempfile')
*
ERROR at line 1:
ORA-01276: Cannot add file /new_oradata/TESTINST/PDB2/tempfile/o1_mf_temp_gosx00w4_.tmp. File has an Oracle Managed Files file name.
##原因tempfile为OMF,所以不能用file_name_convert进行转换,需要指定db_create_file_dest的方式进行
SQL> alter system set db_create_file_dest='/new_oradata/TESTINST/PDB2/datafile';
System altered.
SQL> show parameter db_create_file
NAME TYPE VALUE
------------------------------------ -------------------------------- ------------------------------
db_create_file_dest string /new_oradata/TESTINST/PDB2/datafile
##重新克隆pdb2_c
SQL> create pluggable database PDB2_C from PDB2;
Pluggable database created.
SQL> alter pluggable database PDB2_C open;
Pluggable database altered.
3、12c 插出pdb2_c
##关闭pdb2_c插出unplug
SQL> alter pluggable database PDB2_C close immediate;
Pluggable database altered.
SQL> alter pluggable database PDB2_C unplug into '/home/oracle/19c/PDB2_C.xml';
Pluggable database altered.
SQL> select pdb_id,pdb_name,status from dba_pdbs;
PDB_ID PDB_NAME STATUS
---------- -------------------------------------------------------------------------------------------------------------------------------- ---------
2 PDB$SEED NORMAL
4 PDB2 NORMAL
3 PDB1 NORMAL
5 PDB2_C UNPLUGGED
##删除pdb2_c,但保留datafiles
SQL> drop pluggable database PDB2_C keep datafiles;
Pluggable database dropped.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO
4 PDB2 READ ONLY NO
4、把pdb2_c的数据文件移动到目标位置(可选)
为规范管理,OMF生成的目录可能和你规划的目录不一致。
oracle@test:/home/oracle$ grep path /home/oracle/19c/PDB2_C.xml
<path>/new_oradata/TESTINST/PDB2/datafile/ORAINST/91C59F5312420314E0530A0B0C02C2CE/datafile/o1_mf_system_gq3lsxh1_.dbf</path>
<path>/new_oradata/TESTINST/PDB2/datafile/ORAINST/91C59F5312420314E0530A0B0C02C2CE/datafile/o1_mf_sysaux_gq3lsxh3_.dbf</path>
<path>/new_oradata/TESTINST/PDB2/datafile/ORAINST/91C59F5312420314E0530A0B0C02C2CE/datafile/o1_mf_temp_gq3lsxh5_.dbf</path>
<path>/new_oradata/TESTINST/PDB2/datafile/ORAINST/91C59F5312420314E0530A0B0C02C2CE/datafile/o1_mf_users_gq3lsxh6_.dbf</path>
<path>/new_oradata/TESTINST/PDB2/datafile/ORAINST/91C59F5312420314E0530A0B0C02C2CE/datafile/o1_mf_slivven_gq3lsxh8_.dbf</path>
<path>/new_oradata/TESTINST/PDB2/datafile/ORAINST/91C59F5312420314E0530A0B0C02C2CE/datafile/o1_mf_slivven_gq3lsxhb_.dbf</path>
<path>/new_oradata/TESTINST/PDB2/datafile/ORAINST/91C59F5312420314E0530A0B0C02C2CE/datafile/o1_mf_slivven_gq3lsxhc_.dbf</path>
oracle@test:/home/oracle$ mv /new_oradata/TESTINST/PDB2/datafile/ORAINST/91C59F5312420314E0530A0B0C02C2CE/datafile/* /new_oradata/TESTINST/PDB2/datafile
5、19c 插入pdb2_c
##插入pdb2_c,命名为pdb2
SQL> create pluggable database PDB2 using '/home/oracle/19c/PDB2_C.xml' SOURCE_FILE_NAME_CONVERT=('/new_oradata/TESTINST/PDB2/datafile/ORAINST/91C59F5312420314E0530A0B0C02C2CE/datafile','/new_oradata/TESTINST/PDB2/datafile') nocopy tempfile reuse;
Pluggable database created.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO
4 PDB2 MOUNTED
SQL> select pdb_id,pdb_name,status from dba_pdbs;
PDB_ID PDB_NAME STATUS
---------- -------------------------------------------------------------------------------------------------------------------------------- ----------
2 PDB$SEED NORMAL
3 PDB1 NORMAL
4 PDB2 NEW
##打开会报错,需要升级数据字典
SQL> alter pluggable database PDB2 open;
Warning: PDB altered with errors.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO
4 PDB2 MIGRATE YES
SQL> alter pluggable database PDB2 close immediate;
Pluggable database altered.
6、使用19c环境升级数据字典
oracle@test:/home/oracle$ $ORACLE_HOME/bin/dbupgrade -c PDB2
Argument list for [/u01/app/oracle/product/19.3.0/db_1/rdbms/admin/catctl.pl]
For Oracle internal use only A = 0
Run in c = PDB2
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: [19.0.0.0.0]
STATUS: [Production]
BUILD: [RDBMS_19.3.0.0.0DBRU_AIX.PPC64_190417.190518]
/u01/app/oracle/product/19.3.0/db_1/rdbms/admin/orahome = [/u01/app/oracle/product/19.3.0/db_1]
/u01/app/oracle/product/19.3.0/db_1/bin/orabasehome = [/u01/app/oracle/product/19.3.0/db_1]
catctlGetOraBaseLogDir = [/u01/app/oracle/product/19.3.0/db_1]
Analyzing file /u01/app/oracle/product/19.3.0/db_1/rdbms/admin/catupgrd.sql
Log file directory = [/tmp/cfgtoollogs/upgrade20190906110421]
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/tmp/cfgtoollogs/upgrade20190906110421/catupgrd_catcon_36045960.lst]
catcon::set_log_file_base_path: catcon: See [/tmp/cfgtoollogs/upgrade20190906110421/catupgrd*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/tmp/cfgtoollogs/upgrade20190906110421/catupgrd_*.lst] files for spool files, if any
Number of Cpus = 32
Database Name = testinst
DataBase Version = 19.0.0.0.0
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/testinst/upgrade20190906110439/catupgrd_catcon_36045960.lst]
catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/testinst/upgrade20190906110439/catupgrd*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/testinst/upgrade20190906110439/catupgrd_*.lst] files for spool files, if any
Log file directory = [/u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/testinst/upgrade20190906110439]
Parallel SQL Process Count (PDB) = 2
Parallel SQL Process Count (CDB$ROOT) = 8
Concurrent PDB Upgrades = 16
Generated PDB Inclusion:[PDB2]
CDB$ROOT Open Mode = [OPEN]
Concurrent PDB Upgrades Reset = 1
Start processing of PDBs (PDB2)
[/u01/app/oracle/product/19.3.0/db_1/perl/bin/perl /u01/app/oracle/product/19.3.0/db_1/rdbms/admin/catctl.pl -c 'PDB2' -I -i PDB2 -n 2 -l /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/testinst/upgrade20190906110439 /u01/app/oracle/product/19.3.0/db_1/rdbms/admin/catupgrd.sql]
Argument list for [/u01/app/oracle/product/19.3.0/db_1/rdbms/admin/catctl.pl]
For Oracle internal use only A = 0
Run in c = PDB2
Do not run in C = 0
Input Directory d = 0
Echo OFF e = 1
Simulate E = 0
Forced cleanup F = 0
Log Id i = PDB2
Child Process I = 1
Log Dir l = /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/testinst/upgrade20190906110439
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: [19.0.0.0.0]
STATUS: [Production]
BUILD: [RDBMS_19.3.0.0.0DBRU_AIX.PPC64_190417.190518]
/u01/app/oracle/product/19.3.0/db_1/rdbms/admin/orahome = [/u01/app/oracle/product/19.3.0/db_1]
/u01/app/oracle/product/19.3.0/db_1/bin/orabasehome = [/u01/app/oracle/product/19.3.0/db_1]
catctlGetOraBaseLogDir = [/u01/app/oracle/product/19.3.0/db_1]
Analyzing file /u01/app/oracle/product/19.3.0/db_1/rdbms/admin/catupgrd.sql
Log file directory = [/u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/testinst/upgrade20190906110439]
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/testinst/upgrade20190906110439/catupgrdPDB2_catcon_17761476.lst]
catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/testinst/upgrade20190906110439/catupgrdPDB2*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/testinst/upgrade20190906110439/catupgrdPDB2_*.lst] files for spool files, if any
Number of Cpus = 32
Database Name = testinst
DataBase Version = 19.0.0.0.0
PDB2 Open Mode = [MIGRATE]
Generated PDB Inclusion:[PDB2]
CDB$ROOT Open Mode = [OPEN]
Components in [PDB2]
Installed [APEX APS CATALOG CATJAVA CATPROC CONTEXT DV JAVAVM OLS ORDIM OWM RAC SDO XDB XML XOQ]
Not Installed [EM MGW ODM WK]
------------------------------------------------------
Phases [0-107] Start Time:[2019_09_06 11:05:45]
Container Lists Inclusion:[PDB2] Exclusion:[NONE]
------------------------------------------------------
*********** Executing Change Scripts ***********
Serial Phase #:0 [PDB2] Files:1 Time: 47s
*************** Catalog Core SQL ***************
Serial Phase #:1 [PDB2] Files:5 Time: 48s
Restart Phase #:2 [PDB2] Files:1 Time: 2s
*********** Catalog Tables and Views ***********
Parallel Phase #:3 [PDB2] Files:19 Time: 24s
Restart Phase #:4 [PDB2] Files:1 Time: 1s
************* Catalog Final Scripts ************
Serial Phase #:5 [PDB2] Files:7 Time: 24s
***************** Catproc Start ****************
Serial Phase #:6 [PDB2] Files:1 Time: 17s
***************** Catproc Types ****************
Serial Phase #:7 [PDB2] Files:2 Time: 13s
Restart Phase #:8 [PDB2] Files:1 Time: 2s
**************** Catproc Tables ****************
Parallel Phase #:9 [PDB2] Files:67 Time: 31s
Restart Phase #:10 [PDB2] Files:1 Time: 1s
************* Catproc Package Specs ************
Serial Phase #:11 [PDB2] Files:1 Time: 56s
Restart Phase #:12 [PDB2] Files:1 Time: 1s
************** Catproc Procedures **************
Parallel Phase #:13 [PDB2] Files:94 Time: 18s
Restart Phase #:14 [PDB2] Files:1 Time: 2s
Parallel Phase #:15 [PDB2] Files:120 Time: 22s
Restart Phase #:16 [PDB2] Files:1 Time: 1s
Serial Phase #:17 [PDB2] Files:22 Time: 9s
Restart Phase #:18 [PDB2] Files:1 Time: 1s
***************** Catproc Views ****************
Parallel Phase #:19 [PDB2] Files:32 Time: 25s
Restart Phase #:20 [PDB2] Files:1 Time: 2s
Serial Phase #:21 [PDB2] Files:3 Time: 18s
Restart Phase #:22 [PDB2] Files:1 Time: 1s
Parallel Phase #:23 [PDB2] Files:25 Time: 119s
Restart Phase #:24 [PDB2] Files:1 Time: 2s
Parallel Phase #:25 [PDB2] Files:12 Time: 90s
Restart Phase #:26 [PDB2] Files:1 Time: 1s
Serial Phase #:27 [PDB2] Files:1 Time: 0s
Serial Phase #:28 [PDB2] Files:3 Time: 10s
Serial Phase #:29 [PDB2] Files:1 Time: 0s
Restart Phase #:30 [PDB2] Files:1 Time: 1s
*************** Catproc CDB Views **************
Serial Phase #:31 [PDB2] Files:1 Time: 7s
Restart Phase #:32 [PDB2] Files:1 Time: 1s
Serial Phase #:34 [PDB2] Files:1 Time: 0s
***************** Catproc PLBs *****************
Serial Phase #:35 [PDB2] Files:293 Time: 25s
Serial Phase #:36 [PDB2] Files:1 Time: 0s
Restart Phase #:37 [PDB2] Files:1 Time: 1s
Serial Phase #:38 [PDB2] Files:6 Time: 9s
Restart Phase #:39 [PDB2] Files:1 Time: 0s
*************** Catproc DataPump ***************
Serial Phase #:40 [PDB2] Files:3 Time: 50s
Restart Phase #:41 [PDB2] Files:1 Time: 0s
****************** Catproc SQL *****************
Parallel Phase #:42 [PDB2] Files:13 Time: 90s
Restart Phase #:43 [PDB2] Files:1 Time: 2s
Parallel Phase #:44 [PDB2] Files:11 Time: 11s
Restart Phase #:45 [PDB2] Files:1 Time: 2s
Parallel Phase #:46 [PDB2] Files:3 Time: 8s
Restart Phase #:47 [PDB2] Files:1 Time: 2s
************* Final Catproc scripts ************
Serial Phase #:48 [PDB2] Files:1 Time: 14s
Restart Phase #:49 [PDB2] Files:1 Time: 1s
************** Final RDBMS scripts *************
Serial Phase #:50 [PDB2] Files:1 Time: 25s
************ Upgrade Component Start ***********
Serial Phase #:51 [PDB2] Files:1 Time: 7s
Restart Phase #:52 [PDB2] Files:1 Time: 1s
********** Upgrading Java and non-Java *********
Serial Phase #:53 [PDB2] Files:2 Time: 327s
***************** Upgrading XDB ****************
Restart Phase #:54 [PDB2] Files:1 Time: 1s
Serial Phase #:56 [PDB2] Files:3 Time: 20s
Serial Phase #:57 [PDB2] Files:3 Time: 11s
Parallel Phase #:58 [PDB2] Files:10 Time: 12s
Parallel Phase #:59 [PDB2] Files:25 Time: 16s
Serial Phase #:60 [PDB2] Files:4 Time: 20s
Serial Phase #:61 [PDB2] Files:1 Time: 0s
Serial Phase #:62 [PDB2] Files:32 Time: 11s
Serial Phase #:63 [PDB2] Files:1 Time: 0s
Parallel Phase #:64 [PDB2] Files:6 Time: 15s
Serial Phase #:65 [PDB2] Files:2 Time: 29s
Serial Phase #:66 [PDB2] Files:3 Time: 39s
**************** Upgrading ORDIM ***************
Restart Phase #:67 [PDB2] Files:1 Time: 2s
Serial Phase #:69 [PDB2] Files:1 Time: 10s
Parallel Phase #:70 [PDB2] Files:2 Time: 30s
Restart Phase #:71 [PDB2] Files:1 Time: 2s
Parallel Phase #:72 [PDB2] Files:2 Time: 11s
Serial Phase #:73 [PDB2] Files:2 Time: 10s
***************** Upgrading SDO ****************
Restart Phase #:74 [PDB2] Files:1 Time: 0s
Serial Phase #:76 [PDB2] Files:1 Time: 40s
Serial Phase #:77 [PDB2] Files:2 Time: 11s
Restart Phase #:78 [PDB2] Files:1 Time: 1s
Serial Phase #:79 [PDB2] Files:1 Time: 13s
Restart Phase #:80 [PDB2] Files:1 Time: 1s
Parallel Phase #:81 [PDB2] Files:3 Time: 50s
Restart Phase #:82 [PDB2] Files:1 Time: 2s
Serial Phase #:83 [PDB2] Files:1 Time: 11s
Restart Phase #:84 [PDB2] Files:1 Time: 0s
Serial Phase #:85 [PDB2] Files:1 Time: 19s
Restart Phase #:86 [PDB2] Files:1 Time: 0s
Parallel Phase #:87 [PDB2] Files:4 Time: 47s
Restart Phase #:88 [PDB2] Files:1 Time: 2s
Serial Phase #:89 [PDB2] Files:1 Time: 10s
Restart Phase #:90 [PDB2] Files:1 Time: 1s
Serial Phase #:91 [PDB2] Files:2 Time: 26s
Restart Phase #:92 [PDB2] Files:1 Time: 1s
Serial Phase #:93 [PDB2] Files:1 Time: 7s
Restart Phase #:94 [PDB2] Files:1 Time: 1s
******* Upgrading ODM, WK, EXF, RUL, XOQ *******
Serial Phase #:95 [PDB2] Files:1 Time: 17s
Restart Phase #:96 [PDB2] Files:1 Time: 1s
*********** Final Component scripts ***********
Serial Phase #:97 [PDB2] Files:1 Time: 9s
************* Final Upgrade scripts ************
Serial Phase #:98 [PDB2] Files:1 Time: 140s
******************* Migration ******************
Serial Phase #:99 [PDB2] Files:1 Time: 39s
*** End PDB Application Upgrade Pre-Shutdown ***
Serial Phase #:100 [PDB2] Files:1 Time: 8s
Serial Phase #:101 [PDB2] Files:1 Time: 12s
Serial Phase #:102 [PDB2] Files:1 Time: 6s
***************** Post Upgrade *****************
Serial Phase #:103 [PDB2] Files:1 Time: 141s
**************** Summary report ****************
Serial Phase #:104 [PDB2] Files:1 Time: 8s
*** End PDB Application Upgrade Post-Shutdown **
Serial Phase #:105 [PDB2] Files:1 Time: 7s
Serial Phase #:106 [PDB2] Files:1 Time: 8s
Serial Phase #:107 [PDB2] Files:1 Time: 0s
------------------------------------------------------
Phases [0-107] End Time:[2019_09_06 11:39:56]
Container Lists Inclusion:[PDB2] Exclusion:[NONE]
------------------------------------------------------
Grand Total Time: 2054s [PDB2]
LOG FILES: (/u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/testinst/upgrade20190906110439/catupgrdPDB2*.log)
Upgrade Summary Report Located in:
/u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/testinst/upgrade20190906110439/upg_summary.log
Time: 2141s For PDB(s)
Grand Total Time: 2141s
LOG FILES: (/u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/testinst/upgrade20190906110439/catupgrd*.log)
Grand Total Upgrade Time: [0d:0h:35m:41s]
7、19c验证pdb2是否正常
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO
4 PDB2 MOUNTED
#打开没有报错
SQL> alter pluggable database PDB2 open;
Pluggable database altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO
4 PDB2 READ WRITE NO
#没有没解决的问题
SQL> select name,message,type,STATUS from pdb_plug_in_violations where STATUS<>'RESOLVED' order by time;
no rows selected
##查看datafile是否正常
SQL> col FILE_NAME for a100
SQL> select FILE_ID,FILE_NAME,STATUS from dba_temp_files;
select FILE_ID,FILE_NAME,STATUS from dba_data_files;
FILE_ID FILE_NAME STATUS
---------- ---------------------------------------------------------------------------------------------------- -------
6 /new_oradata/TESTINST/PDB2/datafile/o1_mf_temp_gq3lsxh5_.dbf ONLINE
SQL>
FILE_ID FILE_NAME STATUS
---------- ---------------------------------------------------------------------------------------------------- ---------
45 /new_oradata/TESTINST/PDB2/datafile/o1_mf_system_gq3lsxh1_.dbf AVAILABLE
46 /new_oradata/TESTINST/PDB2/datafile/o1_mf_sysaux_gq3lsxh3_.dbf AVAILABLE
47 /new_oradata/TESTINST/PDB2/datafile/o1_mf_users_gq3lsxh6_.dbf AVAILABLE
50 /new_oradata/TESTINST/PDB2/datafile/o1_mf_slivven_gq3lsxhc_.dbf AVAILABLE
49 /new_oradata/TESTINST/PDB2/datafile/o1_mf_slivven_gq3lsxhb_.dbf AVAILABLE
48 /new_oradata/TESTINST/PDB2/datafile/o1_mf_slivven_gq3lsxh8_.dbf AVAILABLE
51 /new_oradata/TESTINST/91C59F5312420314E0530A0B0C02C2CE/datafile/o1_mf_undo_1_gq3m4y7p_.dbf AVAILABLE
7 rows selected.
至此,pdb的版本升级完成!!