Especially sites headed by attractive blondes! The trouble is when logging a tar for a recovery is Oracle often say back EVERYTHING UP before you attempt recovery- Of course this is often impossible in the time scales given to us to recover. Anybody ever lied to Oracle and said YUP everything is backed up? 2009/2/8 Howard Latham <howard.latham@xxxxxxxxx> > Yes DON'T BELIEVE ANYTHING ON THE INTERNET - Especially this! > > 2009/2/8 Vishal Gupta <vishal@xxxxxxxxxxxxxxx> > > Nice one. >> >> >> >> Vishal >> >> >> >> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: >> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Niall Litchfield >> *Sent:* 08 February 2009 13:30 >> *To:* howard.latham@xxxxxxxxx >> *Cc:* oracledbaquestions@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx >> *Subject:* Re: oracle recovery scenarios >> >> >> >> of course in a real recovery situation maybe deciding that every website >> is potentially dangerous wouldn't be such a bad thing. I can see the >> conversation now >> >> >> >> DBA: Well we had a recovery to do and so I followed the procedure on >> http://www.oraclewisdom.com/recovery >> >> CEO: And now we've irretrievably lost the data >> >> DBA: It would appear so unfortunately, the walkthrough was missing a vital >> step >> >> CEO: And remind me again what we pay you for, what was it you pay raise >> application said again >> >> DBA: er, er, >> >> CEO: 'exceptional technical skills and first class judgement' >> >> DBA: er, er >> >> CEO And you ran something you found on the internet? >> >> >> >> >> >> :( >> >> >> >> Niall >> >> On Sun, Feb 8, 2009 at 1:00 PM, Howard Latham <howard.latham@xxxxxxxxx> >> wrote: >> >> The other problem about such a manual is that knowledge grows and new >> methods are developed so I think logging a tar and googling (or Yahooing if >> google deice every website is dangerous again)) are essential in a recovery >> situation. >> >> 2009/2/8 Howard Latham <howard.latham@xxxxxxxxx> >> >> >> >> >> I've been asked to write a 'recovery manual' >> >> So if on holiday our developers can recover the database. >> >> If I could I would publish it! >> >> Anyway you can add corruption sub heading - with corrupt dbf , redo , temp >> as subs of that. >> >> My books growing isnt it! >> >> 2009/2/7 Dba DBA <oracledbaquestions@xxxxxxxxx> >> >> >> >> I don't do alot of recoveries, so when I need to do something, I >> always end up googling it. So I want to write myself some notes for >> some of the basic scenarios. Here is my list so far. >> I keep notes of activities I don't use very often. So I don't have to >> look them up again. >> >> all of these assume I can use RMAN >> >> 1. full recovery(with and without archivelog mode) >> 2. point in time recovery >> 3. flashback database >> 4. lost a redo log(both online and offline, with multiple redo log >> groups or without) >> 5. lost a datafile >> 6. restore control file >> 7. restore spfile >> 8. someone drops a table, so flash back table >> -- >> //www.freelists.org/webpage/oracle-l >> >> >> >> >> -- >> Howard A. Latham >> >> >> >> >> -- >> Howard A. Latham >> >> >> >> >> -- >> Niall Litchfield >> Oracle DBA >> http://www.orawin.info >> > > > > -- > Howard A. Latham > > > -- Howard A. Latham