This discussion is archived
13 Replies Latest reply: May 1, 2013 12:10 PM by OrnaWeisman RSS

unable to disable a thread htat belongs to a long gone RAC node

OrnaWeisman Newbie
Currently Being Moderated
I have a two RAC instance , that one upon a time used to have 3 nodes.
thread#3 is marked as 'CLOSED' on v$thread.

there are two log files associated with that thread.
I want to disable that thread and get rid of these two log files ( this is needed as preparation to a switchover yo my dataguard )

However , the logfiles are long gone , so when I try to disable the thread I get :

SQL> ALTER DATABASE disable THREAD 3;
ALTER DATABASE disable THREAD 3
*
ERROR at line 1:
ORA-00313: open failed for members of log group 30 of thread 3
ORA-00312: online log 30 thread 3: '/q01/oradata/timst/redo30a.log'
ORA-17503: ksfdopn:4 Failed to open file /q01/oradata/timst/redo30a.log
ORA-17500: ODM err:File does not exist


How can I get rid of that thread and its redo log files ?

version is 10.2.0.4 on SPARC Solaris

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points