HI



When part of the database was being accessed I was getting an error
pointing a datafile was offline that exists on a remote machine mounted
on my drive.

So I shutdown the instance and restarted it to recover the datafile. Now
at startup I get the error as



ORACLE instance started.



Total System Global Area 202445884 bytes

Fixed Size 451644 bytes

Variable Size 167772160 bytes

Database Buffers 33554432 bytes

Redo Buffers 667648 bytes

Database mounted.

ORA-16068: redo log file activation identifier mismatch

ORA-00312: online log 1 thread 1:
'/opt/oracle9204/oradata/EXOT/redo01.log'



When I checked out this 16068 error I saw at a forum that maybe the
redo-log files that are shown when I fire are not the right ones.



select member from v$logfile;

MEMBER

------------------------------------------------------------------------
--------

/opt/oracle9204/oradata/EXOT/redo03.log

/opt/oracle9204/oradata/EXOT/redo02.log

/opt/oracle9204/oradata/EXOT/redo01.log



I have checked that the log files are correct and point to the same
location.

What else can I check? Any hints pointers are welcome.



Regards,



Ishdeep Singh Anand

Infosys Technologies Ltd.



The usual .... thoughts .... disclaimer .... etc ...




Oracle LazyDBA home page