| Multiplexing and Resizing log files [message #58570] |
Thu, 18 September 2003 00:45  |
M. Khaled
Messages: 67
Registered: April 2002
|
Member |
|
|
I HAVE THREE REDO LOG FILES.I WANT TO MULTIPLEX THESE THREE.BEFORE DOING THIS EXISTING LOG FILES NEED TO BE DECREASED.PRESENTLY THIS IS 100M.I WILL MAKE IT 20M.
PLEASE HELP....
|
|
|
|
| Re: Multiplexing and Resizing log files [message #58576 is a reply to message #58570] |
Thu, 18 September 2003 08:08  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
There is no command to resize an online redolog file. You will have to drop the Logfile groups and recreate them with the desired size. Note that you must have atleast 2 redolog groups anytime and so you will have to add additional redolog file groups with the correct size and then drop the inactive,archived redolog file groups one by one.
Something like
Alter database add logfile group 4 'file spec' size 20m;
Alter database add logfile group 5 'file spec' size 20m;
..
Alter database drop logfile group 1;
etc
When you do encounter an ACTIVE Logfile,which cannot be dropped, you may have to
alter system switch logfile;
and/or
alter sytem archivelog all;
etc to make sure the logfiles you are dropping are INACTIVE and Archived.
Take help from 'Select * from v$log';
Issue that query everytime you add/drop logfiles to make sure everything is in order.
Hope this helps
Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
