Re: corrupt archive logs...???

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 - 11:58:06 CDT