使用Out of Place升级策略进行Oracle Patch操作
数据库升级、打补丁是我们经常面对的日常工作内容。在正常情况下,两个因素是我们必须要考虑的问题:停机时间窗和回退方案。就Oracle而言,即便是最简单的更新操作,都难以做到“零停机”。回退方案是在一旦发现新版本存在问题,迅速的回退到原有的版本,支持应用访问。
目前,Oracle推荐两种大规模升级的方法:In-Place和Out-of-Place。In Place升级方法下,升级动作直接在原有的Database Home目录下。Out-of-Place则是选择了一个新的Oracle Database Home目录。相对于In place策略,Out-of-Place在空间上需要更多的消耗。
但是,Out-of-Place的好处也是比较明显的,首先是可以比较方便的进行回退,同时在Downtime停机时间上,也有比较强的优势。
Out-of-Place支持Oracle大版本和Patch两种操作方式,本文主要介绍使用Out-Of-Place方法打补丁Patch方法。
1、环境介绍
选择Oracle 11gR2进行测试,版本为11.2.0.4基础版。
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 – Production
环境变量情况如下:
[oracle@testlife OPatch]$ env | grep ORA
ORACLE_SID=testdb
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
目标是在当前版本基础上,使用最新的PSU补丁文件。
2、补丁操作
升级OPatch工具。Oracle默认自带的OPatch通常是不能满足补丁要求的,比较稳妥的手段是到MOS上下载最新的OPatch升级包,替代原有的程序。
[oracle@testlife upload]$ cp p6880880_112000_Linux-x86-64.zip $ORACLE_HOME
[oracle@testlife upload]$ cd $ORACLE_HOME
[oracle@testlife dbhome_1]$ mv OPatch OPatch_BAK
[oracle@testlife dbhome_1]$ unzip p6880880_112000_Linux-x86-64.zip
Archive: p6880880_112000_Linux-x86-64.zip
creating: OPatch/
inflating: OPatch/opatch.bat
inflating: OPatch/operr.bat
(篇幅原因,有省略……)
[oracle@testlife dbhome_1]$ cd OPatch
[oracle@testlife OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.10
Copyright (c) 2016, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.10
OUI version : 11.2.0.4.0
在升级过程中,会有两套Oracle环境变量切换的动作,为避免出现问题,可以设置两套ORACLE_HOME环境变量,根据不同的情况进行切换。
[oracle@testlife OPatch]$ cd ~
[oracle@testlife ~]$ export ORACLE_OWNER_GROUP=oracle:dba
[oracle@testlife ~]$ export ORACLE_BASE=$ORACLE_BASE
[oracle@testlife ~]$ export O_ORACLE_HOME=$ORACLE_HOME –Original Oracle Home
[oracle@testlife ~]$ export O_ORACLE_HOME_NAME=`grep OHOMENAME= $O_ORACLE_HOME/oui/bin/attachHome.sh | cut -f2 -d=`
[oracle@testlife ~]$ export C_ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1_clone –Clone Environment
[oracle@testlife ~]$ export C_ORACLE_HOME_NAME=clone
[oracle@testlife ~]$ env | grep ORA
C_ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1_clone
ORACLE_OWNER_GROUP=oracle:dba
ORACLE_SID=testdb
ORACLE_BASE=/u01/app/oracle
C_ORACLE_HOME_NAME=clone
O_ORACLE_HOME_NAME=OraDb11g_home1
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
O_ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
下面,使用原有数据库克隆新的环境Clone数据库。
--目录创建
[oracle@testlife ~]$ cd /
[oracle@testlife /]$ mkdir $C_ORACLE_HOME
[oracle@testlife /]$ chown $ORACLE_OWNER_GROUP $C_ORACLE_HOME
[oracle@testlife dbhome_1]$ pwd
/u01/app/oracle/product/11.2.0/dbhome_1
[oracle@testlife dbhome_1]$ ls -l | grep dbhome
[oracle@testlife dbhome_1]$ cd ..
[oracle@testlife 11.2.0]$ ls -l | grep dbhome
drwxr-xr-x. 75 oracle oinstall 4096 Oct 18 17:52 dbhome_1
drwxr-xr-x 2 oracle dba 4096 Oct 18 18:07 dbhome_1_clone
[oracle@testlife 11.2.0]$ cd $O_ORACLE_HOME
[oracle@testlife dbhome_1]$ tar cfp - . | (cd $C_ORACLE_HOME; tar xf - )
tar: ./bin/nmo: Cannot open: Permission denied
tar: ./bin/nmb: Cannot open: Permission denied
tar: ./bin/nmhs: Cannot open: Permission denied
tar: Exiting with failure status due to previous errors
[oracle@testlife dbhome_1]$
使用clone.pl脚本创建全新的Clone数据库。
[oracle@testlife dbhome_1]$ export ORACLE_HOME=$C_ORACLE_HOME –Clone数据库目录
[oracle@testlife dbhome_1]$ perl $ORACLE_HOME/clone/bin/clone.pl \
> ORACLE_BASE=$ORACLE_BASE \
> ORACLE_HOME=$C_ORACLE_HOME \
> ORACLE_HOME_NAME=$C_ORACLE_HOME_NAME
./runInstaller -clone -waitForCompletion "ORACLE_BASE=/u01/app/oracle" "ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1_clone" "ORACLE_HOME_NAME=clone" -silent -noConfig -nowait
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 7967 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-10-18_06-13-35PM. Please wait ...Oracle Universal Installer, Version 11.2.0.4.0 Production
Copyright (C) 1999, 2013, Oracle. All rights reserved.
You can find the log of this install session at:
/u01/app/oraInventory/logs/cloneActions2016-10-18_06-13-35PM.log
.................................................................................................... 100% Done.
Installation in progress (Tuesday, October 18, 2016 6:13:56 PM CST)
.............................................................................. 78% Done.
Install successful
Linking in progress (Tuesday, October 18, 2016 6:14:00 PM CST)
Link successful
Setup in progress (Tuesday, October 18, 2016 6:14:35 PM CST)
Setup successful
End of install phases.(Tuesday, October 18, 2016 6:14:59 PM CST)
WARNING:
The following configuration scripts need to be executed as the "root" user.
/u01/app/oracle/product/11.2.0/dbhome_1_clone/root.sh
To execute the configuration scripts:
1. Open a terminal window
2. Log in as "root"
3. Run the scripts
The cloning of clone was successful.
Please check '/u01/app/oraInventory/logs/cloneActions2016-10-18_06-13-35PM.log' for more details.
切换到root进行脚本执行。
[root@testlife ~]# cd /u01/app/oracle/product/11.2.0/dbhome_1_clone
[root@testlife dbhome_1_clone]# ./root.sh
Check /u01/app/oracle/product/11.2.0/dbhome_1_clone/install/root_testlife.localdomain_2016-10-18_18-16-58.log for the output of root script
注意:此时Clone是一个和主库一样的程序包,主库在补丁过程中是支持对外操作的。
下面可以在Clone数据库上进行补丁操作。
[oracle@testlife upload]$ export ORACLE_HOME=$C_ORACLE_HOME
[oracle@testlife upload]$ cd 23615392/
[oracle@testlife 23615392]$ ls -l
total 32
drwxr-xr-x 13 oracle oinstall 4096 Jul 20 19:30 23054359
drwxr-xr-x 5 oracle oinstall 4096 Jul 20 19:30 23177551
-rw-r--r-- 1 oracle oinstall 18806 Jul 20 19:50 README.html
-rw-r--r-- 1 oracle oinstall 25 Jul 20 19:30 README.txt
[oracle@testlife 23615392]$ cd 23054359/
[oracle@testlife 23054359]$ $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 11.2.0.3.10
Copyright (c) 2016, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1_clone
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1_clone/oraInst.loc
OPatch version : 11.2.0.3.10
OUI version : 11.2.0.4.0
(中间略...)
两个补丁均完成。暂停原有服务,进行目录切换。
[oracle@testlife 23177551]$ export ORACLE_HOME=$O_ORACLE_HOME
[oracle@testlife 23177551]$ env | grep ORACLE_SID
ORACLE_SID=testdb
[oracle@testlife 23177551]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 18 19:33:52 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@testlife 23177551]$ $ORACLE_HOME/bin/lsnrctl stop
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 18-OCT-2016 19:34:32
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The command completed successfully
将原有数据库目录Detach。
[oracle@testlife 23177551]$ cd ~
[oracle@testlife ~]$ export ORACLE_HOME=$O_ORACLE_HOME
[oracle@testlife ~]$ cd $ORACLE_HOME/..
[oracle@testlife 11.2.0]$ $ORACLE_HOME/oui/bin/detachHome.sh
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 7967 MB Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
'DetachHome' was successful.
--原有目录修改名称
[oracle@testlife 11.2.0]$ mv $ORACLE_HOME `echo $ORACLE_HOME`_to_be_removed
[oracle@testlife 11.2.0]$ ls -l
total 8
drwxr-xr-x 79 oracle dba 4096 Oct 18 19:31 dbhome_1_clone
drwxr-xr-x. 75 oracle oinstall 4096 Oct 18 17:52 dbhome_1_to_be_removed
Detach新的目录对象。
[oracle@testlife 11.2.0]$ export ORACLE_HOME=$C_ORACLE_HOME
[oracle@testlife 11.2.0]$ $ORACLE_HOME/oui/bin/detachHome.sh
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 7967 MB Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
'DetachHome' was successful.
--Clone出新的文件目录。
[oracle@testlife 11.2.0]$ mv $C_ORACLE_HOME $O_ORACLE_HOME
[oracle@testlife 11.2.0]$ export ORACLE_HOME=$O_ORACLE_HOME
[oracle@testlife 11.2.0]$ perl $ORACLE_HOME/clone/bin/clone.pl \
> ORACLE_BASE=$ORACLE_BASE \
> ORACLE_HOME=$O_ORACLE_HOME \
> ORACLE_HOME_NAME=$O_ORACLE_HOME_NAME
./runInstaller -clone -waitForCompletion "ORACLE_BASE=/u01/app/oracle" "ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1" "ORACLE_HOME_NAME=OraDb11g_home1" -silent -noConfig -nowait
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 7967 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-10-18_07-39-36PM. Please wait ...Oracle Universal Installer, Version 11.2.0.4.0 Production
Copyright (C) 1999, 2013, Oracle. All rights reserved.
You can find the log of this install session at:
/u01/app/oraInventory/logs/cloneActions2016-10-18_07-39-36PM.log
.................................................................................................... 100% Done.
(篇幅原因,有省略……)
The cloning of OraDb11g_home1 was successful.
Please check '/u01/app/oraInventory/logs/cloneActions2016-10-18_07-39-36PM.log' for more details.
(执行脚本略……)
启动原有数据库,此时已经是更新过的目录了。
[oracle@testlife 11.2.0]$ export ORACLE_HOME=$O_ORACLE_HOME
[oracle@testlife 11.2.0]$ env | grep ORACLE_SID
ORACLE_SID=testdb
[oracle@testlife 11.2.0]$ $ORACLE_HOME/bin/lsnrctl start LISTENER
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 18-OCT-2016 19:44:23
The listener supports no services
The command completed successfully
[oracle@testlife 11.2.0]$ $ORACLE_HOME/bin/sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 18 19:44:45 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 3540881408 bytes
Fixed Size 2258320 bytes
Variable Size 855640688 bytes
Database Buffers 2667577344 bytes
Redo Buffers 15405056 bytes
Database mounted.
Database opened.
注意:此时可以完成各个升级补丁需要进行的postinstall操作,更新数据库或者重新编译数据库对象。
[oracle@testlife 11.2.0]$ cd $ORACLE_HOME/rdbms/admin
[oracle@testlife admin]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 18 19:46:45 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> @catbundle.sql psu apply
后续将新创建设置的环境变量重置,重新启动服务器。
[oracle@testlife admin]$ exit
logout
[root@testlife ~]# su - oracle
[oracle@testlife ~]$ env | grep ORA
ORACLE_SID=testdb
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
[oracle@testlife ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 18 20:01:08 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> startup force
ORACLE instance started.
Total System Global Area 3540881408 bytes
Fixed Size 2258320 bytes
Variable Size 855640688 bytes
Database Buffers 2667577344 bytes
Redo Buffers 15405056 bytes
Database mounted.
Database opened.
--升级完成
SQL> select version, comments from dba_registry_history;
VERSION COMMENTS
------------------------------ -----------------------------
11.2.0.4 Patchset 11.2.0.2.0
11.2.0.4 Patchset 11.2.0.2.0
11.2.0.4.160719OJVMPSU RAN jvmpsu.sql
11.2.0.4 PSU 11.2.0.4.160719
11.2.0.4.160719OJVMPSU OJVM PSU post-install
Patch 23177551 applied
6 rows selected
最后,运行一段时间之后,确认升级版本没有问题,就可以将原有的目录删除掉。
[oracle@testlife trace]$ cd ~
[oracle@testlife ~]$ rm -rf `echo $ORACLE_HOME`_to_be_removed
[oracle@testlife ~]$ cd $ORACLE_HOME
[oracle@testlife dbhome_1]$ cd ..
[oracle@testlife 11.2.0]$ ls -l
total 4
drwxr-xr-x 79 oracle dba 4096 Oct 18 19:39 dbhome_1
3、结论
Out of Place升级策略,很大程度上可以确保减少停机时间,原有配置保留和快速回退的要求。在实际场景下,对于升级要有全面的计划和多种备选预案准备,防止出现潜在风险,威胁系统数据安全。