Oracle数据库升级技术方案

合集下载

ORACLE数据库跨平台升级方案和实施

ORACLE数据库跨平台升级方案研究和实施12李灿召孙玉晶（1.中国移动通信集团吉林有限公司业务支撑中心吉林长春 130021；2.中国移动通信集团吉林有限公司长春分公司吉林长春 130000）摘要：随着关系型数据库的不断发展和新技术的引入，数据库作为各行业的数据核心和业务枢纽，数据量呈几何倍数膨胀，超TB级数据库不再鲜见。

数据量的膨胀导致后续的版本升级和系统迁移更难操作，结合实际操作经验，从时间、风险和应急策略等方面入手，详细阐述大数据量数据库跨平台升级方案的研究、选择和实施，在实际的操作过程中取得良好的效果，具有一定的参考价值。

关键词： ORACLE；数据库；升级；数据迁移中图分类号：TP311 文献标识码：A 文章编号：1671－7597（2012）1110109-012010年基于系统发展实际需要，决定对业务支撑系统数据 2 方案介绍库进行升级，核心CRM和BOSS核心数据库由9i升到10G，服务器“不停机”的跨平台数据库升级和数据迁移方案，通过中更换为IBM平台，存储更换为EMC，CRM和BOSS数据库作为业务支间数据库实现基础数据同步和迁移，规避了前期数据同步期间撑系统的数据中心和业务枢纽，其升级方案的选择尤为重要。

对正常生产的影响，中间数据库利用原系统BC备份搭建，服务CRM和BOSS数据库容量均超过10TB，实际数据量都在5TB左右，器和原系统的主机、数据库保持一致，配置比原系统低很多。

项目要求在完成新、旧系统切换的同时进行垃圾数据清理、分该方案采用数据分级模式组织实施，通过中间数据库实现历史布规划和权限优化。

数据（静态数据）和基础数据的准备，前期准备工作完成后通1 方案选择过SharePlex软件保持活跃数据的准实时同步，正式割接时待1.1 影响因素数据同步完成后即可实施割接，割接同时启用反向同步机制，确保升级失败回切时原库数据的准确性。

业务连续性挑战：业务支撑系统是24x7全天候运行的系统，宕机不仅意味着大量的收入损失，同时严重影响公司的服务形象。

数据库升级9i to 10g

数据库升级9i TO 10gR2目录一、升级步骤 (3)二、Oracle9i组件版本升级 (3)2.1、创建10gR2数据库HOME目录 (3)三、Oracle10.2.0.1软件安装 (7)3.1 Oraap2用户环境变量设置 (7)3.2安装Oracle10.2.0.1软件 (7)四、升级数据库9i到10.2.0.1 (10)4.1 检查oratab条目 (10)4.2 启动database upgrade assistant(DBUA) (10)五、安装Oracle10.2.0.5 patch (19)5.1 关闭数据库和监听 (19)5.2 安装Oracle10.2.0.5 patch (19)5.3升级数据库字典到10.2.0.5 (22)一、升级步骤1、当前Oracle软件版本为9.2.0.7，但是组件版本是9.2.0.1，先升级组件版本到9.2.0.72、组件升级后，安装Oracle10.2.0.1软件3、升级数据库版本9.2.0.7到10.2.0.14、版本升级完成后，测试组件版本是否升级成功，数据是否完整5、关闭10.2.0.1数据库，应用Oracle10.2.0.5path6、启动数据库，编译数据库字典7、编译完成后，打开数据库，测试二、Oracle9i组件版本升级2.1、创建10gR2数据库HOME目录su – oraap2mkdir /oracle/AP2/102_642.2、检查oracle inventory目录2.3 源库（9I）组件版本检查select COMP_NAME,VERSION,STATUS from dba_registry;COMP_NAME--------------------------------------------------------------------------------VERSION STATUS------------------------------ -----------Oracle9i Catalog Views9.2.0.1.0 VALIDOracle9i Packages and Types9.2.0.1.0 VALIDSQL>SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startup migrateORACLE instance started.Total System Global Area 5257289416 bytes Fixed Size 749256 bytes Variable Size 956301312 bytes Database Buffers 4294967296 bytes Redo Buffers 5271552 bytes Database mounted.Database opened.SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> @?/rdbms/admin/catpatch.sqlDOC> BEGIN CATPATCH.SQL */PL/SQL procedure successfully completed. Session altered.Session altered.8 rows deleted.1 row updated.Commit complete.4785 rows updated.。

oracle升级操作流程

数据库版本升级操作手册目录备份数据库 (3)升级Oracle软件 (3)修改ORACLE_HOME (12)升级实例 (13)手工使用脚本升级实例 (14)升级遇到问题的解决办法 (15)检查升级后的版本信息和无效对象 (16)附录 (17)本文用于指导oracle数据库由版本11。

2.0.1.0升级到版本11.2.0。

3.0升级步骤如下：➢备份数据库➢升级oracle 软件➢修改ORACLE_HOME➢升级实例➢检查升级后的版本信息和无效对象备份数据库由于oracle升级存在一定风险,所以在升级前一定要对已有数据进行备份。

1、停掉所有使用数据库的相关程序,以及数据库。

2、对数据库文件进行冷备份.备份后的文件可转存到异机或在本地存放。

升级Oracle软件1、获取oracle升级软件p1*******_112030_Linux—x86—64_1of7.zip 及p1*******_112030_Linux—x86—64_2of7.zip。

2、将其上传到数据库服务器的/tmp/目录下并解压.unzip p1*******_112030_Linux-x86-64_1of7。

zipunzip p1*******_112030_Linux—x86—64_1of7.zip3、解压后,会在当前目录下生成一个database目录.4、切换到oracle用户,执行oracle升级脚本。

5、s u - oracle/tmp/database/runInstaller6、不需要进行任何更改，直接点击下一步。

7、选择跳过软件更新,点击下一步。

8、选择升级现有数据库，点击下一步。

9、语言选择简体中文和英语，点击下一步。

10、选择企业版,并点击下一步。

11、Oracle基目录无需更改,软件位置需要更改为新的位置，这样可以减少宕机时间，是oracle所推荐的方法。

如下图我们将软件安装位置选择为/home/oracle/oracle11g3，修改后，点击下一步。

oracle11g直接升级oracle19c操作手册

11. 准备工作1.1 备份现有数据库在进行任何升级操作之前，首先要备份现有的 Oracle 11g 数据库。

1.1.1全库备份：sh代码：rman target /RMAN> BACKUP DATABASE PLUS ARCHIVELOG;1.数据泵导出（可选）：sh代码：expdp system/password@<service_name> full=Y directory=<directory_name> dumpfile=full_backup.dmp logfile=full_backup.log1.2 检查兼容性确保现有的 Oracle 11g 数据库与 Oracle 19c 兼容。

