Re: How to fool new server to use old data files?

You are not very specific as to the error messages you have been getting when restarting that server. As long as you have all the files including the init<SID>.ora file, pointing to the correct control files, it should work. You probably don't have the result of
alter database backup controlfile to trace, I assume?
You probably just reinstalled. In that case the only choice you have is write your own script with a
create controlfile statement in it, which should list ALL files belonging to ANY tablespace.
The sequence of commands needed is
svrmgr23

svrmgr23> connect internal
svrmgr23> startup nomount
svrmgr23> start <your script>
svrmgr23> alter database open resetlogs
svrmgr23> exit

I strongly advice you to take a backup of that database NOW, in order to make sure, should this attempt fail, you have at least something, when you call Oracle Support.

Hth,

--
Sybrand Bakker, Oracle DBA
dragan <dmarkovicNOdmSPAM_at_expandia.com.invalid> wrote in message news:31b2e646.8ac48428_at_usw-ex0108-062.remarq.com...
> I had MS NT 3.51 server with Oracle Workgroup Server 7.3.3
> After I upgraded NT on 4.0 I lost registry. Oracle server
> couldn't start. I reinstalled Oracle Server but new
> installation didn't recognized old databases. How to use old
> databases on new Oracle server? Or to be more precise how to
> fool new server to use old data files?
> I have 12 hours to solve this problem. If not, tomorrow I
> will be unemployed.
> Any tip, advice or sugestion is more than welcome.
> dragan
>
>
> * Sent from AltaVista http://www.altavista.com Where you can also find
related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful Received on Tue Nov 02 1999 - 12:43:08 CST