Hi How to increase Redo Log file Size.
Right now i have three group with three redolog with 1 mb file i want to increase these file size.
The following is the procedure to increase the size of Redo Log File.
1. alter database
add logfile group x
('c:\log\log0101.log','d:\log\log0102.log') size xM;
2. Switch to make it current
alter database switch logfile;
3. Drop the exisiting redo log files
alter database drop logfile group x;
4. Recreate redolog files with desired size in the place of
deleted log files.
In case of any help please be free to ask me at email@example.com
ROhit Nirkhe,Oracle DBA,OCP 8i
Click Here to Expand Forum to Full Width