Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Weird recovery, need help please
I can reproduce the error by repeating my test.
I don't think everytime the archived redolog created are corrupted.
I have one good copy of cold backup, I open resetlogs then bounce the db. Then I perform the test, now the db give me ORA-600
> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 25 2005 - 23:21:07 CDT
![]() |
![]() |