unable to disable a thread htat belongs to a long gone RAC node
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