DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2001
    St. Louis. MO

    Question How to create 2nd set of online redo logs for node 2 RAC

    I am trying to setup RAC on a two node cluster. I was able to mount and start the database on both nodes alternately. I am about to try and bring up the two instances on the two node RAC, however I think a am missing something.

    Can anybody tell me how to create the 2nd set of on-line redo logs (thread 2) for my second node rac.

  2. #2
    Join Date
    Aug 2002
    it would look something like this

    alter database add logfile thread 2
    group 3 ('d:\oracle\oradata\redoXXX.dbf') size 254m reuse, group 4 ('d:\oracle\oradata\redoXXX.dbf') size 254m reuse;

    alter database enable public thread 2;

    ...notice that thread 2 is the key here enabling the logs for the 2nd instance
    I'm stmontgo and I approve of this message

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.