Resizing Online redolog file
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Resizing Online redolog file

  1. #1
    Join Date
    Jun 2002
    Posts
    64
    Hi,

    Trying to resize online redologfile as below.

    ALTER DATABASE DATAFILE '/u01/oracle/data/redo/redo1.log' resize 5m;

    The path given and the name of the file is correct. But it throws the error

    ORA-03296: cannot resize datafile - file
    /nbd07/oracle/product/8.1.5/oradata/oratest/redolog1.log not found


    Hope I can resize online redolog file like any other datafile. There is no problem when I resize a DATA datafile.

    Anybody came across this kind of problem?


    Cheers

  2. #2
    Join Date
    Jan 2002
    Posts
    26
    Hi,
    you have to drop logfile groups a recreate them new size.

  3. #3
    Join Date
    Jun 2002
    Posts
    64
    Hi,

    I know this.

    My question is, is it possible to rersize online redo log file.


    Cheers

  4. #4
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    No.
    You have to create new redologs with newsize and drop the old one.
    Nagesh

  5. #5
    Join Date
    Jun 2002
    Posts
    64
    Hi,

    Good one!

    So, I think the RESIZE option is only applicable for datafiles other than online log files.

    Cheers


  6. #6
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hello,
    LoGFiles are not organized as the other datafiles.
    They are not written with blocks but like a byte-stream.
    Another different is that orcale supports morroring for logfiles,
    probably due to this feature it is not possible to increase the size?

    They way to increase the size is as written.
    * add new bigger log-groups
    * switch logfile to the new groups
    * delete/drop the old groups

    Orca


  7. #7
    Join Date
    Jun 2002
    Posts
    64
    Hi,

    Of course Oracle provides mirroring! But could that be the reason not to allow RESIZE? No idea!

    Could u elaborate on byte-stream writting.

    Any idea why Oracle is writting redologs in byte stream instead of Blocks.

    Cheers









  8. #8
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hy;

    A DATAFILE IS NOT A LOGFILE;

    Oracle handles both different.

    ALTER DATABASE ...DATAFILE ...
    changes only DATAFILES but not LOGFILES and NOT CONTROLFILES AND NOT SPFILES;

    I hope you can live with that ;-)

    Orca

  9. #9
    Join Date
    Jun 2002
    Posts
    64
    Hi,

    What you said is the basic thing and not the answer to my question!

    Does anybody else got into this?

    Cheers

  10. #10
    Join Date
    Nov 2001
    Location
    Planet Earth
    Posts
    116
    You cannot resize online redolog file.. i repeat
    you CANNOT resize online redolog file..
    but if you still want to.. there is a trick to do that...
    1. create new larger redolog file <- make 2 or 3 files
    2. switch current onle redo log file to the u havae created one
    3. drop the 'old' online redo log file

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