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.