Several ways to migrate Oracle

We often need to migrate data, migrate to more advanced hosts, migrate to remote rooms, migrate to different platforms ...

First, Exp/imp: This is the most commonly used the simplest method, is generally based on the application of the owner-level to do export import. Operation Method: In the new library to establish the owner and table space, stop the application of the old library, do exp user/pwd owner=xxx file=exp_xxx.dmp log=exp_xxx.log buffer=6000000 in the old Library, transfer DMP files to the new library, Make imp user/pwd fromuser=xxx touser=xxx file=exp_xxx.dmp log=imp_xxx.log ignore=y in the new library. Pros and Cons: The advantage is that it can be used across platforms; Downtime is the time from exp to network transfer to the new library, plus imp.

Second, storage migration: In this case, data files, control files, log files, spfile are stored (in general, bare devices), we can directly put the storage on the new machine, and then start the database on the new machine. Operation Method: The Old Library's pfile (because there is pointing to the bare device SPFile link), Tnsnames.ora,listener.ora, the password file to the new library's corresponding location. Start the database by cutting the storage to a new machine, or copying the data file with a copy of the file or DD. Pros and Cons: The advantage is that the migration method is very simple, the main work is the work of the host engineer, DBA only need to cooperate, the downtime for when the library, cutting storage, starting the library time. The disadvantage is that the new and old libraries are both the same platform and the same database version.

Third, the use of data guard migration:

With DG We can not only be used to do disaster recovery, physical DG We can also as a way to migrate.

Advantages and Disadvantages: The advantage is that the downtime is short and the downtime is switch over time. Disadvantage: The host must be double, the storage must be two copies.

Iv. migrating with Rman: Rman is more suitable for cross-file system migrations, like different file systems under the platform.

Several ways to migrate Oracle