Re: Question of degrees in Oracle DB recovery

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Tue, 29 Jun 2004 10:08:44 -0700 (PDT)
Message-ID: <20040629170844.93505.qmail@web20416.mail.yahoo.com>

Daniel Fink <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.

> 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_at_freelists.org put 'unsubscribe' in the subject line.

--
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:06:56 CDT