Converting Normal Disk Groups to Flex Disk Groups in Oracle 18c

In this post, You can convert a conventional disk group ie created before Oracle ASM 18c to an Oracle ASM flex disk group without using the restrictive mount (MOUNTED RESTRICTED) option.

Migrating (converting) to a flex disk group can be performed for a NORMAL or HIGH redundancy disk group with the CONVERT REDUNDANCY TO FLEX clause of the ALTER DISKGROUP SQL statement. You cannot migrate an EXTERNAL redundancy disk group to a FLEX redundancy disk group.

Below are steps to convert Normal Redundancy to Flex.

[oracle@RAC18C ~]$ sqlplus / as sysasm

SQL*Plus: Release 18.0.0.0.0 Production on Fri Mar 16 03:00:59 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> CREATE DISKGROUP TEST_NORMAL_TO_FLEX NORMAL REDUNDANCY DISK '/dev/oracleasm/disks/DISK4','/dev/oracleasm/disks/DISK5','/dev/oracleasm/disks/DISK6' ATTRIBUTE 'au_size'='4M', 'compatible.asm' = '18.0', 'compatible.rdbms' = '18.0','compatible.advm' = '18.0';

Diskgroup created.

SQL> SELECT name, type FROM V$ASM_DISKGROUP;

NAME                           TYPE
------------------------------ ------
OCR                            EXTERN
TEST_NORMAL_TO_FLEX            NORMAL

SQL> ALTER DISKGROUP TEST_NORMAL_TO_FLEX CONVERT REDUNDANCY TO FLEX;

Diskgroup altered.

SQL> SELECT name, type FROM V$ASM_DISKGROUP;

NAME                           TYPE
------------------------------ ------
OCR                            EXTERN
TEST_NORMAL_TO_FLEX            FLEX

SQL>

Stay tuned for More articles on Oracle 18c 

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp