My fear is when there is a need to get a backup copy, it might take at least 24 hrs for us to retrieve the copy. Are there any white papers or guidelines that you can point me to?
How often should you keep your backups around? Well, you definitely need your latest backup and all archived redo logs generated since that backup. Many DBAs like to have three generations on hand. That would be your current backup, the previous backup, and the backup before that. This way, if there is a problem with the current backup, you can go back to the previous backup, etc. The number of generations of your backups is dictated by your site's policies. Typically, the number '3' is used here for many people.
As for offsite backups, I like to make sure that I have copies of my backup both offsite and onsite. In the event of a failure, I would only use my onsite backups. It simply takes too long to go to your offsite location, locate the backup tapes, bring them back to your site, and then get the backups off those tapes. It is much better if the onsite backups are available. In my opinion, the offsite backups would only be used if you lose your facility and have to relocate to another facility. In that scenario, your onsite backups are most likely unavailable as well so you are left with your offsite backups.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading