Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: moving database from one server to another
The way that we do it which (I think) is easier is to copy to the datafiles, rename them on the target and use a controlfile trace copy to change the name of the DB and the pathnames of the datafiles (if they contain the DB name). Email me if you want more details.
Bill Border
Agilent Technologies (formerly Hewlett-Packard)
bill_border_at_agilent.com
Low-Cost UX-Based Oracle/Informix Monitor: http://dbamon.com
Stephan Hartmann wrote in message <8lvadf$712$15$1_at_news.t-online.com>...
>Hi,
>
>I think the best way is to install the Oracle Server new,
>and build up new instances. The youn can use the export/import utilities
>to move the data from one server to the other.
>
>When doing so, it's also a good idea to overthink the 'sizes' of the
>database.
>You 've got bigger drives, maybe you will need bigger tablespaces ?
>
>If you have more RAM you should adjust the memory setting (SGA)
>(more RAM - better Performance!)
>
>bye
>Stephan Hartmann
>
>
>"Gerry Grant" <gerry.grant_at_ttu.edu> schrieb im Newsbeitrag
>news:8lnjgv$9nq$1_at_news.acs.ttu.edu...
>> Newbee question: What is the best/easiest method to move a database
(Oracle
>> 8.0.5, NT 4.0) from one server to another? The servers are configured
the
>> same except the new server is faster and has larger disk drives.
>>
>> Do you create an instance with the same file structure and just copy the
>> datafiles, controlfiles, and logfiles? What if you want to do it a
second
>> time, just drop those files and do another copy? Sounds too easy. I'm
sure
>> I am missing something.
>>
>> Gerry
>>
>>
>
>
Received on Tue Aug 01 2000 - 00:00:00 CDT