Re: Recovering from lost controlfile.

From the sound of your situation, it doesn't make sense. I would suggest that it sounds like the SCN number in your controlfile is at least 2 days too early. This is making me think that maybe you lost the controlfile because another similar database's control file got mixed up with it -- perhaps you copied a database in that time frame. Another possibility, if your on UNIX, might be that you were doing a lot of trying this and that and your sgadef* file is still hanging around in a state of the last time it was successfully opened -- if that's the case, delete it. If the controlfile that you had created from an existing db -- I assume using backup controlfile to trace -- is still not doing the trick, it would give more support to a sgadef file confusing things. Also, make sure all your controlfiles are the same.

If your backups include the controlfiles, you could always go back to the point in time of backup.

Been in the same boat myself. You take good backups, you know the recovery methods, but you end up late night without hair. Hope I've been of some help.

"Greg Tupper" <gtupper_at_tupper.dhs.org> wrote in message news:4z7k4.4738$%85.41852_at_hnlnewsr1.hawaii.rr.com...
> -->Same person as original post, different account.<--
>
> What is bugging us is the system tablespace is asking for a redo from two
> weeks ago, when reviewing the logs from recent hot backups no errors are
> reported for the system table space.
>
> We have created another control file from the existing db and tried a
> recover. It still asks for the old redo.
>
> Is there a way to accept the inconsistent state, force the database open,
so
> we might export the data?
>
>
> Mohamed Buhari wrote in message <3890FA01.21D6A2DF_at_assigncorp.com>...
> >>>>>>dbf files from yesterday.
> >dbf files from today.
> >redolog files from yesterday through the last successful shutdown.
> >control file from today. <<<<<<<
> >
> >1. If it is in archivelog mode : You need the following
> >
>
>
>
Received on Fri Jan 28 2000 - 00:50:48 CST