-
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
-
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
-
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.
-
I dont think you can even do that!
-
I think only option is u have to recreate it
-
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."
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|