1.运行预升级信息工具：下载并运行Oracle 提供的预升级信息工具（preupgrade.jar）。

sh代码：java -jar preupgrade.jar TERMINAL TEXT2.检查输出：根据工具输出的信息，解决所有兼容性问题。

1.3 环境准备确保目标服务器满足 Oracle 19c 的系统要求。

1.检查系统要求：•操作系统版本•内存•磁盘空间2.设置环境变量：sh代码：export ORACLE_HOME=/path/to/oracle19c_homeexport PATH=$ORACLE_HOME/bin:$PATH22. 安装 Oracle 19c 软件2.1 下载 Oracle 19c 软件从 Oracle 官方网站下载 Oracle 19c 安装包。

2.2 安装 Oracle 19c 软件1.解压安装包：sh代码：unzip LINUX.X64_193000_db_home.zip -d /path/to/oracle19c_home2.运行安装程序：sh代码：/path/to/oracle19c_home/runInstaller3.安装选项：•选择“安装数据库软件”。

医院信息系统ORACLE数据库升级解决方案

级。本文论述了数据库升级的整个过程，对其中的一些细节进行了说明。并
［关键词】医院信息系统；ＯＲＡＣＬＥ数据库；数据库升级［中图分类号】３１１２３ＴＰ１．３．［文献标志码】Ａ
、 ’
［文章编号】０７５０２０）７００２１０ —７１（０７０ —０３ —０
８１６工作于归档模式下，ａｌ８１６数据库安装在Ｄ：Ｏ— ．．，Ｏｒｃｅ．．＼
ｒｅｅ目录下。ａｌ
１３实现方法．
利用主服务器和备用服务器，先升级备用服务器，主服务器不动。如果升级成功，则将业务移到备用服务器上，然后再升级主服务器。如果不成功，则继续使用主服务器。升级数据选择
真对待和解决的。
Ｏｒｃｅ．．，ａｌ７３３工作于归档模式下，ａｌ７３３Ｏｒｃｅ．．数据库安装在
Ｄ：Ｏｒｎ＼ａｔ目录下。
升级后的软件环境为：ｉ２０ｅｖｒ（Ｐ）＋Ｏｒｃｅｗｎ００ＳｒｅＳ４ａｌ
升级数据库的方法有很多，对于医院数据库管理人员来说，需要根据医院的实际情况而定。我们对升级方法的要求：首先，对正常工作影响小，因升级而停服务的时间越短越好。其次，具有高度的安全性，保证不会造成数据丢失。所以，我们选择先升级备用服务器，ａａａｅＵｐｒｄｆＨｏｐｔｌＩｆｒａｉｎＳｓｅｏｕｉｎｆｒＯｔｂｓｇａｅｏｓｉａｎｏｍｔｏｙｔｍ

Oracle 11g R2 升级方案

