-
Hi friends,
I just wanted to clarify if oracle has intorduced any command to change the size of redo log file as it can be done for datafiles.
I belive to change the size of redolog files we need to drop it and re-create it with different size.
If there are other menthods please let me know.
regards
anandkl
anandkl
-
Hi,
you're lucky, I messed around that just yesterday ;-).
I think the only and proper way is creating new files and dropping the old ones.
I did it on two running production databases without any problem.
Let me know if you need some further info.
Ales
-
Works just fine. Drop the logfile group, remove redofiles from OS and then recreate the group, use "alter system switch logfile" if group are marked current to be able to drop it. Most problems with this comes when your not noticing the names correctly and removes members of another group from OS . It can happen...
-
there in no method to change the size of the redolog file , u just have to drop and recreate them with new size
-
Thanks everybody...
cheese
anandkl
anandkl
-
Ales
Will u pls. give step by step what u did yesterday?
I will be thankful to you..
Thanks
Nwcomer
Student
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
|