Re: Question of degrees in Oracle DB recovery
- From: Paul Drake <discgolfdba@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 29 Jun 2004 10:08:44 -0700 (PDT)
--- Daniel Fink <Daniel.Fink@xxxxxxx> 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.
> 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.
Dan,
In today's Sarb-Ox world, we now have a client that
performs such a test quarterly:
an old backup set is restored from tape onto a standby
server, is recovered to a point in time, opened, and
several reports are run against it and compared
against results taken for that time period (e.g. aged
1 month).
This drill includes obtaining the tapes from the
offsite storage vendor.
So - even if the tapes are good, the archived logs are
good - it still pays to make sure that you can obtain
the tapes from your offsite storage vendor.
The trick was to document and script it well enough as
to be able to offload it. They also *feel* better
knowing that they can perform such an exercise even
with nyc being blown off the map.
Paul
----------------------------------------------------------------
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:
