Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Greater London

    Unanswered: Archive log housekeeping


    Is there any way of calculating how many archived logs can be saved for the database while the rest deleted to make sure that a full recovery can occur?

    For example is a days worth of archive logs enough?



  2. #2
    Join Date
    Apr 2003
    Greenville, SC (USA)
    Your data is only as good as your last GOOD backup...
    If you just finish an OFFLINE backup, and it is GOOD (ie, I just put it to tape, but the drive ate the tape ...) then the archives are of no value. If you are doing ONLINE backups, then you need the archives to recover.
    At my clients sites, I have the luxury of bringing the databases down once a week. I remain all archives to .OLD once a week. Next week, the .OLD's will be removed and the .ARC renamed to .OLD ...


  3. #3
    Join Date
    Jul 2003
    Through RMAN it is very easy. RMAN deletes any obsolete archive logs.

    Make a full backup
    Verify backup.
    issue delete obsolete command

    all done.

    If you want to know the benefits of RMAN vs. manual then please search for the thread on that. We already had a discussion which listed the positives and negatives of each.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts