Re: So, did I do good? (Did my first Oracle recovery, seems good... thoughts?)

From: Glen A Stromquist <glen_stromquist_at_no.spam.yahoo.com>
Date: Thu, 02 Oct 2003 20:34:46 GMT
Message-ID: <GZ%eb.2434$%P2.2090@edtnps84>

Thomas T wrote:
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
> news:3f7c4a32$0$250$ed9e5944_at_reading.news.pipex.net...
>

>>"Thomas T" <T_at_T> wrote in message news:3f7b44d0$1_at_rutgers.edu...
>>
>>>Wow, am I glad I implemented archivelog mode on our old Oracle 7.3

>
> server!
>

>>>Here's what happened- did I do good?
>>>(..snip..)
>>>Hopefully I didn't make that confusing... basically, I'm wondering if I
>>>should've brought file 11 from it's last good hot-backup, or if it was
>>
>>okay
>>
>>>to have performed recovery on the "needs media recovery" file.
>>>
>>>Thanks!
>>
>>If did I do good means 'did I recover my data to where I want it to be?'
>>then the answer is Yes.
>>
>>However things that jump out at me.
>>
>>You aren't sure if you did everything correctly - this means that
>>a) you've never done this before - time to get a test environment and try
>>out various recovery scenarios so you don't see them for the first time

>
> with
>

>>the CEO shouting at you :(
>>b) You don't have your recovery process documented - what would have
>>happened if you were on leave for the next 3 weeks?
>>These two are connected. basically the last thing you want in a high
>>pressure situation is to be faced with the unknown.
>>
>>You don't know whether you needed to restore the file and apply logs or

>
> just
>

>>apply logs. The answer is the second.
>>
>>You backed up before you tried recovering. Everybody should do this.
>>
>>-- 
>>Niall Litchfield
>>Oracle DBA
>>Audit Commission UK

>
>
> Both good points!! I have a test server (with 8i) that I was going to play
> with for recovery scenarios, but kept putting it off. Looks like I'll be
> trying to tackle that tomorrow- along with some documentation. I had
> someone looking over my shoulder for the first hour- which I'm not used to-
> and I wasn't able to think swiftly.
>
> What would've happened if that file -was- corrupted due to a bad sector on
> the drive? Would Oracle tell me that it couldn't apply logs?
>
> My worry was that Oracle patched up a corrupt file, and would fail again
> when it tried to read the bad area (example, hard drive sector).
>
> Thanks,
>
> -Thomas
>
>

FWIW one thing I try to do now whenever I have to create a clone database of a production db is recover from a hot (or cold) backup and apply redo to it...

I was just going to to that to one of my linux test boxes when I realized that this is not viable across platforms :-( , so I am doing a long slow import as we speak...

I was originally going to make the linux box kind of a quasi-standby, whereas I'd just apply redo at regualr intervals thru a script or something, but I didn't even think about not being able to move archived logs across different platforms.

On the plus side I think that this will be doable in 10G IIRC correctly... Received on Thu Oct 02 2003 - 15:34:46 CDT