Home » Server Options » RAC & Failsafe » ksfdopn:2 Failed to open file +FLASH_RECOVERY_AREA (Oracle10g, RAC, Suse 10.2)
icon5.gif  ksfdopn:2 Failed to open file +FLASH_RECOVERY_AREA [message #597624] Mon, 07 October 2013 04:11 Go to next message
burasami
Messages: 20
Registered: April 2010
Junior Member
Hi All,

When I try to start the database or ASM instance its showing the following error.

SQL> connect sys  as sysdba  
Enter password:  
Connected to an idle instance.  
SQL> startup  
ORA-01078: failure in processing system parameters  
ORA-01565: error in identifying file '+FLASH_RECOVERY_AREA/XXXXX/spfileXXXXX.ora'  
ORA-17503: ksfdopn:2 Failed to open file +FLASH_RECOVERY_AREA/XXXXX/spfileXXXXXX.ora  
ORA-15077: could not locate ASM instance serving a required diskgroup  
SQL>  
 



when am trying to view the data's by below Sql its show name as null for FLASH_RECOVERY_AREA. so I couldn't even set compatible ATTRIBUTE
SQL> select NAME , COMPATIBILITY, DATABASE_COMPATIBILITY from V$ASM_DISKGROUP;  
NAME                         COMPATIBILITY      DATABASE_COMPATIBILITY  
-------------                  ---------------------- -----------------------------------  
RUBIKON_DATA         10.1.0.0.0              10.1.0.0.0  




 
SQL> show parameter asm_disk  
NAME                                 TYPE        VALUE  
------------------------------------ ----------- ------------------------------  
asm_diskgroups                       string      RUBIKON_DATA, FLASH_RECOVERY_A  
                                                 REA  
asm_diskstring                       string      /dev/mapper/Rubikon_data1, /dev/mapper/Rubikon_data2, /dev/mapper/Rubikon_fb  
 


because of name is null mount mode as CLOSED and HEADER_STATUS as INCOMPATIBLE.

SQL> select  name, mount_status, header_status,mode_status,state, path from v$asm_disk ;  
NAME                           MOUNT_S HEADER_STATU MODE_ST STATE   PATH  
--------------                  -------       ------------            -------    --------  -------------------------  
                               CLOSED  INCOMPATIBLE ONLINE  NORMAL /dev/mapper/Rubikon_fb  
RUBIKON_DATA_0000   CACHED  MEMBER       ONLINE  NORMAL /dev/mapper/Rubikon_data1  
RUBIKON_DATA_0001   CACHED  MEMBER       ONLINE  NORMAL /dev/mapper/Rubikon_data2  


Please help me to mount the disk..

Thanks & Regards
Sami


icon2.gif  Re: ksfdopn:2 Failed to open file +FLASH_RECOVERY_AREA [message #597630 is a reply to message #597624] Mon, 07 October 2013 04:22 Go to previous message
Michel Cadot
Messages: 58635
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

1) If you use a pfile (init.ora) find in it where "+FLASH_RECOVERY_AREA/XXXXX/spfileXXXXX.ora" is mentioed.
2) If you use a spfile, create a pfile from it and go to 1)

Previous Topic: Oracle CRS failure. Rebooting for cluster integrity.
Next Topic: Active/Active configuration
Goto Forum:
  


Current Time: Thu Jul 31 13:49:54 CDT 2014

Total time taken to generate the page: 0.24177 seconds