Re: oracle recovery scenarios
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: howard.latham@xxxxxxxxx
- Date: Sun, 8 Feb 2009 17:44:15 +0000
gaarrrgh
I did a google search for amongst other things, oracleexpert.com,
oracleguru.com and so on and kept coming up with close matches to real
domains. I didn't want to suggest that a particular site was bad, so when I
found that oraclewisdom.com didn't produce any relevant results, I just made
up a domain. Trust me to find a real but parked one :(
Now was someone writing about using the internet sensibly and checking
things....
Niall
On Sun, Feb 8, 2009 at 1:30 PM, Niall Litchfield <niall.litchfield@xxxxxxxxx
> wrote:
> 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
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
