How to create 2nd set of online redo logs for node 2 RAC
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

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

  1. #1
    Join Date
    Jan 2001
    Location
    St. Louis. MO
    Posts
    150

    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
    Location
    Atlanta
    Posts
    1,187
    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