Re: Oracle 8i logfile problem

From: BCC <bcc_at_abcz.com>
Date: Fri, 05 Aug 2005 21:05:11 GMT
Message-ID: <bwQIe.726$Z87.337@newssvr14.news.prodigy.com>

Sybrand Bakker wrote:

> export ORACLE_SID=<yoursid>
> sqlplus '/ as sysdba'
> (in the sqlplus prompt)
> startup mount;
> alter database open resetlogs;
>
> If I were you I would
> shutdown immediate
> exit
>
> and take a backup of this database. At least you know *this* situation
> is consistent.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

Hi thanks, for the info!

I actually tried this a bit ago, and it doesnt work. If I do: alter database open resetlogs

I get the error:
"RESETLOGS option only valid after an incomplete database recovery"

And there we sit.

Any other thoughts would be appreciated!

Bryan Received on Fri Aug 05 2005 - 16:05:11 CDT