Oracle Database migration methods

Blog.chinaunix.netuid-7589639-id-2948982.html we often need to migrate data to more performance configuration more advanced host OS, migrate to remote data center, migrate to different platforms, the following describes several ORACLE database migration solutions: 1. expimp logical backup and recovery:

Http://blog.chinaunix.net/uid-7589639-id-2948982.html we often need to migrate data to more performance configuration more advanced host OS, migrate to remote data center, migrate to different platforms, the following describes several ORACLE database migration solutions: 1. Logical backup and recovery of exp/imp:

Http://blog.chinaunix.net/uid-7589639-id-2948982.html

We often need to migrate data to host OS with higher performance configurations, to remote data centers, and to different platforms, the following describes several ORACLE database migration solutions:

1. Logical backup and recovery of exp/imp:

It is the most commonly used and simplest method, generally based on the application's owner level for export and import.

The operation is as follows:

Create the owner and tablespace in the new database, stop the application of the old database, and execute the following in the old database:

$ Exp user/pwd owner = XXX file = exp_xxx.dmp log = exp_xxx.log buffer = 6000000,

Import the dmp file to the new database and execute the following command in the new database:

$ Imp user/pwd fromuser = XXX touser = XXX file = exp_xxx.dmp log = imp_xxx.log ignore = y.

Advantages and disadvantages: it can be used across platforms. The disadvantage is that the downtime is long, and the downtime is from exp to network transmission to new database, plus imp time.

Ii. Storage migration:

In this case, data files, control files, log files, and spfiles are all stored (normally bare devices), and we can directly mount the storage to a new machine, then start the database on the new machine.

Operation Method: Upload the pfile of the old library (because there is a spfile link pointing to the bare device), tnsnames. ora, listener. ora, and password file to the corresponding location of the new library. Switch the storage to the new machine, or copy the data file using the file copy or dd method to start the database.

Advantages and disadvantages: the migration method is very simple. The main task is to work as a host engineer. dba only needs to work with each other. The downtime is the time when the database is stopped, the storage is switched, and the database is started; the disadvantage is that the new and old databases are all on the same platform and are of the same database version.

Iii. data guard migration:

We can not only use dg for disaster tolerance, but also use physical dg for migration.

Operation Method: see http://www.oracleblog.cn/study-note/dg-created-by-rman/or
Bytes. Note that after switch over, you can remove the dg and remove the log_archive_dest_2, FAL_SERVER, FAL_CLIENT, and standby_file_management parameters. In addition, note that if rman is used for dg, add tempfile manually.

Advantages and disadvantages: The downtime is short, and the downtime is the switch over time. Disadvantages: the host must be dual, and the storage must be dual.

4. Use rman for Migration:

Rman is suitable for cross-file system migration, just like different file systems on the platform.

Operation Method:

1. Stop archive backup from a third party, such as legato or dp;

2. backup the database;