Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 8i logfile problem
>
> 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 bytesDatabase mounted.
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