How to change the diskgroup attribute "compatible.rdbms" safely
We have five production databases on a 2-node RAC cluster with ASM, and we would like to change the diskgroup compatibility attribute "compatible.rdbms" from 10.1 to 19.0
These are the current values :
SQL> SELECT SUBSTR(dg.name,1,12) AS diskgroup, SUBSTR(a.name,1,24) AS name, SUBSTR(a.value,1,24) AS value, read_only FROM V$ASM_DISKGROUP dg,V$ASM_ATTRIBUTE a WHERE dg.group_number = a.group_number AND a.name LIKE 'compatible%';
DISKGROUP NAME VALUE READ_ON
------------ ------------------------ ------------------------ -------
CRSDG compatible.asm 19.0.0.0.0 N
CRSDG compatible.rdbms 10.1.0.0.0 N
CRSDG compatible.advm 19.0.0.0.0 N
DATADG compatible.asm 19.0.0.0.0 N
DATADG compatible.rdbms 10.1.0.0.0 N