Re: RMAN: RESTORE DATABASE VALIDATE question

From: Marko Sutic <marko.sutic_at_gmail.com>
Date: Wed, 4 Apr 2012 11:32:14 +0200
Message-ID: <CAMD6WPcdPn5M18Z2C3dW1qDj9xXgZxcJrSQtd=0P-kcn=3FAFw_at_mail.gmail.com>

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;
}

Regards,
Marko

On Tue, Apr 3, 2012 at 11:25 PM, Anthony Ballo <anthony.ballo_at_onecall.com>wrote:

> Also, would 'BACKUP VALIDATE DATABASE ARCHIVELOG ALL' be suggested instead
> prior to the actual backup or is this excess?
>
>
>
>
>
> On 4/3/12 2:07 PM, "Anthony Ballo" <anthony.ballo_at_onecall.com> wrote:
>
> >Thanks Michael - that's also what I had mentioned. My question would be do
> >you perform each of these statements as part of your daily RMAN backup
> >script(s) ?
> >
> >Anthony
> >
> >
> >
> >
> >
> >
> >
> >On 4/3/12 1:57 PM, "Michael Dinh" <mdinh_at_XIFIN.Com> wrote:
> >
> >>Bottom Line : The RESTORE DATABASE VALIDATE doesn't confirm that the
> >>restored database is recoverable. You must separately run RESTORE
> >>ARCHIVELOG ... VALIDATE !
> >
> >
> >--
> >http://www.freelists.org/webpage/oracle-l
> >
> >
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Wed Apr 04 2012 - 04:32:14 CDT