RE: RMAN physical backup verification - incrementals
- From: Josh Collier <Josh.Collier@xxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 23 Mar 2004 11:06:27 -0800
try "set until time"
generally speaking, the validate procedure does test the incrementals,
assuming they are required to bring your database to a current state. It
should start with the last level 0 and then go thru all the subsequent 0+n
incrementals to validate your restore.
-----Original Message-----
From: Rich Holland [mailto:holland@xxxxxxxxxxxxxxxx]
Sent: Tuesday, March 23, 2004 10:08 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RMAN physical backup verification - incrementals
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@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
-----------------------------------------------------------------
----------------------------------------------------------------
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:
