探索Oracle之数据库升级二11.2.0.3升级到11.2.0.4完整步骤 - 数据库编程

zbz2_.arcRECID=6 STAMP=860017387 Finished backup at 03-OCT-14 Starting backup at 03-OCT-14 using channel ORA_DISK_1 channel ORA_DISK_1: startingfull datafile backup set channel ORA_DISK_1:specifying datafile(s) in backup set input datafile filenumber=00001 name=/DBData/woo/system01.dbf input datafile filenumber=00002 name=/DBData/woo/sysaux01.dbf input datafile filenumber=00005 name=/DBData/woo/example01.dbf input datafile filenumber=00003 name=/DBData/woo/undotbs01.dbf input datafile filenumber=00004 name=/DBData/woo/users01.dbf channel ORA_DISK_1: startingpiece 1 at 03-OCT-14 channel ORA_DISK_1: finishedpiece 1 at 03-OCT-14 piecehandle=/DBSoft/fast_recovery_area/WOO/backupset/2014_10_03/o1_mf_nnndf_TAG20141003T214309_b2x9zfm5_.bkptag=TAG20141003T214309 comment=NONE channel ORA_DISK_1: backupset complete, elapsed time: 00:01:45 channel ORA_DISK_1: startingfull datafile backup set channel ORA_DISK_1:specifying datafile(s) in backup set including current controlfile in backup set including current SPFILE inbackup set channel ORA_DISK_1: startingpiece 1 at 03-OCT-14 channel ORA_DISK_1: finishedpiece 1 at 03-OCT-14 piecehandle=/DBSoft/fast_recovery_area/WOO/backupset/2014_10_03/o1_mf_ncsnf_TAG20141003T214309_b2xb2qlm_.bkptag=TAG20141003T214309 comment=NONE channel ORA_DISK_1: backupset complete, elapsed time: 00:00:01 Finished backup at 03-OCT-14 Starting backup at 03-OCT-14 current log archived using channel ORA_DISK_1 channel ORA_DISK_1: startingarchived log backup set channel ORA_DISK_1:specifying archived log(s) in backup set input archived log thread=1sequence=21 RECID=7 STAMP=860017496 channel ORA_DISK_1: startingpiece 1 at 03-OCT-14 channel ORA_DISK_1: finishedpiece 1 at 03-OCT-14 piecehandle=/DBBackup/Phycal/full_04pk5kqo_1_1.bak tag=TAG20141003T214456comment=NONE channel ORA_DISK_1: backupset complete, elapsed time: 00:00:01 channel ORA_DISK_1: deletingarchived log(s) archived log filename=/DBSoft/fast_recovery_area/WOO/archivelog/2014_10_03/o1_mf_1_21_b2xb2rsf_.arcRECID=7 STAMP=860017496 Finished backup at 03-OCT-14 RMAN>

3、停止数据库

###停止数据库

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

###停止监听

SQL> host lsnrctl stop

 
LSNRCTL for Linux: Version11.2.0.3.0 - Production on 04-OCT-2014 01:39:26

 
Copyright (c) 1991, 2011,Oracle.  All rights reserved.
Connecting to(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The command completedsuccessfully

###停止EM

SQL> host emctl stopdbconsole

Oracle Enterprise Manager11g Database Control Release 11.2.0.3.0 
Copyright (c) 1996, 2011Oracle Corporation.  All rights reserved.
https://db01:1158/em/console/aboutApplication
Stopping Oracle EnterpriseManager 11g Database Control ...

###查看oracle进程，检查是否已经停止完毕

[root@db01 ~]# ps -ef|grepora
root      4971 4944  0 01:46 pts/0    00:00:00 grep ora

3、备份老的ORACLE_HOME和oraInventory

[root@db01 ~]#tar ?cvfproduct.zip /DBSoft/product/
[root@db01 ~]#tar ?cvforaInventory.zip /DBSoft/product/oraInventory/

4、上传并解压缩Oracle Database 11.2.0.4安装介质

[oracle@db01 ~]$ ll

total 2489644
drwxr-xr-x 2 oracle oinstall       4096 Oct 3 04:06 Desktop
-rw-r--r-- 1 oracle oinstall1395582860 Oct  3 06:55p13390677_112040_Linux-x86-64_1of7.zip
-rw-r--r-- 1 oracle oinstall11

探索Oracle之数据库升级二11.2.0.3升级到11.2.0.4完整步骤(二)