探索Oracle之数据库升级二
11.2.0.3升级到11.2.0.4完整步骤
说明：
这篇文章主要是记录下单实例环境下Oracle 11.2.0.1升级到11.2.0.3的过程，当然RAC的升级是会有所不同。但是他们每个版本之间升级步骤都是差不多的，先升级Database Software，再升级Oracle Instance。
Oracle 11.2.0.4的Patchset No:19852360下载需要有Oracle Support才可以。
Patchset包含有7个文件，关于这七个文件的作用，详见如下链接：
我们升级Database，只需要其中的第一个和第二文件即可。将2个文件解压缩后就可以执行升级操作了。
升级前准备：
1、查看数据库和操作系统相关信息:
[root@db01 ~]# uname -a Linux db01 2.6.18-308.el5 #1SMP Fri Jan 27 17:17:51 EST 2012 x86_64 x86_64 x86_64 GNU/Linux [root@db01 ~]# lsb_release-a LSB Version: :core-4.0-amd64:core-4.0-ia32:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-ia32:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-ia32:printing-4.0-noarch Distributor ID:RedHatEnterpriseServer Description: Red Hat Enterprise Linux Server release 5.8(Tikanga) Release: 5.8 Codename: Tikanga [root@db01 ~]# su - oracle-c "sqlplus / as sysdba"; SQL*Plus: Release 11.2.0.3.0Production on Fri Oct 3 21:32:02 2014 Copyright (c) 1982, 2011,Oracle. All rights reserved. Connected to: Oracle Database 11gEnterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP,Data Mining and Real Application Testing options SQL> select name fromv$database; NAME --------- WOO SQL>
2、备份数据库
[oracle@db01 ~]$ rman target/ Recovery Manager: Release11.2.0.3.0 - Production on Fri Oct 3 21:43:04 2014 Copyright (c) 1982, 2011,Oracle and/or its affiliates. All rightsreserved. connected to targetdatabase: WOO (DBID=4199461782) RMAN> backup databaseplus archivelog delete input format '/DBBackup/Phycal/full_%U.bak'; Starting backup at 03-OCT-14 current log archived using target databasecontrol file instead of recovery catalog allocated channel:ORA_DISK_1 channel ORA_DISK_1: SID=149device type=DISK channel ORA_DISK_1: startingarchived log backup set channel ORA_DISK_1:specifying archived log(s) in backup set input archived log thread=1sequence=15 RECID=1 STAMP=860017183 input archived log thread=1sequence=16 RECID=2 STAMP=860017184 input archived log thread=1sequence=17 RECID=3 STAMP=860017186 input archived log thread=1sequence=18 RECID=4 STAMP=860017186 input archived log thread=1sequence=19 RECID=5 STAMP=860017188 input archived log thread=1sequence=20 RECID=6 STAMP=860017387 channel ORA_DISK_1: startingpiece 1 at 03-OCT-14 channel ORA_DISK_1: finishedpiece 1 at 03-OCT-14 piecehandle=/DBBackup/Phycal/full_01pk5knb_1_1.bak tag=TAG20141003T214307comment=NONE channel ORA_DISK_1: backupset complete, elapsed time: 00:00:02 channel ORA_DISK_1: deletingarchived log(s) archived log filename=/DBSoft/fast_recovery_area/WOO/archivelog/2014_10_03/o1_mf_1_15_b2x9rz0z_.arcRECID=1 STAMP=860017183 archived log filename=/DBSoft/fast_recovery_area/WOO/archivelog/2014_10_03/o1_mf_1_16_b2x9s05l_.arcRECID=2 STAMP=860017184 archived log filename=/DBSoft/fast_recovery_area/WOO/archivelog/2014_10_03/o1_mf_1_17_b2x9s2nx_.arcRECID=3 STAMP=860017186 archived log filename=/DBSoft/fast_recovery_area/WOO/archivelog/2014_10_03/o1_mf_1_18_b2x9s2od_.arcRECID=4 STAMP=860017186 archived log filename=/DBSoft/fast_recovery_area/WOO/archivelog/2014_10_03/o1_mf_1_19_b2x9s4dr_.arcRECID=5 STAMP=860017188 archived log filename=/DBSoft/fast_recovery_area/WOO/archivelog/2014_10_03/o1_mf_1_20_b2x9