Re: oracle recovery scenarios
- From: Howard Latham <howard.latham@xxxxxxxxx>
- To: Vishal Gupta <vishal@xxxxxxxxxxxxxxx>
- Date: Sun, 8 Feb 2009 17:01:55 +0000
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
Other related posts:
