Archive log removing statergy
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Archive log removing statergy

  1. #1
    Join Date
    May 2001
    Location
    Pune
    Posts
    32

    Question Archive log removing statergy

    Hi Guys,

    We have database of 200GB.
    We are taking hotbackup using scipts on tape.
    Hotbackup starts every night and take back up of all tablespaces and archive logs.
    there are appox. 6-8 archive logs of 100 mb each.

    I would like to know how many days archive we should keep in our archive_log destination. Currently we are keeping last 3 days.
    Also can someone highlight on how offen we should do log swith? Currently it is daily 1-2 times in one of the database and few other database it is 1 hour.

    My concer in about a databse where i have log switch once or twice a day which has 100mb redo log.

    Your opinion will be highly appericiated.

    Thanks and regards,
    RBP

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You can get rid of archived redo logs as soon as they are backed up. For most of my critical databases, I keep no more than 12 hours on disk.

    Your logswitch frequency depends on the needs of the business. Oracle CW (to which I don't subscribe) is that the logs should switch no more frequently than every 30 minutes during periods of heavy load.
    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."

  3. #3
    Join Date
    May 2001
    Location
    Pune
    Posts
    32
    Hi Jeff,

    Thanks for your reply. It is useful to me.

    RBP

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    If space is not an issue, then you can keep 3 - 4 days of archive logs in the archive dir. This will help you in case of recovery is needed.

    There is no specific guidelines for Log switch.
    Instead , you should have a policy for MTTR. And set appropriate value for the parameter fast_start_mttr_target.

    Tamil

  5. #5
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    I'd agree with Tamil on this. I'd feel nervous with only one copy on tape - ever started a restore only to find the tape was bad? :(

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