ORA-15204: database version 11.2.0.1.0 is incompatible with diskgroup P01_DATA

ORA-15204: database version 11.2.0.1.0 is incompatible with diskgroup P01_DATA

I am going to setup the database dataguard environment with upper version 11204 but while running RMAN duplicate command getting error:
Error

RMAN-03002: failure of Duplicate Db command at 14/20/2019 10:45:11
RMAN-05501: aborting duplication of target database
RMAN-06136: ORACLE error from auxiliary database: ORA-00200: control file could not be created
ORA-00202: control file: '+P01_DATA'
ORA-17502: ksfdcre:4 Failed to create file +P01_DATA
ORA-15001: diskgroup "P01_DATA" does not exist or is not mounted
ORA-15204: database version 11.2.0.1.0 is incompatible with diskgroup P01_DATA

Cause
From error clear indicate that Diskgroup is not compatible with database version.

Solution
1. Check the compatibility of DATA_PROD diskgroup on both Primary and standby servers

col COMPATIBILITY form a10.
col DATABASE_COMPATIBILITY form a10.
col NAME form a20.
select group_number, name, compatibility, database_compatibility from v$asm_diskgroup;

2. Both not compatibile, Drop your existing ASM P01_DATA diskgroup.
Note: it will remove all the data, it it empty then delete it. i am creating standby so my diskgroup is empty.

DROP DISKGROUP P01_DATA INCLUDING CONTENTS;

3. Create the new ASM diskgroup P01_DATA with matching compatibility of primary.

create diskgroup P01_DATA normal redundancy
disk '/disk/p01_disk*'
'au_size'='4M',
'compatible.asm'='11.2.0.0.0',
'compatible.rdbms'='11.2.0.0.0';

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply