• From: Michael Dinh <mdinh@xxxxxxxxx>
  • To: "'anthony.ballo@xxxxxxxxxxx'" <anthony.ballo@xxxxxxxxxxx>, Oracle-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 3 Apr 2012 13:57:33 -0700

Bottom Line : The RESTORE DATABASE VALIDATE doesn't confirm that the restored 
database is recoverable. You must separately run RESTORE ARCHIVELOG ... 

Michael Dinh : Disparity Breaks Automation (DBA)

Confidence comes not from always being right but from not fearing to be wrong - 
Peter T Mcintyre
Great minds discuss ideas; average minds discuss events; small minds discuss 
people - Eleanor Roosevelt 
When any rule or formula becomes a substitute for thought rather than an aid to 
thinking, it is dangerous and should be discarded -Thomas William Phelps

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Anthony Ballo
Sent: Tuesday, April 03, 2012 12:23 PM
To: Oracle-L

Looking for general advice here and to clear up any misconceptions I have.
I am looking at RMAN scripts currently running in both Prod/Test
environments and I have a question about RESTORE DATABASE VALIDATE
statements being used in our daily FULL backup scripts. For example (see
#8) below:

RMAN> connect target *
2> run{
3> allocate channel d1 type disk;
4> sql 'ALTER SYSTEM archive log current';
5> backup as copy database format '+DG1';
6> sql 'ALTER SYSTEM archive log current';
7> release channel d1;}
8> restore database validate;
9> crosscheck copy;
10> crosscheck archivelog all;
11> delete noprompt obsolete;
12> list copy;
13> exit;

From my understanding, RESTORE DATABASE VALIDATE only validates Datafiles
for RESTORE - not Archivelogs needed for a complete RECOVER. Also from
what I recall from OU Admin Class, one would run this command prior to an
actual restore and probably not daily. Plus, to accomplish what I think
the prior DBA intended (test a RECOVER), you would also issue a "RESTORE
ARCHIVELOG ALL VALIDATE" statement immediately after.

What is the general consensus here?



Environment Info: 10.2/RAC(2-node)/ASM/No Catalog/OEL5



Other related posts: