"Recovery Manager Failed to Restore Datafiles" - Using DBCA To Create Database 12.1.0.2.0 on Grid Infrastructure / ASM 12.2.0.1.0

Error:-
while creating a database using Database Configuration Assistant (DBCA) the following error is encountered:  "Recovery Manager Failed to Restore Datafiles"

"Recovery Manager Failed to Restore Datafiles" - Using DBCA To Create Database 12.1.0.2.0 on Grid Infrastructure / ASM 12.2.0.1.0 



Solution 1 :-

Check the compatibility of ASM & Database .

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

NAME          STATE       COMPATIBILITY   DATABASE_COMPATIBILITY
------------- ----------- --------------- -------------------------
FRA           MOUNTED     12.1.0.0.0      10.1.0.0.0
OCR_VOTING    MOUNTED     12.1.0.0.0      10.1.0.0.0
DATA          MOUNTED     12.1.0.0.0      10.1.0.0.0

Change compatibility of database as like ASM

Here ASM having 12.1.0.0.0 & DB having 10.1.0.0.0

SQL> alter diskgroup FRA set ATTRIBUTE 'compatible.rdbms' ='12.1.0.0.0';

Diskgroup altered.

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

NAME          STATE       COMPATIBILITY   DATABASE_COMPATIBILITY
------------- ----------- --------------- -------------------------
FRA           MOUNTED     12.1.0.0.0      12.1.0.0.0
OCR_VOTING    MOUNTED     12.1.0.0.0      10.1.0.0.0
DATA          MOUNTED     12.1.0.0.0      10.1.0.0.0

SQL> alter diskgroup DATA set ATTRIBUTE 'compatible.rdbms' ='12.1.0.0.0';

Diskgroup altered.

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

NAME          STATE       COMPATIBILITY   DATABASE_COMPATIBILITY
------------- ----------- --------------- -------------------------
FRA           MOUNTED     12.1.0.0.0      12.1.0.0.0
OCR_VOTING    MOUNTED     12.1.0.0.0      10.1.0.0.0
DATA          MOUNTED     12.1.0.0.0      12.1.0.0.0



Solution 2 :- 

Change permission of oracle file to 6751 for both grid & databse

[ora12c@RAC1~]$ cd /rdbms/app/oracle/12.1.0.2/db/bin
[ora12c@RAC1 bin]$ ls -ltr oracle*
-rwxr-x---. 1 ora12c oinstall         0 Jul  7  2014 oracleO
-rwsr-s--x. 1 ora12c oinstall 323649840 Aug 11 09:56 oracle
[ora12c@RAC1~]$ chmod 6751 /rdbms/app/oracle/12.1.0.2/db/bin/oracle

For detail steps go to below link

How to change permission of oracle file to 6751


Thats it:)

No comments:

Post a Comment