Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2007
    Posts
    5

    Unanswered: Archive log vs hot backup

    Dear sir thanks for your quick reply. I have another question.the archive log files,should i keep them forever?i mean can i purged them on a date basis according the hot backup im continously doing?Suppose my hot backup is as at 19 nov 07.can i purge the archive logs dated before19 nov 07 so as to solve the problem of disk space???

    According to what i have read, i see it as a solution.can i rely on this?I work in the datawarehouse dept of a telecommunication company. So i dont want to take much risks.

    Thanks very much for your help.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Suppose my hot backup is as at 19 nov 07.can i purge the archive logs dated before19 nov 07 so as to solve the problem of disk space???
    Assuming the you can successfully restore the database as of the start of the hot backup, then you do no require archived redo log file prior to that time.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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