Oracle 11g R2 升级方案一、版本升级路线Table 2-1 contains the required upgrade path for each release of Oracle Database. Use the upgrade path and the specified documentation to upgrade your database.Table 2-1 Upgrade Paths二、滚动升级Table 1-2 summarizes the various methods for performing rolling upgrades. Also, see Oracle Database High Availability Best Practices for help choosing a method to perform database upgrades.Table 1-2 Methods for Performing Rolling Upgrades三、升级方法Depending on the environment, there are several alternatives available when upgrading a database. This section discusses why a particular method would be chosen, lists considerations when using each method, and gives pointers to additional useful information.Database Upgrade Assistant (DBUA)The DBUA provides a graphical user interface (GUI) that guides a user through the in-place upgrade of a database. It is the recommended method for performing either a major release upgrade or patch release upgrade.The DBUA automates the upgrade process by performing all of the tasks that would otherwise need to be performed manually. It can be launched during installation of Oracle Database 11g Release 2 with the Oracle Universal Installer or it can be launched as a standalone tool at any time after installation is complete.The DBUA is a very useful tool, because it evaluates the current database and makes appropriate recommendations for configuration options such as tablespace sizes, cluster checks, initialization parameters, and Automatic Storage Management upgrades.DBUA is a good choice if the upgrade environment has the following characteristics: ∙Operating system remains the same (including upgrades in the same OS family, such as Windows XP to Windows Vista or Solaris 2.8 to Solaris 2.10)∙Graphical user interface is preferred over manual interface∙Real Application Clusters or Automatic Storage Management is installedo Much easier and less error prone than manual method – HIGHLY recommended!∙Existing database is at least 9.2.0.4 for Oracle Database 11g Release 1 and 9.2.0.8 for Oracle Database 11g Release 2Considerations for using DBUA:∙Databases must be on the same system (in-place upgrade where the new version of Oracle is installed on the same server as the existing version). The DBUA cannot upgrade a database remotely.For more information:∙Oracle Database Upgrade Guide 11g Release 2∙Oracle Database Upgrade Companion 11g Release 2∙Oracle Database 11g Upgrade page on OTN∙Complete Checklist to Upgrade to 11g Release 2 using DBUA (My Oracle Support Note 870814.1))Manual Upgrad eA manual upgrade consists of running SQL scripts and utilities from a command line to do an in-place upgrade of a database to the new Oracle Database 11g release. Although a manual upgrade gives finer control over the upgrade process, it is more susceptible to error if any of the upgrade steps are not followed or are performed out of order.Unlike the DBUA, the Pre-Upgrade information Tool (utlu111i.sql) that is shipped with the Oracle Database 11 software must be run manually to see what changes must be made to the target database. It performs checks on configuration options such as components, init parameters, and tablespace sizes.Manual upgrade is a good choice if the upgrade environment has the following characteristics: ∙Manual interface is preferred over graphical user interface∙Existing database is at least 9.2.0.4 for Oracle Database 11g Release 1 and 9.2.0.8 for Oracle Database 11g Release 2 (1 step upgrade). Manual upgrades can be done for databases before 9.2.0.x, but 2 steps are required versus 1. For example, if upgrading from 8.1.7.4, it is necessary to first upgrade to 10.2.0.x and then to 11.1 or 11.2. Considerations for manual upgrade:∙Cannot change operating system architectureFor more information:∙Oracle Database Upgrade Guide 11g Release 2∙Oracle Database Upgrade Companion 11g Release 2∙Oracle Database 11g Upgrade page on OTN∙Complete Checklist for Manual Upgrades to 11g Release 2 (My Oracle Support Note 837570.1))Oracl e Data Pump Export and Import / Original Export and ImportIn this method, the Export and Import utilities physically copy data from the current database to a new database. When upgrading from Oracle Database 10g or higher, Data PumpExport and Import are strongly recommended for improved performance and better manageability.Oracle Data Pump Export/Import and original Export/Import perform a full or partial export from the current database, followed by a full or partial import into a new Oracle Database 11g.In order to have two physical copies of the database, along with the dump file set, a significant amount of disk space may be required. However, the user has the flexibility (especially with Data Pump) to choose subsets of the database to export such as tablespaces, schemas, tables, and rows, leaving the original database unchanged. In addition, Data Pump Export/Import has two features that can help with this issue. First, Data Pump Import can be used in Network Mode, which allows the new Oracle database to be directly loaded across the network from the old database being upgraded. Thus, no intervening dump files are required. Second, when using Data Pump Export and Import in Oracle Database 11g, the imported data can be compressed with the Oracle Advanced Compression Option to improve performance (only when going from 11g Release 1 to Release 2 or for patch set upgrades from Oracle Database 11g onward).Data Pump Export/Import and original Export/Import do not change the existing database, which enables the database to remain available throughout the upgrade process. Data Pump Export and Import use Flashback technology to get a consistent view of the data. However, neither Data Pump Export/Import nor original Export/Import provide consistent snapshots by default.Because the current database can remain available, the existing production database can be kept available for read-only transactions while the new Oracle Database 11g database is being built at the same time by Data Pump Export/Import or original Export/Import. The current database can then be deleted once the upgraded system is determined to be fully functional.Note that Data Pump Export/Import is supported starting in Oracle Database 10g. When upgrading an Oracle database that is older than 10g, original Export and Import must be used. Data Pump Export/Import or Export/Import is a good choice if the upgrade environment has the following characteristics:∙Migration to different operating system architecture or hardware platform∙Source database is running on a version such as 8.0.3 or 8.1.6 that is not directly upgradable to the target version∙Side-by-side testing of the old and new versions of Oracle Database is needed (because an entirely new database is created)∙New database will be restructured (i.e. new tablespaces will be created and populated by imported data, or a new partitioning scheme will be implemented)Considerations for using Data Pump Export/Import or Export/Import:∙Downtime will be much longer than other methods, depending on size of the database(i.e. 10+ hours for large databases). This can be tested by running a test export into thefile system and then doubling or tripling the amount of time that would be required for the subsequent import.∙Additional disk space will be necessary to store both the export dump files and the new copy of the databaseFor more information:∙Oracle Database Upgrade Guide 11g Release 2∙Oracle Database Utilities 11g Release 2 (Part Number E10701-02)∙Oracle Database Upgrade Companion 11g Release 2∙Oracle Database 11g Upgrade web page on OTN∙Oracle Database Utilities web page on OTNOracl e Transportable TablespacesOracle Transportable Tablespaces (TTS) is an option for performing database upgrades in less than one hour for databases that have simple schemas and where the data files do not need to be transferred as part of the transport process (such as when the data files will be used in place, or when shared storage is available in a system migration).With this method, an empty 11g Release 2 database is created and data is moved from the existing database to the 11g Release 2 database. Metadata for tables and indices and the objects needed to support the tables and indices in the tablespaces is exported from the existing database and then imported into the new database using Data Pump Export/Import or original Export/Import. The majority of time taken for the upgrade is for the metadata export and import, and this is where there may be less than optimal performance.Transportable Tablespaces has been used effectively to reduce database upgrade time. However, because it was not originally designed as a database upgrade solution, it does not have the same level of automation as the DBUA. Consider whether the added testing time and complexity of using a TTS upgrade are worth the potential to reduce downtime during the upgrade.Starting with Oracle Database 10g, tablespaces can be moved across platforms. Many, but not all platforms are supported for cross platform tablespace transport. A cross-endian move involves an RMAN convert, but is a simple operation across platforms within the same endian group.Note that the time needed for the RMAN convert is essentially equivalent to the time needed for an RMAN backup of the database.Transportable Tablespaces is a good choice if the upgrade environment has the following characteristics:∙Downtime must be less than one hour∙Data files do not need to be transferred as part of the transport process∙Existing database’s object structure is not complexConsiderations when using Transportable Tablespaces:∙Metadata gets transported from the existing database to the new database and may increase upgrade time. If desired, a time estimate can be obtained by performing a metadata-only export on the source database.∙Higher level of skill is required for the database administratorFor more information:∙Oracle Database Administrator’s Guide 11g Release 2 (Part Number E10595-04)∙Database Upgrade Using Transportable Tablespaces: Oracle Database 11g Release 1 white paper∙Platform Migration Using Transportable Tablespaces: Oracle Database 11g Release 1white paper∙Platform Migration Using Transportable Database: Oracle Database 11g and 10g Release 2 white paperOracl e Data Guard SQL Apply (Logical Standby)Starting with Oracle Database 10 (10.1.0.3), Data Guard SQL Apply (logical standby) can be used to perform a database rolling upgrade with minimal downtime. The upgrade can be to a higher Oracle Database release or a later patch set. The overall downtime can be as little as the time it takes to perform a switchover.What is Oracle Data Guard? Oracle Data Guard provides the management, monitoring, and automation software infrastructure to create and maintain one or more standby databases to protect Oracle data from failures, disasters, errors, and data corruptions. There are two types of standby databases. A physical standby uses Redo Apply to maintain a block for block, exact replica of the primary database. A logical standby uses SQL Apply and contains the same logical information as the primary database, although the physical organization and structure of the data can be different. SQL Apply also enables rolling upgrades by allowing the synchronization of a standby database with a primary database that is using an earlier release of the Oracle Database.A database rolling upgrade entails first upgrading a logical standby database to a later Oracle release or patch set, and then allowing SQL Apply to re-synchronize the primary and standby databases. When the administrator is satisfied that the upgrade has been successful, the process is completed by using a Data Guard switchover operation to transition the standby to the primary role. The only downtime experienced by applications is the time needed to complete the switchover process and reconnect clients to the new primary database. The actual database upgrade is performed while applications continue to access the original production database.Beginning with Oracle Database 11g, Data Guard physical standby users can also benefit from rolling database upgrades by temporarily converting a physical standby to a transient logical standby database, enabling SQL Apply to synchronize the primary and standby databases while they operate at different Oracle releases or patch sets. The transient logical process is attractive because it can use existing physical standby databases and it only requires a single catalog upgrade to migrate both primary and standby databases to the new Oracle release. When the upgrade to process is complete, the configuration reverts to its original state of having a primary with a physical standby database.Oracle Data Guard SQL Apply is a good choice if the upgrade environment has the following characteristics:∙Oracle Data Guard SQL Apply is installed∙Minimal downtime is a requirement∙Current database is at least 10.1.0.3Considerations when using Oracle Data Guard SQL Apply:∙Operating systems must be the same∙Higher level of skill is required for the database administratorFor more information:∙Oracle Database Administrator’s Guide 11g Release 2∙Oracle Maximum Availability Architecture Best Practices web page on OTN∙Database Rolling Upgrade Using Data Guard SQL Apply – Oracle Database 11g and 10g R2 white paper∙Database Rolling Upgrade Using Physical Standby Databases and the Transient Logical Rolling Upgrade ProcessOnline Database Upgrad e with Oracle StreamsOracle Streams can be used to achieve little or no database downtime during database or patchset upgrades. A database can be migrated to different platform, for example Intel Solaris to Intel Linux, or to a different character set. A copy of the current database is upgraded using Oracle Streams to keep changes synchronized during the upgrade process. The only downtime that occurs is during the switch from the current database to the new database.Oracle Streams is a good choice if the upgrade environment has the following characteristics: ∙Operating systems are different∙Little or no downtime is a requirement∙Current database is at least 9.2Considerations when using Oracle Streams:∙Performance restrictions may occur in an OLTP environment if the copy of the database does not keep up with existing database∙Significant amount of expertise is required by the database administratorFor more information:∙Oracle Database Administrator’s Guide 11g Release 2∙Oracle Streams Concepts and Administration 11g Release 2, Appendix D (Part Number E10704-02)结论Database Upgrade Assistant is the preferred method for upgrading a database to Oracle Database 11g Release 2. However, it is not always possible to use the DBUA, and in such situations there are other options available.Choosing the appropriate upgrade method depends on the environment, amount of downtime that is acceptable, and tolerance for complexity of the database administrator doing the upgrade. It is important for the database administrator to understand the various upgrade methods and choose the one that best suits business requirements.四、方法比较五、方法建议根据实际情况，涉及到服务器操作系统更换版本，数据库版本升级，较短停机时间。

