Re: REDO log Corrupted - Help

Armando Marcotulli wrote:
>
> Hi everybody,
> recovering a tablespace I got this error: ORA-00354: corrupt redo log
> block header.
> Is there anyone had the same?
> Any solution?
> Thanks.
>
> --
> --------------------------------
> Rimuovere YYY dall'indirizzo
> Remove YYY from email
> --------------------------------If you have mirroring, then no problem. You have two solutions, one is
to copy the mirrored on over to the corrupt one. Another solution is to switch through them bad one, delete it (ONCE YOU HAVE VALIDATED IT IS NOT ACTIVE!!!!), then recreate it. To find out the status of the file, use this query,

select member,l.status from v$logfile f,v$log l where l.group# = f.group#;

Then alter system switch logfile until they are no longer active. If you are not mirrored, then you have a really big problem. You can't recover an active redo log that is not mirrored.

-Sheilah Scheurich
DBA to respond via email - remove the underscores. Received on Tue Sep 30 1997 - 00:00:00 CDT