New Redundancy Option in Disk Group in Oracle 12.2 - FLEX

Introduction

Oracle Database 12.2 has introduced one more redundancy option while creating disk groups. The new option 'FLEX' 
disk group we can assign to Container database as well as pluggable databases based on redundancy requirements. 
We can use ASM File Driver also while creating disk groups.

We can use ASMCA / ASMCMD to create FLEX disk group.









Add Quota and assign to CDB using FLEX disk group

[oracle@rac1-12c ~]$ sqlplus / as sysasm

SQL*Plus: Release 12.2.0.1.0 Production on Sat Jul 22 10:06:43 2017
Copyright (c) 1982, 2016, Oracle.  All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> CREATE DISKGROUP FLEX_DG FLEX REDUNDANCY
DISK '/dev/rac1-12c-asmdisk7'  SIZE 25595M
DISK '/dev/rac1-12c-asmdisk8'  SIZE 25595M
DISK '/dev/rac1-12c-asmdisk11' SIZE 25595M
ATTRIBUTE 
'compatible.asm'='12.2.0.1',
'compatible.rdbms'='12.2.0.1',
'compatible.advm'='12.2.0.1',
'au_size'='4M';

Diskgroup created.

SQL> select name, os_mb, failgroup, path from v$asm_disk;

SQL> alter diskgroup flex_dg add quotagroup QUOTA_CDB1 set quota = 10g;
Diskgroup altered.

SQL> alter diskgroup flex_dg add quotagroup QUOTA_CDB2 set quota = 10g;
Diskgroup altered.

SQL> alter diskgroup flex_dg add quotagroup QUOTA_CDB3 set quota = 10g;
Diskgroup altered.