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.
Anuj
Printable View
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.
Anuj
Hi,
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 rohitsn@altavista.com
Regards,
ROhit Nirkhe,Oracle DBA,OCP 8i
rohitsn@altavista.com