Oracle12c升级指南

Oracle12c升级指南1. 概述升级路线图从18c开始，如果想要直接升级到Oracle 18c，对于源库版本要求越来越高了。

Oracle已经彻底放弃了Oracle 11.2.0.3之前版本直接升级到18c。

具体升级路线，请查看下表当前版本号说明12.2.0.1,12.1.0.1,12.1.0.211.2.0.3, 11.2.0.4支持直接升级到18c11.2.0.1, 11.2.0.211.1.0.6, 11.1.0.710.2.0.2,10.2.0.3, 10.2.0.4 和10.2.0.510.1.0.59.2.0.8及更早版本不支持直接升级到18c.解决方法：1）只能先升级到支持直接升级到18c的中间版本，然后再次升级到18c2）使用数据泵直接将数据迁移到新版本数据库中源库过度版本目标数据库版本11.2.0.1/11.2.0.2-->11.2.0.3/11.2.0.4-->18.x11.1.0.6/11.1.0.7-->11.2.0.3/11.2.0.4-->18.x10.2.0.2, 10.2.0.3, 10.2.0.4, 10.2.0.5-->11.2.0.3/11.2.0.4/12.1.0.1/12.1.0.2-->18.x10.1.0.5-->11.2.0.3/11.2.0.4/12.1.0.1/12.1.0.2-->18.x9.2.0.8 or earlier-->11.2.0.3/11.2.0.4-->18.xOracle版本发布与支持时间参考文档Oracle 12cR1 Upgrade Companion (文档 ID 1462240.1)Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1) (文档 ID 1503653.1)Complete Checklist for Upgrading to Oracle Database 12c Release 1 using DBUA (文档 ID 1516557.1)Release Schedule of Current Database Releases (文档 ID 742060.1)How to Upgrade to Oracle Database 12c Release1 (12.1.0) and Known Issues (文档 ID 2085705.1)Master Note For Oracle Database 12c Release 1 (12.1) Database/Client Installation/Upgrade/Migration Standalone Environment (Non-RAC) (文档 ID 1520299.1) Database Server Upgrade/Downgrade Compatibility Matrix (文档 ID 551141.1)2. 10gR2、11gR1或11gR2升级12cR12.1. 操作系统要求Oracle Database (RDBMS) on Unix AIX,HP-UX,Linux,Solaris and MS Windows Operating Systems Installation and Configuration Requirements Quick Reference (12.1) (文档 ID 1587357.1)Document 1517948.1 Requirements for Installing Oracle Database 12.1 on Solaris 10 SPARCDocument 1525614.1 Requirements for Installing Oracle Database 12.1 on Solaris 11 SPARCDocument 1529433.1 Requirements for Installing Oracle Database 12.1 on RHEL5 or OL5 64-bit (x86-64)Document 1529864.1 Requirements for Installing Oracle Database 12.1 on RHEL6 or OL6 64-bit (x86-64)Document 1961997.1 Requirements for Installing Oracle Database 12.1 on RHEL7 or OL7 64-bit (x86-64)Document 1519770.1 Requirements for Installing Oracle Database 12.1 64-bit (AMD64/EM64T) on SLES 11Document 1961277.1 The Oracle Database 12c Install Options and the Installed Components2.2. 12.1.0.2重要的补丁包为了避免升级过程中出现问题，安装12.1.0.2版本后打上如下补丁包，避免相关问题20369415、215507772.3. 源库要求和建议1)版本要求根据升级要求，在原数据库上升级，对原数据库的版本要求如下：10gR2不能低于10.2.0.511gR1不能低于11.1.0.711gR2不能低于11.2.0.2PSU补丁：Quick Reference to Patch Numbers for Database/GI PSU, SPU(CPU), Bundle Patches and Patchsets (文档 ID 1454618.1)2)升级前建议做个备份 3)确保升级前Oracle系统对象和组件全部是VALID状态。

oracle升级方案

Oracle升级方案1. 简介Oracle是一种强大的关系数据库管理系统（RDBMS），被广泛用于企业级应用程序。

随着时间的推移，Oracle不断推出新的版本和升级，以提供更好的性能、功能和安全性。

本文档旨在介绍Oracle数据库升级的一般步骤和最佳实践。

2. 升级前的准备工作在进行Oracle数据库升级之前，需要进行一些准备工作，以确保顺利完成升级过程，并最大程度地减少潜在的风险和中断。

以下是一些准备工作的关键部分：2.1. 确定升级类型首先，需要确定要执行的Oracle升级类型。

可以是小版本的升级，例如从Oracle 11.2.0.2到11.2.0.4，也可以是大版本的升级，例如从Oracle 11g到Oracle 12c。

2.2. 评估硬件和软件要求在选择升级版本之前，需要评估现有硬件和软件的要求。

必须确保新版本的Oracle数据库可以在现有硬件上运行，并且与现有的操作系统和其他应用程序兼容。

