创建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);