Re: RMAN Validate command

  • From: "Syed Jaffar Hussain" <sjaffarhussain@xxxxxxxxx>
  • To: DIANNA.GIBBS@xxxxxxxxxxxxx
  • Date: Thu, 15 Feb 2007 09:40:32 +0300

It is always better to validate the backupss before restoring.
Why by backupset by backupset, dont' you have complete database backup?

If you are on 10g, you may also see restore PREVIEW to know which files are
actually required for restore and recovery.



On 2/15/07, DIANNA GIBBS <DIANNA.GIBBS@xxxxxxxxxxxxx> wrote:

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

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





--
Best Regards,
Syed Jaffar Hussain
Oracle ACE
8i,9i & 10g OCP DBA

http://jaffardba.blogspot.com/
http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
----------------------------------------------------------------------------------
"Winners don't do different things. They do things differently."

Other related posts: