Managing archive log size
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Managing archive log size

Hybrid View

  1. #1
    Join Date
    Sep 2009
    Posts
    2

    Managing archive log size

    Configuration: hp-ux OS, oracle 10g, SAP 6.4,
    size of archive log files is too high 18GB for a day. Logs are created 2 times in a day in interval of 12 hrs, I need to decrease the maximum size for archive log files?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    archive logs are the same size of your redo logs

    if you really have 9gb redo log files, then you have bigger problems

  3. #3
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    if i understand correct total redo generating in a day is 18GB. you can reduce the redo upto some extend by nologging the tables at the risk of loosing data in case of any mishap. It is not recommended in production space.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  4. #4
    Join Date
    Sep 2009
    Posts
    2

    procedure for reducing archive log size.

    what is the step by step procedure for reducing MAX size of redo logs. Also how can I analyze the problem behind this huge log files. We have 200 SAP users

  5. #5
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    what is the step by step procedure for reducing MAX size of redo logs.
    what does it mean? you want to reduce the size of redo log files? reducing redo log size will not reduce the amount of redo generating in a day.

    you need to analyze the programing logic of the sql to identify why they are generating more redo. also, if you are using sql*loader use direct path load to stop generating redo.

    google it for more options depends on what is running in your machine.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by ladiesman View Post
    ... how can I analyze the problem behind this huge log files.
    Please read again Dave's post... let me quote: "archive logs are the same size of your redo logs".
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  7. #7
    Join Date
    Jan 2001
    Posts
    2,828
    Can the op please confirm you have 9gb redo log files really ?

    even if you have 9gb redo log files and say you have set parameter

    ALTER SYSTEM SET ARCHIVE_LAG_TARGET = 600 SCOPE=BOTH;
    This sets the maximum lag to 10 mins.




    regards
    Hrishy
    Last edited by hrishy; 09-30-2009 at 04:18 AM.

  8. #8
    Join Date
    Oct 2006
    Posts
    175
    Quote Originally Posted by ladiesman View Post
    Configuration: hp-ux OS, oracle 10g, SAP 6.4,
    size of archive log files is too high 18GB for a day. Logs are created 2 times in a day in interval of 12 hrs, I need to decrease the maximum size for archive log files?
    Best thing for you to do would be to analyze the redo generation trend of your database and then set redo log size and number of log groups accordingly.

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