Re: Move whole database

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: 1999/12/21
Message-ID: <945806940.23569.0.pluto.d4ee154e@news.demon.nl>#1/1

Hopefully Immo didn't try this yet. It is completely wrong Steps to be executed
1 make a cold backup of that database (You never know) 2 restart the database and in svrmgr<xx>

   issue
   alter database backup controlfile to trace    then
   show parameter user_dump_dest
   the trace file will be located in that directory. 3 take the whole lot to the new server including that trace file 4 alter the control_files parameter in init<sid>.ora 5 edit the tracefile created in step 2 to reflect the new directory names 6 start the services
7 run the trace file through svrmgr<xx>
Now you should be set

Hth,

--
Sybrand Bakker, Oracle DBA
P. van der Ven <pven_at_iname.com> wrote in message
news:385fd4b4.12535995_at_news.giganews.com...


> >Hello

> >

> >I must transfer a whole database from one to another NTserver with

> >different Directorys.

> >How can i do it ?

>

> Copy the datafiles and update the paths in init.ora.

>

> >Thanks

> >Immo

>

> (I am quite new to DBA-stuff, so please tell me when I am wrong!)

>

> Regards,

> P. van der Ven

> ---

> http://contactpven.da.ru/

Received on Tue Dec 21 1999 - 00:00:00 CST