Re: Am I Screwed?

Here's what I've done now.

I first set the CONTROL_FILES parameter to only the second file that was there before. I then started the db service again. Gave me the same error again.

Then I changed the parameter again to an older backup I did using 'alter database backup controlfile to '...';

This time the service starts up with no errors, but when I try loggin in, it says that the service is still in startup or shutdown procedures.

Does someone know what this means? or what I can do after this?

THanks,
Mark

Phillip wrote:
> here's what I would do. It sounds as if you may need to recreate your
> controlfile. Shutdown the database, copy the existing controlfile(s) to
> something else, say control.old. Hopefully you've been doing a periodic
> 'alter database backup controlfile to trace;' command which is simply an
> ascii file with syntax to recreate your controlfile. If so, you can run
> that script to recreate your controlfile(s). The thing to keep in mind is
> that if for some reason that script fails, you're in no worse of shape than
> you are currently. You still have your old controlfile (the ones you
> renamed) and your database is still offline so no harm done.
>
> Option B would be to see if one of your controlfiles was hosed, but the
> other ones are good. You are multiplexing your controlfiles, right?
> Hopefully... So you go into your pfile and remove one of the controlfiles
> listed and see if your database comes up.
>
> Other than that, I can only think of restoring and recovering the database
> from a backup. Best of luck.
>
> Mark wrote:
>
>
>
>
> --
> Phillip
>
Received on Wed Apr 23 2003 - 12:36:57 CDT