2.3. 创建备份在进行任何数据库升级之前，最重要的一步是创建完整的数据库备份。

这样，在升级过程中出现任何问题或数据丢失的风险时，可以恢复到原始状态。

2.4. 检查数据库健康状况在升级之前，建议进行数据库的健康检查和性能评估。

可以使用Oracle提供的工具，例如Enterprise Manager或AWR报告，来评估数据库的性能和稳定性。

2.5. 计划测试环境在进行升级之前，应该创建一个测试环境，用于模拟实际的升级流程。

可以将生产环境的数据库和应用程序复制到测试环境，以便测试升级过程和验证应用程序的兼容性。

3. 升级过程一旦完成了准备工作，就可以开始实施Oracle数据库的升级。

下面是一个一般的升级过程：3.1. 升级前检查在进行升级之前，需要执行一些先决条件检查，以确保满足升级的要求。

这些检查通常涉及硬件和软件的一些要求，并可以使用Oracle提供的预升级检查工具来执行。

3.2. 安装升级程序安装升级程序是升级过程的下一步。

ORACLE8.1.7数据库升级11.2g解决方案

ORACLE8.1.7数据库升级11.2g解决方案摘要：该文从备份oracle 8.1.7数据库、安装oracle 11.2g数据库几点建议、导入数据、升级后处理四个方面详细地说明了如何将oracle 8.1.7升级至 oracle 11.2g，按照所写每一方面的操作完成医院oracle数据库平台升级。

解决了服务器负载过重及数据库并发数过多导致客户端无法连接的难题。

关键词：数据库；备份；恢复；卸载；升级；oracle中图分类号：tp391 文献标识码：a 文章编号：1009-3044（2013）11-2520-02我院从2000年开始使用“军卫一号”信息系统，随着医院业务量的逐渐扩大，先后完成了lis、pacs、门诊医生站、重症icu、手术麻醉、医保接口、合理用药等系统的建设。

现有数据库是oracle8.1.7，应用子系统120多个，工作站近600台，访问数据库高峰时的用户连接数最高达到了1150多。

通过减少每个连接分配的stack内存数、设置数据库为共享服务器模式，加服务器内存等方法，缓解了部分客户端连接到oracle数据库的问题，但仍有一部分客户端系统登陆连接不上数据库，尤其在做统计数据上报时，数据库系统性能受到了严重影响，科室业务系统操作明显缓慢。

经过多方面原因排查及资料查询，发现造成这种情况的根本原因就是我院his数据库环境是操作系统32位windows2003 server和32位数据库oracle 8.1.7，受32位系统内存寻址空间的限制，操作系统内存使用最多只能达到4gb，oracle数据库内存使用不超过2gb，因此，最有效的解决办法就是更换为64位操作系统和64位oracle数据库平台。

基于以上原因，我院解决方案是购置最新配置的64位多核处理器服务器、安装64位windows2008 server r2操作系统和把数据库由32位的oracle8.1.7升级到64位的oracle11.2g。

oracle版本升级步骤

-- Oracle 10.2.0.1 升级到 10.2.0.4--*********************************数据库升级并不难，只要遵循其步骤，一般问题不大。

下面描述基于Linux(Oracle Linux 5.4/2.6.18-164.el5PAE)平台下Oracle 10.2.0.1 升级到10.2.0.4的步骤。

注：在9i以前，无论升级/降级，数据库都是startup migrate10g后增加了upgrade参数，升级可直接用startup upgrade，降级仍是startup migrate一、单实例升级先决条件：1.表空间需求确保system表空间至少有10M空间可用，下面给出查询语句col "tablespace_name" for a20col "Usage_Percent" for a10SELECT upper(f.tablespace_name) "tablespace_name",d.tot_grootte_mb "tablespace_size(M)",d.tot_grootte_mb - f.total_bytes "used_size(M)",to_char(round((d.tot_grootte_mb - f.total_bytes) / d.tot_grootte_mb * 100,2),'990.99') "Usage_Percent",f.total_bytes "free_size(M)"FROM (SELECT tablespace_name,round(SUM(bytes) / 1024 / 1024) total_bytes,round(MAX(bytes) / (1024 * 1024), 2) max_bytesFROM sys.dba_free_spaceGROUP BY tablespace_name) f,(SELECT dd.tablespace_name,round(SUM(bytes) / 1024 / 1024) tot_grootte_mbFROM sys.dba_data_files ddGROUP BY dd.tablespace_name) dWHERE d.tablespace_name = f.tablespace_nameORDER BY2DESC;2.系统参数：确保参数SHARED_POOL_SIZE 和 JAVA_POOL_SIZE大于150MB以上，为加快升级速度，在系统内存可用的情况下，可临时调大这２个参数SQL> SHOW PARAMETER SHARED_POOL_SIZESQL> SHOW PARAMETER JAVA_POOL_SIZESQL> ALTER SYSTEM SET SHARED_POOL_SIZE='200M'SCOPE=spfile;SQL> ALTER SYSTEM SET JAVA_POOL_SIZE='200M'SCOPE=spfile;二、实施升级1.关闭需要升级的实例停止实例SQL> shutdown immediate停止与该实例相关的所有后台进程lsnrctl emctl2.备份Oracle Home 目录及数据库tar -cvf $ORACLE_BASE /orabak/ --确保Oracle相关的所有配置都位于$ORACLE_BASE目录，如监听等cp *.dbf con*.ora redo*.log /orabak/ --对数据库实施冷备3.升级软件 (上传解压升级包后，进入解压目录DISK1中执行)./runIstanller -->oracle 账户root.sh -->root 账户4.更新数据字典SQL> startup upgradeSQL> spool patch.logSQL> @?/rdbms/admin/catupgrd.sql --注9i 使用catpatch.sql（此处执行时间较长）SQL> spool off5.重编译失效对象：sql>shutdown immediatesql>startupSQL>@?/rdbms/admin/utlrp.sql6.升级后的检测SQL> COL COMP_NAME FOR A50SQL> COL VERSION FOR A12SQL> COL STATUS FOR A12SQL>select comp_name,version,status from sys.dba_registry;检查组件的升级情况SQL>select * from utl_recomp_errors;7.修改兼容性参数SQL> alter system set compatible='10.2.0.4.0'scope=spfile;8.重新启动数据库:SQL> SHUTDOWNSQL> STARTUP9.如果使用了恢复目录，则执行下面的命令$ rman catalog username/password@aliasRMAN> UPGRADE CATALOG;10.升级回退：SQL> STARTUP DOWNGRADESQL> SPOOL downgrade.logSQL> @catdwgrd.sql（10.2.10运行的是这个，而10.1降级用的是d92000.sql，即dold_release.sql）Sql>spool offSql>shutdown immediate12.检查升级后的情况SQL> COL COMP_NAME FOR A50SQL> COL VERSION FOR A12SQL> COL STATUS FOR A12SQL> select comp_name,version,status from sys.dba_registry;COMP_NAME VERSION STATUS ---------------------------------------- -----------------------------------------Oracle Database Catalog Views 10.2.0.4.0 VALID Oracle Database Packages and Types10.2.0.4.0 VALID Oracle Workspace Manager 10.2.0.4.3 VALID JServer JAVA Virtual Machine 10.2.0.4.0 VALID Oracle XDK 10.2.0.4.0 VALID Oracle Database Java Packages10.2.0.4.0 VALID Oracle Expression Filter10.2.0.4.0 VALID Oracle Data Mining10.2.0.4.0 VALID Oracle Text 10.2.0.4.0 VALID Oracle XML Database10.2.0.4.0 VALID Oracle Rule Manager 10.2.0.4.0 VALIDCOMP_NAME VERSION STATUS ---------------------------------------- -----------------------------------------Oracle interMedia 10.2.0.4.0 VALIDOLAP Analytic Workspace 10.2.0.4.0 VALID Oracle OLAP API 10.2.0.4.0 VALID OLAP Catalog 10.2.0.4.0 VALID Spatial 10.2.0.4.0 VALID Oracle Enterprise Manager 10.2.0.4.0 VALID17rows selected.SQL> select * from utl_recomp_errors;no rows selected。

