Re: Question of degrees in Oracle DB recovery
- From: Daniel Fink <Daniel.Fink@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 29 Jun 2004 10:52:31 -0600
<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
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
