RE: oracle recovery scenarios
Date: Sun, 8 Feb 2009 16:28:44 -0000
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield Sent: 08 February 2009 13:30
Cc: oracledbaquestions_at_gmail.com; oracle-l_at_freelists.org 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?
On Sun, Feb 8, 2009 at 1:00 PM, Howard Latham <howard.latham_at_gmail.com> 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_at_gmail.com>
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_at_gmail.com>
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 -- http://www.freelists.org/webpage/oracle-l -- Howard A. Latham
Howard A. Latham