oracle数据库升级迁移方案

oracle数据库升级迁移方案
一、前期准备
（1）制定升级/迁移的项目计划，确定升级/迁移的内容，规划整体的计划，记录实施需要的资源；
（2）收集升级/迁移前的环境，包括数据库版本，物理机，操作系统版本，存储情况及相关参数；
（3）收集升级/迁移后的环境，并确认配置参数，确定新的数据库版本和物理机；
（4）确定迁移的对象、数据量及时间，根据实施过程需要，分析应用影响，制定迁移方案，准备迁移脚本；
（5）备份升级/迁移前的数据库，确认备份文件的完整性；
（7）安装升级/迁移新版本的数据库，检查系统参数，检查新数据库服务器内存，cpu，硬盘空间等；
（8）组织升级/迁移前的会议，确定安全措施，监控及备份等；
（9）获取外部技术支持服务；
二、安装升级
（1）安装新版本的数据库，根据要求安装所需的数据库软件；
（2）检查系统配置，查看本地缓冲池大小；
（3）连接到升级/迁移的服务器，检查新安装的版本是否正确；
（4）确保最新补丁被正确安装；。

oracle11g数据库升级数据库升级

oracle11g数据库升级数据库升级Oracle对⾃⼰产品也⼀样，对于⾃⼰的产品在不同的时期，⽀持的强度是不⼀样的。

⼤体分来，⽀持的强度分为三个级别：Premier Support（最⾼优先级的⽀持）,Extended Support（中等优先级的⽀持）,Sustaining Support（最低优先级的⽀持）1.从产品发布为期5年的标准⽀持服务期-Premier support2.随后为期3年的延展⽀持服务期---------extended support3.接下来进⼊持久⽀持服务期--------------sustaining support不过根据不同的周期划分，Oracle的⽀持费⽤将会不同，在延展服务器内，第⼀年将会加收10%的费⽤提供⽀持，第⼆年加收20%的费⽤提供⽀持，第三年也是加收20%的费⽤提供⽀持。

Oracle11g的推出，oracle的升级成为必然。

升级包括软件的升级和数据库的升级两部分。

升级路线图wKiom1RwrmjSXODJAAITOSDSG4c601.jpg⼤概的升级步骤：（1）备份数据库（2）运⾏patchset，升级oracle 软件（3）准备新的ORACLE_HOME（4）运⾏dbua 或者脚本升级实例（5）检查升级后的版本信息和⽆效对象升级补丁包选择Metalink⽂档id：1922396.1会更新需要的补丁号wKioL1RwrxricNIJAAOWwmqw9J4760.jpg升级⽅法选择关于⽅法有很多，每种有各⾃的特点，根据特点选择合适的升级⽅式。

wKiom1RwrtewdeArAAQ_nAkHjZs922.jpgwKioL1Rwr5nSrTalAAJMXvvLJe0792.jpg可以选择参考⽂档id 1674333.1和1602485.1分别是9i和11g升级到最新的11gR2wKiom1Rwr2fB0BrVAASB_rjEEMs949.jpg第 1 步======下载 11.2.0.2 或更⾼版本的 RDBMS 软件。

Oracle升级到10.2.0.5-PSU9操作步骤

Oracle升级到10.2.0.5PSU9操作步骤说明: 在升级前有些必备的工作,没有列入工作步骤：（1）通过metalink下载相应的补丁；（2）系统是否使用了其他oracle产品，若有，请仔细阅读升级包的readme文件（3）本文档可以用于单机、RAC环境的升级0. 复核准备项1、查看数据库版本SQL>select * from v$version;2、查看组件有效性（显示值为VALID，则成功完成升级）SQL>select comp_id,comp_name,version,status,modified fromsys.dba_registry;3. 记录升级前oracle文件结构等信息：SQL>select name from v$datafile;4. Update Oracle Time Zone DefinitionsActions for the DSTv4 update in the 10.2.0.5 patchset [ID 1086400.1]SQL>select * from v$timezone_file（若version=4无update动作，否则在PSR中有升级）----补丁下载、升级终端准备未列入1.Back Up database一般情况下rman备份，也可EXP备份。

