Re: moving database from one server to another

The easiest ways are as follows (assuming the platforms are the same i.e. OS )

1. cold/hot backup source and recover in target (could be easy)
2. export source and import in target (easy)
3. use dblinks to copy data over (easy but takes a long time)

SH

Gerry Grant wrote:

> 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 Thu Jul 27 2000 - 00:00:00 CDT