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@xxxxxxxxxxx>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@xxxxxxxxxxx> 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@xxxxxxxxx> wrote: > > > >>Bottom Line : The RESTORE DATABASE VALIDATE doesn't confirm that the > >>restored database is recoverable. You must separately run RESTORE > >>ARCHIVELOG ... VALIDATE ! > > > > > >-- > >//www.freelists.org/webpage/oracle-l > > > > > > -- > //www.freelists.org/webpage/oracle-l > > > -- //www.freelists.org/webpage/oracle-l