Re: Am I Screwed?

<important>
Before doing anything and while the db is closed make a backup, so that you can always get back to where you are now. </important>

as you talk about services I'm guessing you are on windows. In this case you should try the following at a command prompt, comments prefaced with ---

net start oracleservice<name> --- to start the service set oracle_sid=<your_sid>
sqlplus /nolog --- start sqlplus but don't log in now in sqlplus connect internal -- or connect sys/password as sysdba startup

you will then get an error, which will most likely be along the lines of "file x needs media recovery", If you get this error then you need to apply redo from your redo logfiles which you can do by typing 'recover database;' If you get another error or you are unsure then post what you see here.

cheers

--
Niall Litchfield
Oracle DBA
Audit Commission UK


"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?

>

> 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

> >

>