RE: RMAN Validate command

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Thu, 15 Feb 2007 08:09:49 -0500
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE08B3E@EXCNYSM0A1AJ.nysemail.nyenet>

Dianna,

I would validate the entire backup - not just a backup set. But to answer your question - no. If the validate works, then the entire database should restore properly.

Tom

---

This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of DIANNA GIBBS Sent: Wednesday, February 14, 2007 7:21 PM To: oracle-l_at_freelists.org
Subject: RMAN Validate command

We lost a disk tonight. I'm validating our latest RMAN backup. To confirm, do I need to check
any views or worry about anything else if I see no errors, per below?

Thanks in advance. Any thoughts, comments are appreciated.

RMAN> validate backupset 960395;

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=70 devtype=DISK
channel ORA_DISK_1: starting validation of datafile backupset
channel ORA_DISK_1: restored backup piece 1

piece handle=/rman/lawp803/ctrlfile_LAWP803x_20070214_1_3gia28dt_1_1 tag=TAG20070214T172829 params=NULL
channel ORA_DISK_1: validation complete

RMAN> validate backupset 960345;

using channel ORA_DISK_1
channel ORA_DISK_1: starting validation of datafile backupset

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Thu Feb 15 2007 - 07:09:49 CST