Resizing Redo Logs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Resizing Redo Logs

  1. #1
    Join Date
    Sep 2000
    Posts
    362
    Hi,
    Is there a command to resize redo logs or I need to create news ones with a specified size and drop the older ones.

    Are there any precautions I need to take.

    Thanks
    Anurag
    Appreciation is a wonderful thing;
    It makes what is excellent in others belong to us as well.


  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you have to create then drop, if you want to be safe shutdown the database then mount it and proceed your create & drop process

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You must recreate your logs with the larger size. When dropping your old logs, check the status column of v$log to make sure the log you are trying to drop is not "CURRENT" or "ACTIVE".

    select l.group#, lf.member, l.bytes/1024/1024 mb, l.status
    from v$logfile lf, v$log l
    where l.group# = lf.group#
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Mar 2001
    Posts
    314
    "You must recreate your logs with the larger size. "

    Must I, Jeff ?

    -amar

  5. #5
    Join Date
    Feb 2001
    Posts
    203
    Hi Amar,
    I did't understand why you are laughing. If it is valid then we want to know.

    Hi Anuragmin,
    Previously if you have 3 redolog groups then

    1) Create a new redo log group that has a file size of M
    (repeat this step for the 3 groups)

    2) Force a couple of log switches so that the current redo log is one of the new ones.

    3) Drop the old 3 redo log groups

    Fisrst Step
    -------------------------------
    ALTER DATABASE TESTDB
    ADD LOGFILE
    GROUP 4 (
    '/hfs/oracle/disk01/oradata/TESTDB/redo401TESTDB.log',
    '/hfs/oracle/disk03/oradata/TESTDB/redo402TESTDB.log'
    ) SIZE 2M,
    GROUP 5 (
    '/hfs/oracle/disk02/oradata/TESTDB/redo501TESTDB.log',
    '/hfs/oracle/disk01/oradata/TESTDB/redo502TESTDB.log'
    ) SIZE 2M,
    GROUP 6 (
    '/hfs/oracle/disk03/oradata/TESTDB/redo601TESTDB.log',
    '/hfs/oracle/disk02/oradata/TESTDB/redo602TESTDB.log'
    ) SIZE 2M;

    Second Step
    ---------------------------------------
    ALTER SYSTEM SWITCH LOGFILE;

    Now the group 4 is current and all other 5 groups are not active.

    Third Step
    ---------------------------------
    alter database TESTDB
    drop logfile group 1;

    alter database TESTDB
    drop logfile group 2;

    alter database TESTDB
    drop logfile group 3;

    I think these is one of the good way to change logfile size. Good Luck.
    sree

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