Re: corrupt archive logs...???

Hi
Are U sure that U'r Archive Log file is corrupt ? Then all other Archived Redo log files later to this cannot be used by Oracle for recovery.
If so ,While doing Media Recovery do a
> Recover Database until Cancel ;

and press Cancel when it is asking for this Corrupted File. Then do a
>Alter Database Open Resetlogs;

Try to Shutdown the Database Normal and take a Full Cold Database Backup because the Arch files gathered prior to 'RESETLOGS' may not be useful for further Recoveries(although this behaviour has changed marginally in Oracle 8)

All the Best

-Thiru
Thomas Kyte <tkyte_at_us.oracle.com> wrote in message news:377da8fe.16021077_at_newshost.us.oracle.com...
> A copy of this was sent to alexgenial_at_iname.com
> (if that email address didn't require changing)
> On Mon, 28 Jun 1999 15:57:30 GMT, you wrote:
>
> >Hello all.
> >
> >I'm using Oracle 7.3.3 on a Unix system (SUN), and for some reason I
> >dont't know, one of the archive logs file got corrupted.
> >Now, I can't start my database (I'm using Oracle as my SAP R/3 database
> >system)
> >
> >1 - what can I do now ? Is it true I have to re-install Oracle ???
> no
>
> >2 - the help suggested to "reset" the log files. Does anybody know how
> >to do this ?
> >
>
> if you have support -- give them a call. they are good at getting down
> databases back up.
>
> short of that -- without the error message and *alot* more information --
i'd be
> carefully applying any feedback you get from the groups. You haven't
given us
> enough information to go on. For example -- if an archive log gets
corrupt it
> would not prevent the database from coming up. It would prevent a point
in time
> or media recovery from being successful but you did not say you were
recovering
> data. Perhaps you really mean an online redo log file is bad - then we
would
> need more info about the circumstances of how the database came down
(shutdown
> normal, shutdown abort, crash, etc).
>
>
>
> >Thank you in advance. Alex.
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Share what you know. Learn what you don't.
>
>
> --
> See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to
Oracle8i'...
> Current article is "Part I of V, Autonomous Transactions" updated June
21'st
>
> Thomas Kyte tkyte_at_us.oracle.com
> Oracle Service Industries Reston, VA USA
>
> Opinions are mine and do not necessarily reflect those of Oracle
Corporation Received on Mon Jun 28 1999 - 15:07:03 CDT