Re: Am I Screwed?

"Mark" <m_sparky_at_eudoramail.com> wrote in message news:jbApa.840$Ey3.380329064_at_twister1.starband.net...
> 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?

<important caveat>
backup the database now whilst it is down so you can do no further harm. </important caveat>

I suggest that you do the following at a command prompt comments prefaced by ---

net start oracleservice<name> --- start the service set oracle_sid=<your sid name> --- set the environment up sqlplus /nolog --- start sqlplus without logging in connect sys/<password> as sysdba --- connect as the privileged user startup --- try to start manually.

My guess is that you will get an error along the lines of 'file n needs media recovery' in which case you need to apply redo from the redo logs. This is done by typing 'recover database;' Most likely this will be all you need and you can then type 'alter database open;' and all will be fine. If this is not the error you get or you are prompted for logs you do not have then most likely you will need to recreate and import (assuming you don't have all logs since the last good backup). Do let us know what happens.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************