oda x6 restore database failure

[Adhrushta]

Hi erman,

we are facing and issue on our x6 ODA

while we trying to restore database,we are getting error;

ORA-17502: ksfdcre:3 Failed to create file +DATA/PROD/datafile/a_txn_data04.dbf
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15204: database version 11.2.0.4.0 is incompatible with diskgroup DATA

we are using 11.2.0.4 oracle rdbms.

 when i check with this sql on ASM;

select NAME,COMPATIBILITY from V$ASM_DISKGROUP;

NAME                           COMPATIBILITY
------------------------------ ------------------------------------------------------------
RECO                           12.1.0.2.0
DATA                           12.1.0.2.0

[ErmanArslansOracleBlog]

What is the output of;

select NAME,DATABASE_COMPATIBILITY, COMPATIBILITY from v$asm_diskgroup;

[Adhrushta]

select NAME,DATABASE_COMPATIBILITY, COMPATIBILITY from v$asm_diskgroup;

NAME                           DATABASE_COMPATIBILITY                                       COMPATIBILITY
------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
RECO                           12.1.0.2.0                                                   12.1.0.2.0
DATA                           12.1.0.2.0                                                   12.1.0.2.0

[ErmanArslansOracleBlog]

Database compatability is 12.1.0.2.
So the error is normal. You can't restore a 11.2.0.4 database into this system.

[ErmanArslansOracleBlog]

Here is what I can suggest for you.

Use ACFS in ODA X6-2.

Create a dummy 11.2.0.4 database from Appliance Manager .. This action will create an ACFS filesystem for you.
Delete that dummy database using standard approaches and use the created ACFS filesystem for your restore.

Update me with the outcome.

[Abhayankari]

ty Erman, I didnt know anything about ACFS,I did exactly as you said, and restore completed succesfully.

[Abhayankari]

when we create appliance on ODA X6,ASM software creating automatically .But why can't we use ASM directly?It seems ASM useless in these setups.What is the relation between ACFS and ASM?

[ErmanArslansOracleBlog]

ACFS uses ASM in the backend.
It is an filesystem built on top of ASM.
So, ASM is not useless here.

ACFS is much more useful than ASM.
For instance; ASM has a limit of 1 million files per Diskgroup. ACFS, on the other hand; supports 2^40 (1 trillion) files in a file system.
ACFS has also the snapshot ability.

Oracle uses ACFS in its new Enginereed Systems, but still it requires ASM. ACFS uses it. So nothing is useless in engineered systems :)

[Abhayankari]

I see . ty for your explanation.i will research this. :)