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

Thread: Hot Backup Questions

  1. #1
    Join Date
    Jun 2000
    Posts
    26

    Question

    1) In Oracle8 Backup and Recovery, it says to back up archived log files created during the hot backup.
    Many scripts I've seen for hot backups don't include this. Is it necessary ?
    How would I generate a script to backup just these log files ?

    2) I know that if I have a hot backup, I don't technically need the old archived log files, but that assumes the latest hot backup is valid. What are the recommendations for backing up old archived log files? This doesn't appear to be mentioned as part of normal backup procedures.

    Thanks

  2. #2
    Join Date
    Dec 1999
    Posts
    217
    If you are doing a hot backup it is necessary to back up the archive logs in case you need to do a point-in-time recovery. To generate a script to backup the archive logs is that you pass a O/S specific command to copy the archive logs to a backup directory. In my scripts I move the archive logs to a directory every hour during the day and then when my online backup runs (early morning) I copy all those logs to the backup directory. Let me know if you want me to attach the script.
    Hopefully, this helps.

    Chintz

  3. #3
    Join Date
    Mar 2001
    Posts
    144
    yes you do need to back these up.

    1) Under Unix you can search for specific log files based on time stamp and copy only those that fall within a certain period of time (ie., find //*.* -mtime 0). That's one way of doing it. You need play around with it and make some assumptions about the length of time your backup takes unless you execute the archive search after the backup finishes and you have forced a logfile switch.

    2) For us we backup the archive area each night for a month then we cycle through the process again. For us, we determined that we would not need archive logs from month to month. But thats a decision that took us some time to make given out environment and needs.

    hth

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