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: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Fri, 5 Aug 2005 21:10:43 -0700
Message-ID: <x7-dnX0jeu5gqmnfRVn-2A@comcast.com>

"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

Original text of this message

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