这两天把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
Splitting the Mirrored Copy and Creating the Database Clone
SQL> CREATE PLUGGABLE DATABASE newpdb1 FROM pdb1 USING MIRROR COPY pdb1_copy;
Pluggable database created.
查看V$ASM_DBCOLNE_INFO和V$ASM_FILEGROUP视图中的信息
[grid@db18adm01 ~]$ sqlplus / as sysasm
SQL*Plus: Release 18.0.0.0.0 Production on Fri Mar 16 00:01:54 2018
Version 18.1.0.0.0
Copyright (c) 1982, 2017, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 – Production
Version 18.1.0.0.0
SQL> col DBCLONE_NAME for a20
SQL> col MIRRORCOPY_NAME for a20
SQL> col DBCLONE_STATUS for a20
SQL> col PARENT_DBNAME for a20
SQL> col PARENT_FILEGROUP_NAME for a20
SQL> set lines 1000
SQL> select * from V$ASM_DBCLONE_INFO;
GROUP_NUMBER DBCLONE_NAME MIRRORCOPY_NAME DBCLONE_STATUS PARENT_DBNAME PARENT_FILEGROUP_NAM CON_ID
———— ——————– ——————– ——————– ——————– ——————– ———-
3 DB18C_NEWPDB1 PDB1_COPY SPLIT COMPLETED DB18C_PDB1 DB18C_PDB1 0
SQL> col NAME for a40
SQL> SELECT NAME, GROUP_NUMBER, FILEGROUP_NUMBER FROM V$ASM_FILEGROUP;
NAME GROUP_NUMBER FILEGROUP_NUMBER
—————————————- ———— —————-
DEFAULT_FILEGROUP 3 0
DB18C_CDB$ROOT 3 1
DB18C_PDB$SEED 3 2
DB18C_PDB1 3 3
PDB1_COPY 3 4
查看V$ASM_FILEGROUP_PROPERTY视图中的信息
SQL> set pages 1000
SQL> select FILE_TYPE,NAME,VALUE from V$ASM_FILEGROUP_PROPERTY WHERE FILEGROUP_NUMBER = 4;
FILE_TYPE NAME VALUE
—————————— —————————————- ——————————————————————————————————————————–
PRIORITY MEDIUM
PARENT_FILEGROUP_NUMBER3
DBCLONE_STATUSSPLIT COMPLETED
COMPATIBLE.CLIENT18.0.0.0.0
CONTROLFILE REDUNDANCY MIRROR
CONTROLFILE STRIPING FINE
DATAFILE REDUNDANCY MIRROR
DATAFILE STRIPING COARSE
ONLINELOG REDUNDANCY MIRROR
ONLINELOG STRIPING COARSE
ARCHIVELOG REDUNDANCY MIRROR
ARCHIVELOG STRIPING COARSE
TEMPFILE REDUNDANCY MIRROR
TEMPFILE STRIPING COARSE
BACKUPSET REDUNDANCY MIRROR
BACKUPSET STRIPING COARSE
PARAMETERFILE REDUNDANCY MIRROR
PARAMETERFILE STRIPING COARSE
DATAGUARDCONFIG REDUNDANCY MIRROR
DATAGUARDCONFIG STRIPING COARSE
CHANGETRACKING REDUNDANCY MIRROR
CHANGETRACKING STRIPING COARSE
FLASHBACK REDUNDANCY MIRROR
FLASHBACK STRIPING COARSE
DUMPSET REDUNDANCY MIRROR
DUMPSET STRIPING COARSE
AUTOBACKUP REDUNDANCY MIRROR
AUTOBACKUP STRIPING COARSE
VOTINGFILE REDUNDANCY MIRROR
VOTINGFILE STRIPING COARSE
OCRFILE REDUNDANCY MIRROR
OCRFILE STRIPING COARSE
ASMVOL REDUNDANCY MIRROR
ASMVOL STRIPING COARSE
ASMVDRL REDUNDANCY MIRROR
ASMVDRL STRIPING COARSE
OCRBACKUP REDUNDANCY MIRROR
OCRBACKUP STRIPING COARSE
FLASHFILE REDUNDANCY MIRROR
FLASHFILE STRIPING COARSE
XTRANSPORT BACKUPSET REDUNDANCY MIRROR
XTRANSPORT BACKUPSET STRIPING COARSE
AUDIT_SPILLFILES REDUNDANCY MIRROR
AUDIT_SPILLFILES STRIPING COARSE
INCR XTRANSPORT BACKUPSET REDUNDANCY MIRROR
INCR XTRANSPORT BACKUPSET STRIPING COARSE
KEY_STORE REDUNDANCY MIRROR
KEY_STORE STRIPING COARSE
AUTOLOGIN_KEY_STORE REDUNDANCY MIRROR
AUTOLOGIN_KEY_STORE STRIPING COARSE
CONTAINER REDUNDANCY MIRROR
CONTAINER STRIPING COARSE
52 rows selected.