Re: Whole oracle 7.3.4 database move to another server

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'.

bp

In article <83r7sc$8ju$1_at_oak.prod.itd.earthlink.net>,   "news.earthlink.net" <rdas_at_tidemarksys.com> wrote:
> 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?
>
> thanks.
>
> Rabin
>
>

--
B.Polarski

http://www.geocities.com/bpolarsk
Email : bpolarsk_at_yahoo.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 23 1999 - 08:17:25 CST