1 Reply Latest reply: Dec 6, 2008 6:17 AM by 153119 RSS

    ORA-01618: redo thread 2 is not enabled - cannot mount

    Rabi786
      Hi Guru

      I am using two node RAC instance , and drop redo log . after that i startup a node which was down then i found the following error


      ORA-01618: redo thread 2 is not enabled - cannot mount

      Pls advise me
        • 1. Re: ORA-01618: redo thread 2 is not enabled - cannot mount
          153119
          Hi,

          At a minimum you
          - need to look up the error message in the online error messages manual, prior to posting
          - you need to post your platform and your 4 digit database version

          In a RAC instance each instance needs to have dedicated online redolog groups, called a thread.
          You need to make sure (from v$log) your instances have separate redologs.
          Secondly (the error message is already pointing to that), both instances need to have a thread enabled

          --> alter database enable public thread <n>; -- usually 2

          Hth

          --
          Sybrand Bakker
          Senior Oracle DBA