Re: oracle recovery scenarios

  • From: Howard Latham <howard.latham@xxxxxxxxx>
  • To: Vishal Gupta <vishal@xxxxxxxxxxxxxxx>
  • Date: Sun, 8 Feb 2009 17:05:27 +0000

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

Other related posts: