Re: moving database from one server to another

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 Sat Jul 29 2000 - 00:00:00 CDT