| How to increase size of Redo log files? [message #62727] |
Wed, 11 August 2004 00:01  |
dr alex
Messages: 18
Registered: June 2004
|
Junior Member |
|
|
I want to increase size of redo log files from 1M to 5M (This is for launching the database in Archive mode and reducing the number of archive log files).
In our system(where daily transaction is high) there are 4 redo logfiles, should I increase the number of logfiles?
I hope some one has idea.
Thanks in advance.
Anup
(Nepal)
|
|
|
|
| Re: How to increase size of Redo log files? [message #62730 is a reply to message #62727] |
Wed, 11 August 2004 01:28  |
Vivek Vijai
Messages: 67
Registered: April 2004
|
Member |
|
|
You cannot resize the Redo log file. The only soln is create a new logfile (or group) and drop the old logfile (or group) as
If you want to add a new group
1)Alter database add logfile group n ('<member name>')
size 5m;
2) View the v$log dd view
3)Alter system switch logfile;
- To forcely switch the log file and when its status becomes INACTIVE drop the log group
as
4) Alter database drop logfile;
5) Again query the v$log
This is for 9i, i dont know if can change the size in the later versions.
Vivek
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
