Re: Can someone check my logic here?

Yes, a cold backup and all archived logs and the current log is all you need to recover up-to the-minute. This assumes a 'small' crash -- just some of the database data files.

But what about a full site disaster? And what happens if the disaster occurs just before the archived logs are backed up? If you saved the backups off-site, you would be able to restore the cold backup and recover through the last backed up archived log file. This means you would lose a full day.

Full site disasters are rare. So you must compare the loss of a day's work vs. the cost of more frequent trips off-site to store the backups of the archived logs. Another thought: buy a fireproof vault and keep the days worth of archived logs in there.

matthew_at_mattshouse.com wrote:

> I'm setting up a backup procedure, and I would like someone to check for flaws
> in my plan. Also, I have a couple of questions at the end.
>
> Every Sunday we stop the database and initiate a cold backup. Monday -
> Saturday we only backup the archived logs. Technically, should disaster
> strike, we should be able to restore the cold backup and import the archived
> logs. This will give us up-to-the-minute recovery.
>
> Here is the output that I receive when I do an 'archive log list':
>
> SVRMGR> archive log list;
> Database log mode Archive Mode
> Automatic archival Enabled
> Archive destination e:\backup
> Oldest online log sequence 12801
> Next log sequence to archive 12802
> Current log sequence 12802
>
> Sure enough, there are archive logs in the e:\backup directory. Do I have
> everything that I need? Can I just send the archived logs to tape, or do I
> have to tell the database that I'm backing them up? After I send them to
> tape, can I delete them?
>
> Matthew
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Nov 17 1998 - 13:10:20 CST