Re: Whole oracle 7.3.4 database move to another server

I've succesfully moved Oracle databases between two NT servers. Copy the database files over. Then run oradimxx to create a new instance. Bring up the database mounted and rename the files. Shutdown, startup and you're off to the races.

--
Terry Dykstra Canadian Forest Oil Ltd.
Check out Sybase Developer's Network: http://www.sybase.com/sdn

Alexander Romanov <romanov_alex_at_my-deja.com> wrote in message news:83tnsb$pkg$1_at_nnrp1.deja.com...
> Copy datafile NO garanted correct work database.
> It is allowable only only within limits ONE platform.
> Better to use the utilities Export/Import - if you base is big this
> way will reduce sizes your base.
>
> > Shutdown your instance and copy all the files if it is same path,
> > or if
> > machines 2 has differents path, then the easiest way is to recreate
> > control files first. Browse the news for 'alter database backup
> > controlfile to trace'.
> > > Here is the scenario:
> > > I have two oracle database on two separate servers. OS is NT server
> > on both
> > > machine. SID name is ORCL on both machine. I would like to move ORCL
> > > database(SID) from server1 to server2 ORCL database(SID) so that
> > server1
> > > will be used as pure SQL server.
> > > What should I do?
> > > Do I need to create another instance of different name on server2 or
> > can I
> > > move datafiles from server1 to server2 or control files? What about
> > > export/Import? Do I need to create schema first on server2?
> > > Can anybody would kind enough to give details on step-by-step?
>
> --
> Alexander Romanov
> Oracle Tekmetrics Certified
> St-Peterburg
> Russia
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Dec 23 1999 - 12:51:26 CST