New Disks are provisioned , which is greater than 2TB but unable to create disk group using those disks
devhost:NOTSET:/home/oracle $ oracleasm listdisks | grep -i CBDEV
CBDEV_DATA1
CBDEV_RECO1
devhost:NOTSET:/home/oracle $ oracleasm querydisk CBDEV_DATA1
Disk "CBDEV_DATA1" is a valid ASM disk
devhost:NOTSET:/home/oracle $ oracleasm querydisk CBDEV_RECO1
Disk "CBDEV_RECO1" is a valid ASM disk
devhost:NOTSET:/home/oracle $ oracleasm querydisk /dev/asm/asm_CBDEV_DATA1
Device "/dev/asm/asm_cbdev_DATA1" is marked an ASM disk with the label "CBDEV_DATA1"
devhost:NOTSET:/home/oracle $ oracleasm querydisk /dev/asm/asm_CBDEV_RECO1
Device "/dev/asm/asm_cbdev_RECO1" is marked an ASM disk with the label "CBDEV_RECO1"
devhost:+ASM:/home/oracle $ sqlplus / as sysasm
SQL*Plus: Release 12.1.0.2.0 Production on Fri Mar 27 11:34:48 2020
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Automatic Storage Management option
SQL> col header for a22
SQL> set pages 999 lines 280
SQL> col path for a33
SQL> select header_status "Header", mode_status "Mode", path "Path", lpad(round(os_mb/1024),7)||'Gb' "Disk Size" from v$asm_disk where path like ‘%CB%’;
Header Mode Path Disk Size
---------------------- ------- --------------------------------- ---------
PROVISIONED ONLINE ORCL:CBDEV_DATA1 4096Gb
PROVISIONED ONLINE ORCL:CBDEV_RECO1 1024Gb
SQL> select GROUP_NUMBER,MOUNT_STATUS,STATE,REDUNDANCY,NAME,PATH from v$asm_disk where path like ‘%CB%’;
GROUP_NUMBER MOUNT_S STATE REDUNDA NAME PATH
------------ ------- -------- ------- ------------------------------ ---------------------------------
0 CLOSED NORMAL UNKNOWN ORCL:CBDEV_DATA1
0 CLOSED NORMAL UNKNOWN ORCL:CBDEV_RECO1
SQL> select state, name, type from v$asm_diskgroup;
STATE NAME TYPE
----------- ------------------------------ ------
MOUNTED RECO1 EXTERN
MOUNTED DATA1 EXTERN
SQL> create diskgroup CBDEVDATA1 external redundancy disk 'ORCL:CBDEV_DATA1' name CBDEVDATA1;
create diskgroup CBDEVDATA1 external redundancy disk 'ORCL:CBDEV_DATA1' name CBDEVDATA1
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15099: disk 'ORCL:CBDEV_DATA1' is larger than maximum size of 2097152 MBs
SQL> select group_number,name,state,compatibility, database_compatibility from v$asm_diskgroup where name like ‘%CB%’ ;
GROUP_NUMBER NAME STATE COMPATIBILITY DATABASE_COMPATIBILITY
------------ ------------------------------ ----------- --------------------------------------------------- --------------------------------------------
11 RECO1 MOUNTED 10.1.0.0.0 10.1.0.0.0
13 DATA1 MOUNTED 10.1.0.0.0 10.1.0.0.0
SQL> col name for a28
SQL> col VALUE for a22
SQL> select name, value,GROUP_NUMBER from v$asm_attribute where name like 'comp%';
NAME VALUE GROUP_NUMBER
---------------------------- ---------------------- ------------
compatible.asm 12.1.0.2.0 3
compatible.rdbms 12.1.0.2.0 3
compatible.asm 12.1.0.2.0 8
compatible.rdbms 12.1.0.2.0 8
compatible.asm 12.1.0.2.0 14
compatible.rdbms 12.1.0.2.0 14
compatible.asm 12.1.0.2.0 18
compatible.rdbms 12.1.0.2.0 18
8 rows selected.
SQL> create diskgroup CBRECO1 external redundancy disk 'ORCL:CBDEV_RECO1' name CBDEV_RECO1;
Diskgroup created.
SQL> select group_number,name,state,compatibility, database_compatibility from v$asm_diskgroup;
GROUP_NUMBER NAME STATE COMPATIBILITY DATABASE_COMPATIBILITY
------------ ---------------------------- ----------- ------------------------------------------------------------ -------------------------------------------------
11 RECO1 MOUNTED 10.1.0.0.0 10.1.0.0.0
13 DATA1 MOUNTED 10.1.0.0.0 10.1.0.0.0
15 CBRECO1 MOUNTED 10.1.0.0.0 10.1.0.0.0
16 rows selected.
Note:
Starting with Oracle ASM version 12.2.0.1, the minimum and default settings for Oracle ASM disk group attributes are:
COMPATIBLE.ASM = 11.2.0.2 and COMPATIBLE.RDBMS = 10.1 for EXTERNAL, NORMAL, and HIGH redundancy disk groups
COMPATIBLE.ASM = 12.2.0.1 and COMPATIBLE.RDBMS = 12.2.0.1 for FLEX and EXTENDED disk groups
SQL> create diskgroup CBDEVDATA1 external redundancy disk 'ORCL:CBDEV_DATA1' name CBDEVDATA1 attribute 'compatible.rdbms'='12.1.0.2.0';
create diskgroup CBDEVDATA1 external redundancy disk 'ORCL:CBDEV_DATA1' name CBDEVDATA1 attribute 'compatible.rdbms'='12.1.0.2.0'
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15234: target RDBMS compatibility (12.1.0.2.0) exceeds ASM compatibility (10.1.0.0.0)
SQL> create diskgroup CBDEVDATA1 external redundancy disk 'ORCL:CBDEV_DATA1' name CBDEVDATA1 attribute 'compatible.asm'='12.1.0.2.0' , 'compatible.rdbms'='12.1.0.2.0';
Diskgroup created.
SQL> select group_number,name,state,compatibility, database_compatibility from v$asm_diskgroup where name like '%CB%';
GROUP_NUMBER NAME STATE COMPATIBILITY DATABASE_COMPATIBILITY
------------ ---------------------------- --------------------------------- ---------------------------------
16 CBDEVDATA1 MOUNTED 12.1.0.2.0 12.1.0.2.0
15 CBRECO1 MOUNTED 10.1.0.0.0 10.1.0.0.0
SQL> select GROUP_NUMBER,MOUNT_STATUS,STATE,REDUNDANCY,NAME,PATH from v$asm_disk where name like '%CB%';
GROUP_NUMBER MOUNT_S STATE REDUNDA NAME PATH
------------ ------- -------- ------- ---------------------------- ---------------------------------
16 CACHED NORMAL UNKNOWN CBDEVDATA1 ORCL:CBDEV_DATA1
15 CACHED NORMAL UNKNOWN CBDEV_RECO1 ORCL:CBDEV_RECO1
SQL> select header_status "Header", mode_status "Mode", path "Path", lpad(round(os_mb/1024),7)||'Gb' "Disk Size" from v$asm_disk where path like '%CB%';
Header Mode Path Disk Size
---------------------- ------- --------------------------------- ---------
MEMBER ONLINE ORCL:CBDEV_DATA1 4096Gb
MEMBER ONLINE ORCL:CBDEV_RECO1 1024Gb
So finally, I have successfully created DG with 4TB disk
