Database version is incompatible with diskgroup
Source:
ASM:12.2.0.1.0
DB:12.1.0.2.0
COMPATIBLE:11.2.0.3.0
I am trying to create a physical standby on another remote host with Grid infra restart ASM configuration as follows:
ASM:19.0.0.0.0
Database Compatibility 12.1.0.2.0
ASM Compatibility 19.0.0.0.0
ASM Volume Compatibility 19.0.0.0.0
I received "ORA-15204: database version 11.2.0.3.0 is incompatible with diskgroup" error when I tried to create a standby database.
Was it due to COMPATIBLE parameter setting on the source DB?
To overcome this issue, am I supposed to update COMPATIBLE DB initialization parameter on source DB to be 12.1.0 or 12.1.0.2? If I update it to 12.1.0,
Am I still going to end up with the same error?
To avoid updating to COMPATIBLE on source DB, I need to drop and recreate diskgroups on the standby server to lower the DB compatibility to 11.0.0.0.0 or 11.2.0.3.0.