Adding redolog groups/members
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Adding redolog groups/members

  1. #1
    Join Date
    Oct 2000
    Posts
    449
    I created a database and I don't know where I missed (DBassist) that it created 3 groups with 1 member in each..
    How can I make that to atleast 2 members in each grp?

    Do I have to create redolog 4a,4b to 6a,6b and then drop the redolog 1,2,3 or how?? Please be detailed..

    Thanks, ST

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    I am not gonmna be detailed because it is explain in detail in the DOCs on technet. All I can say is you dont need to drop, you can simply add a member to each group

    Check administration guide: managing redo logs in the DOCs

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Try

    ALTER DATABASE ADD LOGFILE MEMBER [ 'filename' [REUSE], 'filename' [REUSE]] ...
    TO { GROUP integer,}
    ]

    ALTER DATABASE ADD LOGFILE MEMBER
    '/DISK4/log1b.redo' TO GROUP 1,
    '/DISK4/log2b.redo' TO GROUP 2;


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    IF I could remember all the commands by hard

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Then why the books are for

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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