Re: Oracle 8i logfile problem

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Sat, 06 Aug 2005 00:02:48 +0200
Message-ID: <dd0nle$tpe$02$1@news.t-online.com>

BCC schrieb:
>

>>
>> 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

>
>
> Tried that...
> Heres the log:
>
> SQL> startup mount
> ORACLE instance started.
>
> Total System Global Area 959467680 bytes
> Fixed Size 73888 bytes
> Variable Size 138080256 bytes
> Database Buffers 819200000 bytes
> Redo Buffers 2113536 bytes
> Database mounted.
> SQL> recover database
> ORA-00283: recovery session canceled due to errors
> ORA-00341: log 4 of thread 1, wrong log # 1 in header
> ORA-00312: online log 4 thread 1: '/opt/oracle/oradata/lims/redoG04M01.log'
>
>
> SQL> alter database open resetlogs;
> alter database open resetlogs
> *
> ERROR at line 1:
> ORA-01139: RESETLOGS option only valid after an incomplete database
> recovery
>
> We have no onsite oracle DBA (he quit, which is why Im stuck with it).
> Ill check out the oracle support, but I think we may have no contract
> for that...
>
> B

You can try instead of RECOVER DATABASE
SQL>RECOVER DATABASE UNTIL CANCEL;
SQL>ALTER DATABASE OPEN RESETLOGS; In case recovery cancels due to errors, it can be considered as completed as well. But, you should be aware, you can damage your database, not having a contract with Oracle however lowers the value of your database immense.
Good luck.

Maxim Received on Fri Aug 05 2005 - 17:02:48 CDT