Re: problem with archive log files

From: Michael Spiller <mike.spiller_at_lmco.com>
Date: Mon, 28 Jun 1999 09:48:11 -0700
Message-ID: <3777A74B.3759BA03@lmco.com>

The common method is to shutdown the database and log into svrmgr or sqldba and at the prompt type in:
> startup mount
> recover database until cancel; (perform an incomplete recovery up to
corrupted log file)
> alter database open resetlogs;

Then perform a backup of the entire database.

alexgenial_at_my-deja.com 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 ???
> 2 - the help suggested to "reset" the log files. Does anybody know how
> to do this ?
>
> Thank you in advance. Alex.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon Jun 28 1999 - 11:48:11 CDT