2.备份ocr和vote disk3.Stopping All Processes滚动升级关闭一个节点所有进程，非滚动升级关闭所有进程4.Back Up the System$ORACLE_BASE，主要包括(db和crs安装文件/oraInventory文件)5.升级crs软件执行下面命令# CRS_home/bin/crsctl stop crs# CRS_home/install/root102.sh选择图形界面对Linux,开启vncserver服务即可对AIX,修改oracle用户的.profile文件,将DISPLAY指向升级客户端，比如172.18.0.75:0.0，然后在HOST下执行：Xhost +，升级客户端用XManager的Xbrowser即可登录执行./runInstaller选择crs目录6.升级db软件关闭crs和db所有进程(步骤同4) 执行./runInstaller选择db目录执行下面命令# ORACLE_HOME/root.sh7.升级数据库7.1)检查数据库升级需要满足条件,对存在不合适之处,进行修正How to Downlo ad and Run Oracle’s Database Pre-Upgrade Utility [ID 884522.1]7.2)启动监听srvctl start listener -n node7.3)升级数据库8.修改相关目录权限：所有节点,oracle用户# ORACLE_HOME/install/changePerm.sh9. 升级补丁6880880将p6880880_102000_XXXXX-64.zip 复制到$ORACLE_HOME，解压即可# upzip p6880880_102000_XXXXX-64.zip运行opatch程序检查版本号，原为10.2.0.4.9，升级后为10.2.0.5.1 10. 升级补丁PSU9（14275629）滚动升级关闭一个节点所有进程，非滚动升级关闭所有进程10.1）将补丁p1*******文件上传、解压，并赋予用户目录权限10.2）是RAC的，停节点一应用，停实例srvctl stop nodeapps -n cjdb3srvctl stop instance -d cjcxdb -i cjcxdb110.3）在节点一的14275629目录下$ORACLE_HOME/OPatch/optach apply10.4）是RAC的，中间会提示升级远程节点cjdb4，这时停节点二的应用和实例srvctl stop nodeapps -n cjdb4srvctl stop instance -d cjcxdb -i cjcxdb2直到出现“OPatch succeeded.” ORACLE程序软件暂且更新完成。

oracle数据库升级迁移实施方案

数据库系统和网络存储系统工程数据库迁移实施方案. v .文档控制文档修订记录审阅分发第一章文档介绍31.1背景31.2目标4第二章系统硬件选型42.1存储设备42.1.1 设备选型42.1.2 设备功能及实现42.2效劳器设备52.1.1 数据库效劳器5第三章系统安装73.1主机系统安装73.2配置SAN网络、磁盘阵列83.3配置HACMP83.4安装数据库软件9. v .第四章数据移植104.1移植准备工作104.2移植过程114.3系统检查12数据库检查12导入后系统需要完成的工作12应用检查134.4系统回退13第五章应用迁移13第六章新系统上线后的工作13第七章工作界面和工作容14第八章实施方案15：错误!未定义书签。

1.设备、软件验收交付记录错误!未定义书签。

2.操作系统安装错误!未定义书签。

3.操作系统镜像错误!未定义书签。

4.设备配置清单(需确认)错误!未定义书签。

4.1 IBM p570效劳器错误!未定义书签。

4.2 光纤交换机配置错误!未定义书签。

第一章文档介绍1.1背景HP公司全面转向X86芯片，使用PA-RISC芯片的HP 9000效劳器现已停产，虽然Oracle R12已经可以支持Itanium平台上的HP-UX，但某电厂应用系统目前是VXX.X.XX，而某应用软件VXX版本目前尚不能运行于Itanium平台,故准备将系统迁移至新硬件平台(IBM power处理器)。

本次工程的主要目标是对包括如下几点：1) 存储设备及小型机设备的选购采购一台新磁盘阵列提供效劳，替换过去的旧存储设备，磁盘按现有存储容量预期的1.3至1.5倍配置, (RAID10或RAID5提供冗余保护，热备盘提供磁盘的在线. v .替换)，空间考虑为_T〔为以后的扩容考虑需要，最大支持在_T〕,如可能涉及到系统日后的扩容、容灾及测试空间需求，可对存储适当增加扩展柜来扩大容量。

2)系统硬件规划及配置当前硬件系统按应用规划要求划分LPAR分区，并基于两台效劳器分区之间实现集群配置。

Oracle数据库升级技术方案

Oracle数据库升级技术方案Oracle Database Upgrade Support目录一说明 (3)二前期准备工作 (4)2.1系统检查 (4)2.2操作系统补丁包检查 (5)2.3系统组件检查 (5)2.4无效对象检查 (5)2.5 temp文件检查 (6)2.6 SYS和SYSTEM重复对象检查 (6)2.7配置闪回操作 (7)2.8前期11.2.0.3软件安装 (7)三创建回退方案 (7)3.1关闭数据库，停监听，停dbconsole 停容灾 (7)3.2 创建闪回点 (7)3.3备份控制文件和redo (8)四数据库升级前检查 (8)五数据库升级 (8)六升级结束后数据库检查 (9)七升级失败的回退措施 (9)7.1重定向10g目录 (9)7.2闪回数据库 (10)7.3 dd还原redo和控制文件 (10)7.4重建控制文件 (10)7.5查看Tempfile (11)一说明数据库为10g单机环境，目标升级为11g环境，操作系统为5，实例名称：zhcj 综合采集IP：130.36.6.8二前期准备工作2.1系统检查针对zhcj数据库进行基本的操作系统检查，包括系统配置，版本，操作系统内存，交换分区，tmp 空间，必要的操作系统包检查，无效对象检查。

