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

I think he has to do an oradim first, so the instance knows the oracle_home. ( the oratab is in the registry)

Rene van Geijn

Sybrand Bakker wrote:

> 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 Wed Nov 03 1999 - 01:20:14 CST