DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: changing archive log size..

  1. #1
    Join Date
    Nov 2002
    Posts
    115

    changing archive log size..

    hi

    How to change archive log size ?

    Our Database archive log size is 6mb. Now, I would like to change
    it to 2mb. How can i do that ? What is the command ?


    Thanx in adv
    Prasad

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I can see you dont have a single clue, archived logs are redo logs, to change archove log size you have to change redo log size. Makes sense huh?

    RTFM

  3. #3
    Join Date
    May 2003
    Location
    hyderabad, India
    Posts
    10
    Hi

    Pando is right. archived log files are only backed up copies of log files. in order to increase the size of the logfile, add a new log file with a larger size and switch the log file to this current log file. perform the same operation for the other logfiles also. then drop the old logfiles.

    be careful while doing this operation.

    Partha

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