Database Software

Hi,

Oracle 10gR2 ( 10.2.0.4), Rac Environment, Instance name orcl1, orcl2

Recently the orcl2 got crashed so we rebuilt the machine and orcl2 node and added the node again back to cluster

There was a failed attempt in DBCA (Addition instance part) where the redolog05 & 06 got created in ASM.

We created instance orcl02 as thread 3 instead of thread 2 and successfully added the node to cluster.

The redolog of thread 2 (redo05, redo06) created due to the failed DBCA add instance activity in unable to delete from the v$log entries.

GROUP# THREAD# MEMBER ARCHIVED STATUS Size (MB)
------ ------- ----------------------------------------------------------------- ----- ---------- ---------- ---------
1 1 +ORCLDG3/orcl/redo01.log YES ACTIVE 50
2 1 +ORCLDG3/orcl/redo02.log NO CURRENT 50
5 2 +ORCLDG3/orcl/redo05.log YES UNUSED 50
6 2 +ORCLDG3/orcl/redo06.log NO CURRENT 50
8 3 +ORCLDG3/orcl/redo08.log NO CURRENT 50
9 3 +ORCLDG3/orcl/redo09.log YES INACTIVE 50

When i tried to disable the thread 2 i am getting the below errors, as the redo log 05, 06 are not physically present in the ASM

SQL> alter database disable thread 2;
alter database disable thread 2
*
ERROR at line 1:
ORA-00313: open failed for members of log group 6 of thread 2
ORA-00312: online log 6 thread 2: '+ORCLDG3/orcl/redo06.log'
ORA-17503: ksfdopn:2 Failed to open file +ORCLDG3/orcl/redo06.log
ORA-15173: entry 'redo06.log' does not exist in directory 'orcl'

Please help in removing the Thread 2 redo log files as this warning are getting written in the alert log every second and fills the mount point.

Regards