RMAN physical backup verification - incrementals

From: Rich Holland <holland_at_guidancetech.com>
Date: Tue, 23 Mar 2004 13:08:18 -0500
Message-Id: <20040323180845.DDCF584@jester.pobox.com>

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

---

Received on Tue Mar 23 2004 - 12:58:23 CST