Re: LCC-00161 and ORA-1031 while starting a server

Sorry about the incomplete information. I actually renamed the temporary tablespace's datafile (to savcpdbtemp1.dbf) out from under the instance while it was shut down, then restarted, and got the error mentioned in the subject line. After renaming savcpdbtemp1.dbf back to its orginal name (cpdbtemp1.dbf), the error persisted. Oracle did not realize that it was in the exact same state as it was when it was running healthy minutes before.

Thanks for any input, Jon

In article <35BE4F2A.2A49A57D_at_earthling.net>,   jhy <jhy_at_earthling.net> wrote:
> You didn't say which datafile you deleted. I haven't tried it, but if you
blow
> away the datafile where the rollback segments resided and you list the
rollback
> segments in your parameter file, then the error you see is not out of the
> question. I'm guessing that putting in an old backup copy of the deleted
database
> file should get you to the point where Oracle will realize that recovery is
> required.
>
> nordby_at_my-dejanews.com wrote:
>
> > Oracle Server 7.3.4
> > NT 4.0 SP3
> >
> > I'm working on testing our backup/recovery strategy, so I've been doing
things
> > like deleting datafiles, then starting the server back up. On occaision,
> > rather than giving me a datafile error, Oracle trashes itself and gives the
> > errors listed in the subject line. The LCC-00161 is usually associated with
> > syntax errors in the initsid.ora files, but since they have not been touched
> > since the instance was running 5 minutes before, there is no way that is the
> > case.
> >
> > Looking on Oracle's online help/knowledge base (this forum is infinately
more
> > responsive and often more useful) says that the NT service has corrupted
> > itself, and to use oradim73 -DELETE -SID sid, then recreate it. This seems
> > pretty ridiculous to just recover a datafile. The workaround does work, but
> > has anyone else encountered this, and found a way to fix it without deleting
> > the instance or reinstalling Oracle bits from the CD?
> >
> > Thanks for the help, Jon.
> >
> > -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Jul 29 1998 - 09:20:04 CDT