Re: RMAN: RESTORE DATABASE VALIDATE question

From: Marko Sutic <marko.sutic_at_gmail.com>
Date: Tue, 10 Apr 2012 22:24:48 +0200
Message-ID: <CAMD6WPe9HsL5Wu+7o7-OiVSUx9K_+uPw99N=11eFPM4eAdtnYw_at_mail.gmail.com>

Hello Wayne,
I've checked in docs - with "restore database validate check logical" RMAN checks for physical and logical corruption. I thought that "restore database validate check logical" checks only logical block corruption. To check physical corruption also I added "restore database validate".

I suppose that "restore database validate check logical" should be enough for validation.

Regards,
Marko

On Tue, Apr 10, 2012 at 9:15 PM, Wayne Smith <wts_at_maine.edu> wrote:

> Marko,
> Why the "restore database validate check logical" *and* a what appears to
> be a repeat "restore database validate"?
>
> Cheers, Wayne
> Wayne T Smith - wts_at_maine.edu - UMS-ITS-S&O -
>
> - "The more directives you issue to solve a problem, the worse it gets"
> -- Robertson's Rules of Bureaucracy
>
> On Wed, Apr 4, 2012 at 5:32 AM, Marko Sutic <marko.sutic_at_gmail.com> wrote,
> in part:
>
> > Hi Anthony,
> > I'm also running weekly backup validation but approximately every month
> I
> > like to perform actual restore/recover.
> >
> > My script for validation:
> >
> > run
> > {
> > allocate channel c1 device type disk;
> > restore database validate check logical;
> > restore database validate;
> > restore archivelog from time 'sysdate-xxx' validate;
> > restore validate controlfile to '/tmp/control01.ctl';
> > release channel c1;
> > }
> >
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Tue Apr 10 2012 - 15:24:48 CDT