13 Replies Latest reply on May 1, 2013 7:10 PM by Orna Weisman

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

    Orna Weisman
      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