ORACLE EXADATA升級—從11.2.3.1.0到11.2.3.3.0–（9）升級後的檢查

整個升級成功後，還有一些步驟需要執行，例如我們把ASM的disk repair的時間修改回來，把CRS的狀態改成enable,啟動dbfs，以及檢查IMAGE是否都已經升級到了11.2.3.3.0。

----修改ASM的disk_repair_time
SQL> alter diskgroup DATA_GXX2 set attribute 'disk_repair_time'='3.6h';
Diskgroup altered.

----將CRS的狀態改成enable
[root@gxx2db01 tmp]dcli -g dbs_group -l root "/u01/app/11.2.0.3/grid/bin/crsctl enable crs"

----檢查計算節點和儲存節點的IMAGE資訊
[root@gxx2db01 mydbfs]# dcli -g /tmp/all_group -l root 'imagehistory'
gxx2db01: Version                              : 11.2.3.1.0.120304
gxx2db01: Image activation date                : 2002-05-03 22:47:44 +0800
gxx2db01: Imaging mode                         : fresh
gxx2db01: Imaging status                       : success
gxx2db01:
gxx2db01: Version                              : 11.2.3.3.0.131014.1
gxx2db01: Image activation date                : 2014-09-07 11:57:33 +0800
gxx2db01: Imaging mode                         : patch
gxx2db01: Imaging status                       : success
gxx2db01:
gxx2db02: Version                              : 11.2.3.1.0.120304
gxx2db02: Image activation date                : 2012-05-03 11:29:41 +0800
gxx2db02: Imaging mode                         : fresh
gxx2db02: Imaging status                       : success
gxx2db02:
gxx2db02: Version                              : 11.2.3.3.0.131014.1
gxx2db02: Image activation date                : 2014-09-06 22:03:14 +0800
gxx2db02: Imaging mode                         : patch
gxx2db02: Imaging status                       : success
gxx2db02:
gxx2cel01: Version                              : 11.2.2.3.5.110815
gxx2cel01: Image activation date                : 2011-10-19 16:15:42 -0700
gxx2cel01: Imaging mode                         : fresh
gxx2cel01: Imaging status                       : success
gxx2cel01:
gxx2cel01: Version                              : 11.2.3.1.0.120304
gxx2cel01: Image activation date                : 2012-05-03 03:00:13 -0700
gxx2cel01: Imaging mode                         : out of partition upgrade
gxx2cel01: Imaging status                       : success
gxx2cel01:
gxx2cel01: Version                              : 11.2.3.3.0.131014.1
gxx2cel01: Image activation date                : 2014-09-06 16:01:21 +0800
gxx2cel01: Imaging mode                         : out of partition upgrade
gxx2cel01: Imaging status                       : success
gxx2cel01:
gxx2cel02: Version                              : 11.2.2.3.5.110815
gxx2cel02: Image activation date                : 2011-10-19 16:26:30 -0700
gxx2cel02: Imaging mode                         : fresh
gxx2cel02: Imaging status                       : success
gxx2cel02:
gxx2cel02: Version                              : 11.2.3.1.0.120304
gxx2cel02: Image activation date                : 2012-05-03 02:59:52 -0700
gxx2cel02: Imaging mode                         : out of partition upgrade
gxx2cel02: Imaging status                       : success
gxx2cel02:
gxx2cel02: Version                              : 11.2.3.3.0.131014.1
gxx2cel02: Image activation date                : 2014-09-06 17:42:01 +0800
gxx2cel02: Imaging mode                         : out of partition upgrade
gxx2cel02: Imaging status                       : success
gxx2cel02:
gxx2cel03: Version                              : 11.2.2.3.5.110815
gxx2cel03: Image activation date                : 2011-10-19 16:26:59 -0700
gxx2cel03: Imaging mode                         : fresh
gxx2cel03: Imaging status                       : success
gxx2cel03:
gxx2cel03: Version                              : 11.2.3.1.0.120304
gxx2cel03: Image activation date                : 2012-05-03 02:58:38 -0700
gxx2cel03: Imaging mode                         : out of partition upgrade
gxx2cel03: Imaging status                       : success
gxx2cel03:
gxx2cel03: Version                              : 11.2.3.3.0.131014.1
gxx2cel03: Image activation date                : 2014-09-06 17:42:08 +0800
gxx2cel03: Imaging mode                         : out of partition upgrade
gxx2cel03: Imaging status                       : success

附參考文件：

Sun_Oracle_Database_Machine_Owner’s_Guide

How to backup / restore Exadata Database Server (Lunix) –社群文件

dbnodeupdate.sh: Exadata Database Server Patching using the DB Node Update Utility (文件 ID 1553103.1)

Exadata 11.2.3.3.0 release and patch (16278923) (文件 ID 1487339.1)

Information Center: Upgrading Oracle Exadata Database Machine [ID 1364356.2]

（本文轉自“新炬網路”官方網站技術分享欄目）