Hi All,
We have 2 node with such node 1 and node 2.
From both nodes we can start the cluster environment.. at present node 2 is down due to OS problem.
So i am trying to start the cluster from node 1 and started fine..
while am trying to start the database... it show me error as follows
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>
oracle has mounted only data disk group .. its failing to mount FLASHBACK_RECOVERY_AREA.
Enter user-name: /as sysdba
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> select NAME,TOTAL_MB,FREE_MB from v$asm_diskgroup;
NAME TOTAL_MB FREE_MB
------------------------------ ---------- ----------
RUBIKON_DATA 358400 292097
When i try to mount it .. it showing following error....
SQL> alter diskgroup FLASH_RECOVERY_AREA mount;
alter diskgroup FLASH_RECOVERY_AREA mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "FLASH_RECOVERY_AREA"
but ASM is listing all nodes..
XXXXXX120:/ # /etc/init.d/oracleasm listdisks
RUBIKON_DATA1
RUBIKON_DATA2
RUBIKON_FB01
rubikon120:/ #
NAME HEADER_STATU PATH
------------------------------ ------------ ---------------------------------------------------------------------------------------------------------------
PROVISIONED /dev/mapper/Rubikon_fb
RUBIKON_DATA_0000 MEMBER /dev/mapper/Rubikon_data1
RUBIKON_DATA_0001 MEMBER /dev/mapper/Rubikon_data2
Please guide me how to mount the disk...
Thanks & Regards
Sami