Re: Corrupt redo log file - database only gets to mount

Jeff Traigle wrote:

> Ok. This isn't my system I'm writing about, but, since I'm tagged as the
> UNIX/Oracle expert (a scary thought on the Oracle side since I only started
> doing the DBA work at my plant 3 years ago as a small part of my overall
> responsibilities) by all of the plant IT people in my company, I got called
> to look into this today. Fortunately, not my problem to solve and I think
> they rather hosed themselves, but here's what the situation is. I'd
> appreciate some input as to if I'm totally off base on the solution.
>
> Database is 8.0.X on HP-UX 10.20. They couldn't connect to the instance and
> bouncing it resulted in ORA-00333. Checking the alert log told me the redo
> log file for group 1 was getting an IO error at the OS level. This should be
> an easy fix, but the structure of where files were located is a mess and I
> found in short order that the redo logs were not duplexed (doh!). The
> database is in archivelog mode and they *think* they have a full system
> backup that contains the offending redo log file. We tried a few things, but
> nothing was successful either because they required the database to be open
> or because the offending log file was the active one.
>
> Any obvious thing we're missing to get the database to overlook this bad
> redo log file?
>
> If they do have a backup copy of the redo log, they should be able to drop
> it in place and recover from there, right?
>
> If they don't have the backup, they're rebuilding, right?
>
> Insights appreciated.
>
> --
> Jeff Traigle
> traigle_at_si.umich.edu
> http://www-personal.si.umich.edu/~traigle/

I'm a little uncertain of what you mean by back-up copy of the redo log. There are hopefully multiple redo logs in each redo log group and multiple groups. But these, alone, are not going to get you very far. Especially if they were backed up as the backup likely bears no relationship to the state of the log files at the moment they became toast.

Can you clarify?

I think, were I you, I would have opened an iTAR at metalink by now. This has all the signs of being ugly.

Daniel Morgan Received on Mon May 13 2002 - 18:31:37 CDT