数据库的升级及迁移（Database upgrade and migration）.docVIP

数据库的升级及迁移（Database upgrade and migration） Database upgrade and migration Personal classification: Oracle This paper discusses the preparation, upgrade process and test and adjustment of the upgrade of Oracle database before upgrading, and tests various upgrading methods on various operating system platforms. The need for database upgrades Database upgrade is a problem that database administrators often have to face if your application uses a new version of the database New features; if the database is running overloaded, and the soft hardware adjustment and not a fundamental improvement; if you want to replace the operating system platform; if you want to improve the security of database; another reason is that with the advent of the new version of the database and mature, Oracle stopped support for the old versions of the database technology, upgrade to a higher version, can continue to receive the support of Oracle, can also use the new version of the database is a new feature, can improve the system performance, robustness, scalability and availability, and so on, in the face of these problems, need can be solved by upgrading the database. However, if your system is stable and there are no major performance bottlenecks, do not easily upgrade the database, because upgrading a product database can be a lot of risk Database upgrade or data migration analysis Database upgrade or data migration will encounter a variety of circumstances, generally in the following situations: 1. under the same host condition, the low version database is upgraded to the higher version database. 2., the database has a new patch level, and new patches need to be installed. 3. change the system host, such as from windows to UNIX system, the database needs migration. 4., cross platform, cross database version of migration. The 5.32 bit database is upgraded to 64 for the database. 6. Standard Version of the database upgrade to the enterprise version of the database. Develop a detailed databa