Re: RMAN physical backup verification

From: Tim Gorman <tim_at_sagelogix.com>
Date: Wed, 24 Mar 2004 06:38:16 -0700
Message-ID: <BC86DD58.12027%tim@sagelogix.com>

Rich,

It could be that, from a validation standpoint, incremental backups at level
> 0 simply do not matter -- only FULL and LEVEL=0 backups matter for
recoverability. I have a report against the RMAN repositories to do the same validation, but I also completely ignore incremental backups where level > 0, because they exist only to expedite recovery (and worrying about them only complicates the report). I don't know if Oracle uses this same reasoning for a validation operation, but they might...

While RESTORE VALIDATE is excellent, another equally valid recovery test is a DUPLICATE TARGET DATABASE operation. If you're short on space and running 9i, you can exclude all but a few small tablespaces so as not to consume too much disk space with the duplicated database. That operation should certainly utilize incremental backups.

Just my $0.02...

-Tim

on 3/23/04 11:08 AM, Rich Holland at holland_at_guidancetech.com wrote:

> We run a weekly incr level 0 and daily incr 1 backups via RMAN. I'd like to
> verify that whatever we write to tape is good; normally I'd do this by
> requesting a restore to test it.
>
> Rman has a nice 'validate' feature that I tried to take advantage of via
> something like this:
>
> connect target;
> run {
> allocate channel c1 type sbt;
> restore database validate;
> }
>
> This works, but I noticed that it always requests a restore of the last INCR 0
> backup -- even if several days since then have passed. How do others verify
> that their INCR backups > 0 are cleanly written to tape?
>
> Thanks!
> Rich
> --
> Rich Holland (913) 645-1950 SAP Technical Consultant
> print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E<FP\@:&%C:V5R\"\@\`\`");
>
>
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------

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 Wed Mar 24 2004 - 07:38:31 CST

Re: RMAN physical backup verification - incrementals