I've never tired this but could you ALTER DATABASE BACKUP CONTROLFILE TO
TRACE and then use that for a
CREATE CONTROLFILE?
If you don't have any data missing from your datafiles and all you need to
do is make your controlfiles current, this should do it.
It sounds like one of 2 things to me.
1) The disk partition(s) with your redo logs and control files were on the
root disk.
Bad idea.
2) The SA restored files other than just those needed for the root
filesystem.
Could be others, but that's what comes to mind.
Do you have control
Exactly that . we don't know what the SA did, nor will he give us much
info. This will be pursued once we get all instances back up. We do have
the control files dumped to trace, but unfortunately, then it expects the
redo logs to be intact, which they are not. We are in the process of
