Re: Whole oracle 7.3.4 database move to another server

As a matter of fact, it IS guaranteed to work if the OS's are binary compatible. In this case, they're both NT so it should work without any problem (provided it's not Alpha NT on one box and Intel NT on the other).

Pete

Alexander Romanov wrote:

> 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 - 13:19:28 CST