Re: Whole oracle 7.3.4 database move to another server

From: Alexander Romanov <romanov_alex_at_my-deja.com>
Date: Thu, 23 Dec 1999 17:59:29 GMT
Message-ID: <83tnsb$pkg$1@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 - 11:59:29 CST