Re: Oracle 8i logfile problem

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Fri, 05 Aug 2005 23:13:12 +0200
Message-ID: <dd0kod$g2q$05$1@news.t-online.com>

BCC schrieb:
> 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
>

To open with resetlogs you should after startup mount simulate a recovery , also issue

SQL>RECOVER DATABASE;
SQL>CANCEL
SQL>ALTER DATABASE OPEN RESETLOGS;

Better however to get onsite an Oracle DBA (or contact Oracle Support, which can surely assist you).

Best regards

Maxim Received on Fri Aug 05 2005 - 16:13:12 CDT