Re: Weird recovery, need help please

From: Vitalis Jerome <vitalisman_at_gmail.com>
Date: Wed, 25 May 2005 13:42:27 +0200
Message-ID: <68b12855050525044217dadac7@mail.gmail.com>

On 5/24/05, Oracle <all_about_oracle_at_hotpop.com> wrote:
> this is the error I have

>=20

> Specify log: {<RET>=3Dsuggested | filename | AUTO | CANCEL}

>=20


> ORA-00283: recovery session canceled due to errors

> ORA-00354: corrupt redo log block header
> ORA-00353: log corruption near block 215 change 4440998281220 time
> 05/25/2005 00
> :04:41
> ORA-00334: archived log: 'C:\ORACLE\ORADATA\CANADA\ARCHIVE\ARC01654.001'

>=20
>=20

> ORA-01112: media recovery not started

Hi,

ORA 353 is clear about the cause of your problem. See the detailed explanation for it:

// *Cause: Some type of redo log corruption has been discovered. This erro= r

//          describes the location of the corruption. Accompanying errors
//          describe the type of corruption.
// *Action: Do recovery with a good version of the log or do incomplete
//          recovery up to the indicated change or time.

HTH
Jerome

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

Received on Wed May 25 2005 - 07:47:12 CDT