创建Flex 磁盘组和NORMAL转换为FLEX 存储PDB到FLEX

创建Flex 磁盘组

create diskgroup TEST_FLEX flex redundancy disk '/dev/oracleasm/disks/TEST3','/dev/oracleasm/disks/TEST4','/dev/oracleasm/disks/TEST5';

select GROUP_NUMBER,NAME,STATE,TYPE from v$asm_diskgroup

NORMAL 转换为 FLEX Diskgroup(最少三块磁盘的NORMAL)

create diskgroup TEST_FLEX flex redundancy disk '/dev/oracleasm/disks/TEST3','/dev/oracleasm/disks/TEST4','/dev/oracleasm/disks/TEST5'

要用三块磁盘

select NAME,VALUE,GROUP_NUMBER from  v$asm_attribute where GROUP_NUMBER=3 and NAME like '%compatible.asm%';

ALTER DISKGROUP LH_TEST SET ATTRIBUTE 'compatible.asm' = '12.2';

ALTER DISKGROUP LH_TEST SET ATTRIBUTE 'compatible.rdbms' = '12.2';

 

 

 alter diskgroup LH_TEST dismount;

 

alter diskgroup LH_TEST mount restricted;

ALTER DISKGROUP LH_TEST CONVERT REDUNDANCY TO FLEX;

alter diskgroup LH_TEST dismount;

alter diskgroup LH_TEST mount;

 

存储PDB到FLEX

        

 select c.name container, d.file_name, bytes/1024/1024 size_mb

from v$containers c, cdb_data_files d

where c.con_id=d.con_id and c.name='PDB1';

ALTER PLUGGABLE DATABASE pdb1 CLOSE IMMEDIATE;

 

alter session set db_create_file_dest='+LH_TEST';

create pluggable database pdb1 admin user pdbadmin identified by oracle default tablespace pdb1tbs datafile size 200M autoextend off storage (maxsize 800M);

alter pluggable database pdb1 open;

 

 

select filegroup_number, name filegroup, client_name, guid from v$asm_filegroup;

 

 

 create pluggable database pdb2 admin user pdbadmin identified by oracle default tablespace pdb2tbs datafile size 2M autoextend off storage (maxsize 800M);

 

 

 

ALTER DISKGROUP LH_TEST ADD FILEGROUP FILEGROUP_PDB1 DATABASE PDB1;

 

 

创建一个新的文件组，然后创建一个新的 PDB 

 

 

 

create pluggable database pdb3 admin user pdbadmin identified by oracle default tablespace pdb2tbs datafile size 2M autoextend off storage (maxsize 800M);