Resizing of Redo log files
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Resizing of Redo log files

  1. #1
    Join Date
    Jun 2003
    Location
    India
    Posts
    118

    Resizing of Redo log files

    Is there any method of Resizing of Redo log files other than first droping them and then adding new with new size.
    vishal sood
    OCP 8

  2. #2
    Join Date
    Sep 2000
    Location
    Calcutta / Ahmedabad, India
    Posts
    137
    Hi,

    Don't think there's any other method, other than adding either new groups or new memeber with the new size to the existing groups , then sitching the log files and knocking off the not active ones whose sizes u wish to increase.
    Suvashish

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    Originally posted by dsuva
    Hi,

    Don't think there's any other method, other than adding either new groups or new memeber with the new size to the existing groups , then sitching the log files and knocking off the not active ones whose sizes u wish to increase.
    Umm, no, you don't do it that way. Unequal sized members in the same group? Not good, not good at all.

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I dont think you can even do that!

  5. #5
    Join Date
    Jan 2003
    Location
    Delhi
    Posts
    63
    I think only option is u have to recreate it

  6. #6
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by mdash
    I think only option is u have to recreate it
    Recreate what ?? Database ?

    No need. Just create new redolog groups with new sized members. Do switch and drop older redolog groups.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  7. #7
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    How to resize your redo logs.

    1. Select which log file (group) you want to resize.
    2. Make sure that it has been archived and not active.
    *note if the redo log file is active simply do a log switch until it is no longer active.
    3. drop the log file (group).
    4. Go to the O.S. and drop the physical file(s)associated with the group you just dropped.
    5. Recreate the log file with the new size.


    Also, for the newbies.. DO NOT DROP THEM ALL AT THE SAME TIME DO THEM INDIVIDUALLY!
    I dare say this but..It's really easy in OEM.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  8. #8
    Join Date
    May 2002
    Posts
    2,645
    The bottom line is this:

    Where is size of the log group member controlled? In the create group statement. All members within a group are the same size. All groups do not have to use the same size among them.

    Group 1 can have member sizes of 1MB each.
    Group 2 can have member sizes of 100MB each.
    Group 3 cannot have a member with 1MB and a member with 100MB. It's one or the other, when the group is created.

    If you could have members of unequal sizes within a group, the smaller member would be the driving factor for when a log switch would occur. So the notion of adding a single larger member by itself is nonsensical.

    If you want larger (or smaller) members, create a group containing the desired size. In a practical sense, it wouldn't be just one group because why would you want to have unequally-sized groups?

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