Interview: Exp/imp logical backup and recovery: Two, storage storage migration: Data files, control files, log files, SPFile to the new machine, and then start the database on the new machine. Third, the use of data Guard migration: four, using Rman to do the migration: we often need to migrate data, migrate to more advanced performance configuration on the host OS, migrating to a remote room, migrating to different platforms, the following describes several Oracle database migration scenarios:First, Exp/imp logical backup and recovery:
It is the simplest and most commonly used method, and is generally based on an application's owner level for export import.
To do this: establish the owner and tablespace in the new library, stop the application of the old Library, execute in the old library: $ exp user/pwd owner=xxx file=exp_xxx.dmp log=exp_xxx.log buffer=6000000, Import the DMP file into the new library and 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 a long downtime and downtime from exp to network transfer to the new library, plus imp time.
second, storage storage migration:
In this case, the data files, the control files, the log files, the SPFile are all on the storage (in general the bare device), we can hang the storage directly 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.
Advantages and Disadvantages: The advantage is that the migration method is very simple, the main work is the work of the host engineer, the DBA can only cooperate, the downtime is to stop the library, cut storage, the time of the library, the disadvantage is that the new and old libraries are the same platform, 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.
Operation method: 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 that the downtime is short, the downtime is switch over the time; disadvantage: The host must be double, the storage must be two copies.
Iv. migrating with Rman:
Rman is better suited for cross-file system migrations, like different file systems under the platform.
Operation Method:
1. Stop a third-party archive backup, such as Legato or DP;
2.backup database;
Several ways to migrate Oracle databases
