Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 8i logfile problem

Re: Oracle 8i logfile problem

From: BCC <bcc_at_abcz.com>
Date: Fri, 05 Aug 2005 21:35:54 GMT
Message-ID: <_YQIe.2242$fJ1.722@newssvr13.news.prodigy.com>

>
> 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 Received on Fri Aug 05 2005 - 16:35:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US