Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 8i logfile problem
"BCC" <bcc_at_abcz.com> wrote in message
news:_YQIe.2242$fJ1.722_at_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
You should buy support. If the data is important then you should have
support.
Jim
Received on Fri Aug 05 2005 - 23:10:43 CDT