Re: RMAN: RESTORE DATABASE VALIDATE question

From: Wayne Smith <wts_at_maine.edu>
Date: Tue, 10 Apr 2012 15:15:49 -0400
Message-ID: <CAEgY-F56+BSc8GMGjYP4AuD1Tr0T+QFSV2emYwr3iah9hvMvWg_at_mail.gmail.com>

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

Received on Tue Apr 10 2012 - 14:15:49 CDT