oracle 12c non-cdb升級成cdb模式

oracle 12c non-cdb升級成cdb模式

相同主機下，有一個non-cdb數據庫，再創建一個cdb的實例。

SQL> select name,cdb from v$database;

NAME                        CDB

--------------------------- ---------

EID                         NO

1 row selected.

關閉數據庫并以read only模式打開

16:50:58 SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

16:51:39 SQL> startup open read only;

ORACLE instance started.

Total System Global Area 1426063360 bytes

Fixed Size                  8620704 bytes

Variable Size             486540640 bytes

Database Buffers          922746880 bytes

Redo Buffers                8155136 bytes

Database mounted.

Database opened.

SQL> select name,open_mode,cdb from v$database;

NAME                        OPEN_MODE                                                    CDB

--------------------------- ------------------------------------------------------------ ---------

EID                         READ ONLY                                                    NO

1 row selected.

生成xml格式的數據庫描述文件

SQL> BEGIN

  2    DBMS_PDB.DESCRIBE(pdb_descr_file => '/home/oracle/EID.xml');

  3  END;

  4  /

PL/SQL procedure successfully completed.

關閉數據庫

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

連接到cdb數據庫

SQL> CREATE PLUGGABLE DATABASE mpdb01 USING '/home/oracle/EID.xml'

  2  COPY

  3  FILE_NAME_CONVERT = ('/u02/app/oracle/oradata/EID/', '/u02/app/oracle/oradata/mcdb/mpdb01/');

Pluggable database created.

SQL> show pdbs  

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 MPDB01                         MOUNTED

SQL> alter session set container=MPDB01;

Session altered.

執行如下命令。注意該命令會清空shared pool，所以生產環境要注意。

sql> @$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql

SQL> alter pluggable database MPDB01 open;

Pluggable database altered.