-
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
Anuj
India
-
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
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
|