Shulou(Shulou.com)06/01 Report--

On the basis of introducing the migration mode of Oracle, this paper focuses on its concrete steps. The content of this article is compact. I hope you can get something. The following is an introduction to four migration methods.

1. Exp/imp: this is also the most commonly used and simplest method, which is generally based on the owner level of the application to do export and import. The operation methods are as follows: establish owner and tablespace in the new library, 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, and do imp user/pwd fromuser=XXX touser=XXX file=exp_xxx.dmp log=imp_xxx.log ignore=y in the new library. Advantages and disadvantages: the advantage is that it can be used across platforms; the disadvantage is that the downtime is long, and the downtime is transferred from exp to the network to the new library, plus imp time.

Second, storage migration: in this case, data files, control files, log files and spfile are all on storage (usually bare devices). We can directly mount the storage to the new machine, and then start the database on the new machine. How to operate: transfer the pfile of the old library (because there is a spfile link to the bare device), tnsnames.ora,listener.ora, password file to the corresponding location of the new library. Cut the storage to the new machine, or copy the data file by file copy or dd to start the database. Advantages and disadvantages: the advantage is that the migration mode is very simple, the main work is the work of the host engineer, dba only needs to cooperate, and the downtime is the time of storage, storage and unloading. The disadvantage is that both new and old libraries are required to be on the same platform and the same database version.

Third, use data guard to migrate:

With dg, we can not only do disaster recovery, physical dg can also be used as a way of migration.

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

Fourth, use rman for migration: rman is more suitable for cross-file system migration, just like different file systems under the platform.

So much for sharing about Oracle migration. I hope the above content can be used as a reference for all of you. If you like this article, you might as well share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.