包检查：bos.adt.basebos.adt.libbos.adt.libmbos.perf.libperfstat 5.3.9.0 or laterbos.perf.perfstatbos.perf.proctoolsxlC.aix50.rte.10.1.0.0 or latergpfs.base 3.2.1.8 or laterP570A_ZHCJ:/# lslpp -l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.libperfstat bos.perf.perfstat bos.perf.proctools xlC.aix50.rte gpfs.base <Fileset Level State Description----------------------------------------------------------------------------Path: /usr/lib/objreposbos.adt.base 5.3.9.0 COMMITTED Base Application DevelopmentToolkitbos.adt.lib 5.3.9.0 COMMITTED Base Application DevelopmentLibrariesbos.adt.libm 5.3.9.0 COMMITTED Base Application DevelopmentMath Librarybos.perf.libperfstat 5.3.9.0 COMMITTED Performance Statistics LibraryInterfacebos.perf.perfstat 5.3.9.0 COMMITTED Performance StatisticsInterfacebos.perf.proctools 5.3.9.0 COMMITTED Proc Filesystem ToolsxlC.aix50.rte 10.1.0.0 COMMITTED XL C/C++ Runtime for AIX 5.3Path: /etc/objreposbos.perf.libperfstat 5.3.9.0 COMMITTED Performance Statistics LibraryInterfacebos.perf.perfstat 5.3.9.0 COMMITTED Performance StatisticsInterfacelslpp: Fileset gpfs.base not installed.2.2操作系统补丁包检查以下补丁包需要安装：•IZ42940•IZ49516•IZ52331•P570A_ZHCJ:/#instfix -i -k "IZ42940 IZ49516 IZ52331"以上补丁包需要安装2.3系统组件检查SQL> select comp_name,version,status from dba_registry;COMP_NAME VERSION STATUS---------------------------------- --------- -----------Oracle interMedia 10.2.0.4.0 VALIDOracle Enterprise Manager 10.2.0.4.0 VALIDOracle XML Database 10.2.0.4.0 VALIDOracle Text 10.2.0.4.0 VALIDOracle Expression Filter 10.2.0.4.0 VALIDOracle Rules Manager 10.2.0.4.0 VALIDOracle Workspace Manager 10.2.0.4.3 VALIDOracle Data Mining 10.2.0.4.0 VALIDOracle Database Catalog Views 10.2.0.4.0 VALIDOracle Database Packages and Types 10.2.0.4.0 INVALIDJServer JAVA Virtual Machine 10.2.0.4.0 VALIDOracle XDK 10.2.0.4.0 VALIDOracle Database Java Packages 10.2.0.4.0 VALID相关组件失效，检查由于sys用户下的包失效造成：SQL> select object_name,status from dba_objects where owner='SYS' and status<>'VALID';OBJECT_NAME STATUS--------------------------- ----------DBMS_SWRF_REPORT_INTERNAL INVALID升级前需要对该包进行重新编译修复该组件2.4无效对象检查sqlplus “/as sysdba”spool invald.lstselect owner,object_name,object_type,status from dba_objects where status<>'VALID';SQL> select count(*),status from dba_objects group by status;COUNT(*) STATUS---------- -------52311 VALID358 INVALIDcreate table invalid_object_20120515 as select * from dba_objects wherestatus<>’VALID’;2.5 temp文件检查select tablespace_name , file_name,bytes/1024/1024 ,status from dba_temp_files order by 1TABLESPACE_NAME FILE_NAME BYTES/1024/1024 STATUS--------------- ------------------------ --------------- ---------TEMP /dev/rzhcj01_4g_003 4095 AVAILABLETEMP /dev/rzhcj02_4g_079 4095 AVAILABLETEMP /dev/rzhcj01_4g_127 4095 AVAILABLETEMP /dev/rzhcj01_4g_191 4095 AVAILABLETEMP /dev/rzhcj02_4g_084 4095 AVAILABLETEMP /dev/rzhcj02_4g_080 4095 AVAILABLETEMP /dev/rzhcj02_4g_081 4095 AVAILABLETEMP /dev/rzhcj02_4g_082 4095 AVAILABLETEMP /dev/rzhcj02_4g_083 4095 AVAILABLETEMP /dev/rzhcj01_4g_192 4095 AVAILABLE2.6 SYS和SYSTEM重复对象检查SQL> select object_name, object_type from dba_objects where (object_name,object_type) in (select object_name,object_type from dba_objects where owner = 'SYS') and owner = 'SYSTEM';OBJECT_NAME OBJECT_TYPE----------------------- -------------------AQ$_SCHEDULES TABLEAQ$_SCHEDULES_PRIMARY INDEXDBMS_REPCAT_AUTH PACKAGEDBMS_REPCAT_AUTH PACKAGE BODY以上为正常并且允许重复的对象。

Oracle RAC数据库升级过程

ORDER BY 2 DESC;
参数：
1、确保参数SHARED_POOL_SIZE 和 JAVA_POOL_SIZE至少为150M大小，保证catpatch.sql升级脚本正常运行；
SQL> SHOW PARAMETER SHARED_POOL_SIZE
down库：
shutdown immediate;
八、升级数据库
确保两个节点数据库都为关闭状态。
b、SQL> ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=spfile;
四、升级操作
备份完毕且正常，以xmanager登陆进行9208软件安装升级工作；
注意，连接第一个节点进行，一般升级从初始安装节点进行（这里假定安装9201 RAC时从节点一进行的安装）；
且第一节点安装完毕会自动rcp软件到另外节点进行升级工作。
五、备份9208软件
cd $ORACLE_BASE
ls -lrt -----确定oracle软件目录
tar -cvf /确定的软件备份路径/oracle9208bak.tar app (这个app为假定的oracle软件安装目录，根据实际情况进行tar备份)
. ./.profile
3、到patch存放目录开始进行patch升级工作
cd patch存放目录
cd *
opatch apply -local
b、创建初始化参数文件（如果$ORACLE_HOME/dbs下不存在这些文件的话，利用备份出来的参数文件信息）：
－－ echo $ORACLE_SID 确定SID名称
vi initSID.ora -------指向spfile 或者参数内容

1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。

2.7配置闪回操作检查数据库（主备）是否有配置闪回区域，如果没有，配置闪回区域和闪回路径，升级结束后取消设置闪回目录大小和闪回地址：Alter system set db_recovery_file_dest_size=15G scope=bothAlter system set db_recovery_file_dest=’/archlog/backup/flashback’; scope=both 2.8前期11.2.0.3软件安装安装最新的11.2.0.3数据库软件以及最新PSU补丁13696216 和13916709三创建回退方案3.1关闭数据库，停监听，停dbconsole 停容灾$ export ORACLE_SID=zhcj$ sqlplus / as sysdba$ shutdown immediateEmctl stop dbconsole3.2 创建闪回点$ export ORACLE_SID=zhcj$ sqlplus / as sysdbaSQl>startup mountSQL>create restore point upgrade_point guarantee flashback database;3.3备份控制文件和redo2．备份redo和controlfile查找reodo文件：select group#,member from v$logfile;检查对应VG是否具有4K偏移量：$ dbfsize rzhcj01_4g_005Database file: rzhcj01_4g_005Database file type: raw deviceDatabase file size: 524160 8192 byte blocks以上说明lv上有4K偏移量通过dd做备份(前期检查VG发现对应具有4K偏移量)：dd if=/dev/rzhcj01_1g_002 of=/archlog/backup/bak/rzhcj01_1g_002.bak bs=4096 skip=1 dd if=/dev/rzhcj02_1g_002 of=/archlog/backup/bak/rzhcj02_1g_002.bak bs=4096 skip=1 dd if=/dev/rzhcj01_1g_003 of=/archlog/backup/bak/rzhcj01_1g_003.bak bs=4096 skip=1 dd if=/dev/rzhcj02_1g_003 of=/archlog/backup/bak/rzhcj02_1g_003.bak bs=4096 skip=1 dd if=/dev/rzhcj01_1g_004 of=/archlog/backup/bak/rzhcj01_1g_004.bak bs=4096 skip=1 dd if=/dev/rzhcj02_1g_004 of=/archlog/backup/bak/rzhcj02_1g_004.bak bs=4096 skip=1 控制文件：dd if=/dev/rzhcj01_1g_001 of=/archlog/backup/bak/rzhcj01_1g_001.bak bs=4096 skip=1 dd if=/dev/rzhcj02_1g_001 of=/archlog/backup/bak/rzhcj02_1g_001.bak bs=4096 skip=1四数据库升级前检查拷贝11g$ORACLE_HOME/rdbms/admin/utlu112i.sql 至/tmp/upgrade运行该脚本，检测升级环境sqlplus '/as sysdba'SQL> spool Database_Info.logSQL> @ utlu112i.sql。