Re: Oracle 8i logfile problem

BCC wrote:
> >
> > To open with resetlogs you should after startup mount simulate a
> > recovery , also issue
> > SQL>RECOVER DATABASE;
try:
recover database until cancel;
instead. If it offers to apply a log, press return. Keep doing that until it asks about the bad one or one that doesn't exist. Then cancel, then alter database open. Do the resetlogs if it complains that you need to.

Also, find a file called aler*log that should tell you what logs have been archived. If, of course, you are in archivelog mode.

Did you perchance restore all files including '/opt/oracle/oradata/lims/redoG04M01.log' from a backup?

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

Too bad. If you had kept a contract going, you would be supportable. Now, you are TSOL. You really need a DBA, and to bring things to the current century. Unless of course your lims data is not really necessary. What geographic area are you in?

jg

--
@home.com is bogus.
Consume mass quantities!
http://www.signonsandiego.com/uniontrib/20050805/news_1b5mediaflo.html