Home / server / Questions / 197000
Accepted
RPK
Asked: 2010-11-02 09:26:35 +0800 CST

How to move Oracle database to another PC without restoring backup?

  • 772

Take this scenario:

Suppose the customer has no backup of Oracle 9i or 10g database. The customer wants to move the database from one PC to another. The other PC has a fresh installation of Oracle.

How to move the data and other files and attach to the new installation? In this scenario, we don't have any type of backup, neither a dump nor any other type.

oracle oracle10g oracle9i

3 Answers

  1. Make a backup and restore it to your new Pc and make backups in the future!

    • 3
  2. Best Answer

    Check out this SF question.

    • 1

  3. The exact way, could depend on your configuration, but roughly, you could:

    1) Export / Import (see documentation for exp)

    2) Cold backup:

    • Make sure you have a copy of your pfile/spfile
    • Shutdown your source database
    • Copy your datafiles to the new server

    There are some steps to do in between, but the advice is to consult with an oracle DBA, or read the documentation on otn

    • 1