RE: oracle recovery scenarios

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
                --
                http://www.freelists.org/webpage/oracle-l
                
                

        
        
        
        -- 
        Howard A. Latham
        
        




-- 
Howard A. Latham






-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

Other related posts: