| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Question of degrees in Oracle DB recovery
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: http://www.orafaq.com
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue Jun 29 2004 - 12:22:21 CDT
 |
 |