in case this has happened to someone else:
This system crashed while I was importing a large table (lots of
LOBs). When I start up I get a message that says that system.dbf is
more recent than the control file.
First I tried starting up with each control file in turn - no luck
(though now it won't start up at all if I switch away from the control
file I'm currently using). So I moved on to "recover database using
It needs sequence #16163. I tried telling it to read from redo01.log,
which was the active redo log at the time of the crash, but it tells
me that log contains sequence 16162. So then I tried redo02.log, which
it was unable to read (internal error code, arguments: ,
, , , , , , ) and redo03.log, which
of course was too old (sequence 16161).
It looks to me like the needed sequence wasn't written, due to the
crash. Maybe it was about to switch to redo log 2, and crashed during
the switch? Whatever, I just need to get this database up and running!
Is there anything I can do here, short of reinstalling and loading
last night's dump?
It is times like this when I realize that I don't know as much about
Oracle as I need to! :)