Export oracle database to another server

Question

How can i migrate oracle database from one server to another along with data?

Database is on Window server and i need to copy it to another window server. Nothing complex :)

Answer 1

The easiest option from an administrative perspective would be to do a full export and import. The Data Pump versions of the export and import utilities will be more efficient than the classic version. The dump file that is generated can be imported into a later version of Oracle on any platform.

The downside of using export and import, however, is that it takes a while. You have to read all the data out of the database to the file system and write it all back into the new database. If you don't want to lose data, that means a potentially hefty downtime.

If you don't have the downtime window to do a full export and import, you could restore your last backup to the new machine if you want to run exactly the same version of Oracle on the same operating system. You can also use cross-platform transportable tablespaces.