Oracle 18c New Features: Split Mirror Clone PDBs

这两天把Oracle 18C的集群（抢先版）给安装好了，然后进行了18C数据库的一些新功能体验，以下是Split Mirror Clone PDBs的试验内容

Starting in Oracle Database 18c, the parent copy can be a PDB rather than a storage volume. The split mirror clone PDB resides on the same media as the parent. The principal use case is to rapidly provision test and development PDBs in an Oracle ASM environment.

SQL> show con_name

CON_NAME

——————————

CDB$ROOT

SQL> show pdbs

CON_ID CON_NAME             OPEN MODE RESTRICTED

———- —————————— ———- ———-

2 PDB$SEED             READ ONLY NO

3 PDB1              READ WRITE NO

SQL> alter session set container=PDB1;

Session altered.

 

执行以下语句，提示要修改磁盘组的compatible.rdbms属性为18.0.0.0.0或更高

SQL> ALTER PLUGGABLE DATABASE PREPARE MIRROR COPY PDB1_COPY;

ALTER PLUGGABLE DATABASE PREPARE MIRROR COPY PDB1_COPY

*

ERROR at line 1:

ORA-15283: ASM operation requires compatible.rdbms of 18.0.0.0.0 or higher

使用asmca进行了修改

修改完成后再执行以下语句创建

SQL> ALTER PLUGGABLE DATABASE PREPARE MIRROR COPY PDB1_COPY;

Pluggable database altered.

SQL> SHOW CON_NAME

CON_NAME

——————————

PDB1

SQL> alter session set container=CDB$ROOT;

Session altered.

SQL> show con_name

CON_NAME

——————————

CDB$ROOT

 

SQL> CREATE PLUGGABLE DATABASE newpdb1 FROM pdb1 USING MIRROR COPY pdb1_copy;

Pluggable database created.

 

查看V$ASM_DBCOLNE_INFO和V$ASM_FILEGROUP视图中的信息