RE: RMAN physical backup verification - incrementals

From: Josh Collier <Josh.Collier_at_Banfield.net>
Date: Tue, 23 Mar 2004 11:06:27 -0800
Message-ID: <219647973E94D211A8F20008C709725211D6B6AD@mercury.hq.vetsmart.com>

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_at_guidancetech.com] Sent: Tuesday, March 23, 2004 10:08 AM
To: oracle-l_at_freelists.org
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_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 Tue Mar 23 2004 - 15:37:26 CST