RE: oracle recovery scenarios

Vishal  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield Sent: 08 February 2009 13:30
To: howard.latham_at_gmail.com
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?    

:(  

Niall

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

--

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

--
http://www.freelists.org/webpage/oracle-l