How to increase Redolog file size
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to increase Redolog file size

  1. #1
    Join Date
    Aug 2001
    Posts
    56
    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

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    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
  •  



Click Here to Expand Forum to Full Width