Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Question of degrees in Oracle DB recovery

Re: Question of degrees in Oracle DB recovery

From: Tim Gorman <>
Date: Tue, 29 Jun 2004 11:26:21 -0600
Message-ID: <>

You're correct of course...

My main points were that copying files to a "SAN" should not be regarded as a "backup" and then secondly to disassociate backups of archivelogs from backups of datafiles, where archived redo logfiles are far more important than datafiles.

I just wanted to answer his immediate question before digressing onto other matters...

on 6/29/04 10:52 AM, Daniel Fink at Daniel.Fink_at_Sun.COM wrote:

> <humor>
> O Great And Mighty Tim, I must humbly disagree in a groveling manner.
> </humor>
> Nothing can be considered recoverable until it can be *read* from tape. At a
> recent IOUG, we were discussing B&R and one of the
> folks told a story about a tape drive where the head was moving a fraction of
> a millimeter (or so) every time a tape was inserted.
> As the writing worked like a charm (no errors) they did not worry about it.
> When it came time to read the tape, guess what...they
> couldn't. Nice backups, too bad they could not be used for recovery.
> From personal experience, one client I worked with was writing corrupted
> archived redo logs to tape every night. Of course, the
> logs could be restored from tape...but they were useless.
> This is not to say that you have to test every tape by performing a recovery.
> But it is a good idea to make sure at least some of
> the tape can be read and use old tapes to perform recoveries when possible.
> One good opportunity is when development/test/qa wants a
> copy of production to use. Instead of exp/imp, take a little time and rebuild
> the database through recovery. Might take a little
> extra time (might not, depending on the amount of data to be retrieved), but
> you will have some confidence in the backup integrity.
> Regards,
> Daniel Fink
> Tim Gorman wrote:

>> Stephen,
>> One good rule of thumb is that nothing can be considered recoverable until
>> it is copied to tape, at least once.

Please see the official ORACLE-L FAQ:

To unsubscribe send email to: put 'unsubscribe' in the subject line.
Archives are at
FAQ is at
Received on Tue Jun 29 2004 - 12:22:21 CDT

Original text of this message