ADG_REDIRECT_DML in Oracle Active Data Guard 19c

ORA-15032 ORA-59303 ORA-15221: ASM operation requires compatible.asm of ...

During upgrading GI (already visible in 11g/12c/19c) and during execution of rootupgrade.sh following errors was visible:
CRS-6705: Oracle Clusterware Release Version ('19.0.0.0.0') does not match Software Version ('12.1.0.2.0'). Oracle Clusterware cannot be started.

CRS-4000: Command Start failed, or completed with errors.

2021/04/20 09:42:30 CLSRSC-318: Failed to start Oracle OHASD service
Died at /u01/app/oracle/product/19.0.0.0_gi/crs/install/crsupgrade.pm line 6269.

root@oralin1:/u01/app/oracle/product/19.0.0.0_gi
Result was that some disk groups were not mounted:
SQL> select NAME, STATE, COMPATIBILITY from v$asm_diskgroup;

NAME  STATE 		COMPATIBILITY
----- ------------ ---------------
REDO  MOUNTED     	19.0.0.0.0
DATA  DISMOUNTED  	0.0.0.0.0
FRA   DISMOUNTED  	0.0.0.0.0

When trying to mount it:
SQL> alter diskgroup FRA mount;
alter diskgroup FRA mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-59303: The attribute compatible.asm (10.1.0.0.0) of the 
           diskgroup being mounted should be 11.2.0.2.0 or higher.
ORA-15221: ASM operation requires compatible.asm of 11.1.0.0.0 
           or higher

Solution:
SQL> alter diskgroup FRA mount restricted;

Diskgroup altered.

SQL> alter diskgroup FRA set attribute 'compatible.asm'='19.0.0.0.0';

Diskgroup altered.

SQL> alter diskgroup FRA dismount;

Diskgroup altered.

SQL> alter diskgroup DATA mount restricted;

Diskgroup altered.

SQL> alter diskgroup DATA set attribute 'compatible.asm'='19.0.0.0.0';

Diskgroup altered.

SQL> alter diskgroup DATA dismount;

Diskgroup altered.

SQL> alter diskgroup FRA mount;

Diskgroup altered.



SQL>   select NAME, STATE, COMPATIBILITY  from  v$asm_diskgroup;

NAME                           STATE       COMPATIBILITY
------------------------------ ----------- -------------------
REDO                           MOUNTED     19.0.0.0.0
DATA                           MOUNTED     19.0.0.0.0
FRA                            MOUNTED     19.0.0.0.0

Comments