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
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