RE: RMAN: RESTORE DATABASE VALIDATE question

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

http://hemantoracledba.blogspot.com/2010/03/misinterpreting-restore-database.html


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
Subject: RMAN: RESTORE DATABASE VALIDATE question

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?



Thanks,


Anthony

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

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


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

Other related posts: