Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RMAN Validate command

Re: RMAN Validate command

From: Syed Jaffar Hussain <sjaffarhussain_at_gmail.com>
Date: Thu, 15 Feb 2007 09:40:32 +0300
Message-ID: <97b7fd2f0702142240q20eef55dg86e42bc6db95751a@mail.gmail.com>


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_at_childrens.com> 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
>
> --
> http://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."

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 15 2007 - 00:40:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US