Several ways to migrate Oracle databases

Several ways to migrate Oracle databases
We often need to migrate data, migrate to more performance-configurable host OS, migrate to remote rooms, migrate to different platforms, the following describes several Oracle database migration scenarios: First, Exp/imp logical backup and recovery:

It is the most common and simplest method, which is generally based on the owner of the application to do export import.

Operating methods: In the new library to establish a good owner and tablespace, stop the old Library application, in the old Library implementation: $ exp user/pwd owner=xxx file=exp_xxx.dmp log=exp_xxx.log buffer=6000000, import DMP file To the new library, execute the following command in the new library: $ imp user/pwd fromuser=xxx touser=xxx file=exp_xxx.dmp log=imp_xxx.log ignore=y.

Pros and Cons: The advantage is that it can be used across platforms, with long downtime, downtime for transfer from exp to network to new libraries, plus imp time.

Second, storage storage migration:

In this case, data files, control files, log files, spfile are all stored (in general, bare devices), we can hang the storage directly on the new machine, and then start the database on the new machine.

How to operate: the old Library of the pfile (because there are pointing to the naked device spfile link), Tnsnames.ora,listener.ora, password file to the corresponding location of the new library. Cut the storage to a new machine, or copy the data file in the form of a file copy or DD, and start the database.

Advantages and Disadvantages: The advantage is that the migration is very simple, the main work is the work of the host engineer, the DBA can only cooperate, downtime for the shutdown, cut storage, the time to start the library; The disadvantage is that the new and old libraries are the same platform, is the same database version.

Third, the use of data guard migration:

With DG We can not only be used for disaster tolerance, physical DG We can also be a way of migration.

How to: Visible http://www.oracleblog.cn/study-note/dg-created-by-rman/or
http://www.oracleblog.cn/study-note/create-dg-by-rman-one-datafile-by-one-datafile/or other related Web text. Note that after switch over, DG can be removed to remove log_archive_dest_2, Fal_server, fal_client, standby_file_management parameters. Also note that if you use Rman to do DG, pay attention to manually add Tempfile.

Advantages and Disadvantages: The advantage is short downtime, downtime for switch over time; Disadvantages: The host must be dual, storage must be double.

Iv. use Rman to do the migration:

Rman is more suitable for migration across file systems, as in different file systems under the platform.

Action method:

1. To stop a third party's archived backup, such as Legato or DP;

2.backup database;