RE: RMAN: RESTORE DATABASE VALIDATE question
Date: Tue, 3 Apr 2012 13:57:33 -0700
Message-ID: <D29F9902E534D5478F2E83FD6A44B30649BF83CC88_at_mail02.mba.xifin.com>
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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
Received on Tue Apr 03 2012 - 15:57:33 CDT