RE: RMAN: RESTORE DATABASE VALIDATE question
- 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 ...
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
