Oracle Database Discussions

Hi All,

While starting the RAC instance on the first node , i am getting the following error and my database is not opened.

#######################################################################################
SQL> startup
ORACLE instance started.

Total System Global Area 608174080 bytes
Fixed Size 2058048 bytes
Variable Size 255854784 bytes
Database Buffers 343932928 bytes
Redo Buffers 6328320 bytes
Database mounted.
ORA-00313: open failed for members of log group 6 of thread 2
ORA-00312: online log 6 thread 2: '/u01/redo_groups/logSLVMRAC26.ora'
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3
#######################################################################################

The redolog file "/u01/redo_groups/logSLVMRAC26.ora" has been created in the local disk for the RAC instance 2 in the second node in 2 node cluster. Like that i have created redolog file "/u01/redo_groups/logSLVMRAC15.ora" for RAC instance 1 in the first node in the localdisk. When am starting the RAC instance 2 in second node am getting the similar error.

#######################################################################################
SQL> startup
ORACLE instance started.

Total System Global Area 608174080 bytes
Fixed Size 2058048 bytes
Variable Size 264243392 bytes
Database Buffers 335544320 bytes
Redo Buffers 6328320 bytes
Database mounted.
ORA-00313: open failed for members of log group 5 of thread 1
ORA-00312: online log 5 thread 1: '/u01/redo_groups/logSLVMRAC15.ora'
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3
#######################################################################################


I have tried deleting this redogroups but am not able to deleted those . I am getting this error.

SQL> startup mount
ORACLE instance started.

Total System Global Area 608174080 bytes
Fixed Size 2058048 bytes
Variable Size 255854784 bytes
Database Buffers 343932928 bytes
Redo Buffers 6328320 bytes
Database mounted.
SQL>
SQL> select * from v$logfile;

GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---
2 ONLINE
/dev/slvm_rac/rredo1_2
NO

1 ONLINE
/dev/slvm_rac/rredo1_1
NO

GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---

3 ONLINE
/dev/slvm_rac/rredo2_1
NO

4 STALE ONLINE
/dev/slvm_rac/rredo2_2

GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---
NO

5 ONLINE
/u01/redo_groups/logSLVMRAC15.ora
NO

6 ONLINE

GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---
/u01/redo_groups/logSLVMRAC26.ora
NO


6 rows selected.
SQL> alter database drop logfile group 6
2 ;
alter database drop logfile group 6
*
ERROR at line 1:
ORA-01623: log 6 is current log for instance slvmrac2 (thread 2) - cannot drop
ORA-00312: online log 6 thread 2: '/u01/redo_groups/logSLVMRAC26.ora'

Any help to come out of this issue or how to delete the redo group which is current online log for the instance.