規劃資料庫儲存設備

Oracle 資料庫需要的檔案，應放置在所有 RAC 叢集節點均能存取的實體容體上。本節顯示如何利用 SLVM 或 VERITAS CVM 儲存設備群組規劃容體。

以 SLVM 規劃容體

Oracle 資料庫的儲存容量必須以共用容體群組中之邏輯容體的形式提供。Oracle 軟體要求每個 Oracle 應用例至少需有兩個日誌檔 (一個 Oracle9 的 undo tablespace)、數個 Oracle 控制檔案，和資料庫本身的資料檔案。對以上所有檔案而言，Serviceguard Extension for RAC 使用 HP-UX 原始邏輯容體，而這些邏輯容體位於叢集節點間共用的容體群組中。使用 RAID 模式的高可用性磁碟陣列，即可達到高可用性。各個節點可透過多重實體容體連結 (PV 連結，亦即替代連結) 存取陣列上的儲存邏輯單元，這些連結提供通往每個儲存單元的備援路徑。請填寫邏輯容體工作表，提供邏輯容體的名稱 (使用 lvcreate 命令建立)。Oracle DBA 和 HP-UX 系統管理者應一起準備此份工作表。僅建立共用容體的項目。輸入每個邏輯容體之原始邏輯容體裝置檔的完整路徑名稱。務必加上所需的大小 (以 MB 為單位)。下列為工作表的填寫範例，不過，本範例僅供參考。檔案大小視 Oracle 資料庫版本的不同而異。若需空白工作表的樣本，請參閱附錄 A 「空白規劃工作表」。視需要複製多份，填寫工作表並保存以供日後參考之需。

ORACLE LOGICAL VOLUME WORKSHEET FOR LVM                        		Page ___ of ____
===============================================================================
                              RAW LOGICAL VOLUME NAME          SIZE (MB)
 
Oracle Control File _____/dev/vg_ops/ropsctl1.ctl_______100______
Oracle Control File 2: ___/dev/vg_ops/ropsctl2.ctl______100______
Oracle Control File 3: ___/dev/vg_ops/ropsctl3.ctl______100______
Instance 1 Redo Log 1: ___/dev/vg_ops/rops1log1.log_____20______
Instance 1 Redo Log 2: ___/dev/vg_ops/rops1log2.log_____20_______
Instance 1 Redo Log 3: ___/dev/vg_ops/rops1log3.log_____20_______
Instance 1 Redo Log: __________________________________________________
Instance 1 Redo Log: __________________________________________________
Instance 2 Redo Log 1: ___/dev/vg_ops/rops2log1.log____20________
Instance 2 Redo Log 2: ___/dev/vg_ops/rops2log2.log____20________
Instance 2 Redo Log 3: ___/dev/vg_ops/rops2log3.log____20_________
Instance 2 Redo Log: _________________________________________________
Instance 2 Redo Log: __________________________________________________
Data: System ___/dev/vg_ops/ropssystem.dbf___400__________
Data: Temp ___/dev/vg_ops/ropstemp.dbf______100_______
Data: Users ___/dev/vg_ops/ropsusers.dbf_____120_________
Data: Tools ___/dev/vg_ops/ropstools.dbf____15___________
Data: User data ___/dev/vg_ops/ropsdata1.dbf_200__________
Data: User data ___/dev/vg_ops/ropsdata2.dbf__200__________
Data: User data ___/dev/vg_ops/ropsdata3.dbf__200__________
Data: Rollback ___/dev/vg_ops/ropsrollback.dbf__300_________(Oracle8)

parameter: spfile1 /dev/vg_ops/ropsspfile1.ora __5_____(Oracle9)
Instance 1  undotbs1: /dev/vg_ops/ropsundotbs1.dbf___312___(Oracle9)
Instance 2  undotbs2: /dev/vg_ops/ropsundotbs2.dbf___312___(Oracle9)
Data: example1__/dev/vg_ops/ropsexample1.dbf__________160____(Oracle9)
data: cwmlite1__/dev/vg_ops/ropscwmlite1.dbf__100____(Oracle9)
Data: indx1__/dev/vg_ops/ropsindx1.dbf____70___(Oracle9)
Data: drsys1__/dev/vg_ops/ropsdrsys1.dbf___90___(Oracle9)

以 CVM 規劃容體

Oracle 資料庫的儲存容量必須以共用磁碟群組中之容體的形式提供。Oracle 軟體要求每個 Oracle 應用例至少需有兩個日誌檔 (一個 Oracle9 的 undo tablespace)、數個 Oracle 控制檔案，和資料庫本身的資料檔案。對以上所有檔案而言，Serviceguard Extension for RAC 使用 HP-UX 原始容體，而這些容體位於叢集節點間共用的磁碟群組中。使用 RAID 節點的高可用性磁碟陣列，即可達到高可用性。各個節點可透過 DMP (Dynamic Multi-pathing，動態多重路徑)，經由多重實體容體連結存取陣列上的儲存邏輯單元，DMP 提供通往每個儲存單元的備援路徑。

請填寫 VERITAS 容體工作表，提供容體的名稱 (使用 VERITAS 公用程式建立)。Oracle DBA 和 HP-UX 系統管理者應一起準備此份工作表。僅建立共用容體的項目。輸入每個容體之原始容體裝置檔的完整路徑名稱。務必加上所需的大小 (以 MB 為單位)。下列為工作表的填寫範例，若需空白工作表的樣本，請參閱附錄 A 「空白規劃工作表」。視需要複製多份，填寫工作表並保存以供日後參考之需。

ORACLE LOGICAL VOLUME WORKSHEET FOR CVM                        		Page ___ of ____
===============================================================================
                              RAW LOGICAL VOLUME NAME          SIZE (MB)
 
Oracle Control File 1: ___/dev/vx/rdsk/ops_dg/opsctl1.ctl______100______
Oracle Control File 2: ___/dev/vx/rdsk/ops_dg/opsctl2.ctl______100______
Oracle Control File 3: ___/dev/vx/rdsk/ops_dg/opsctl3.ctl______100______
Instance 1 Redo Log 1: ___/dev/vx/rdsk/ops_dg/ops1log1.log_____20______
Instance 1 Redo Log 2: ___/dev/vx/rdsk/ops_dg/ops1log2.log_____20_______
Instance 1 Redo Log 3: ___/dev/vx/rdsk/ops_dg/ops1log3.log_____20_______
Instance 1 Redo Log: ___________________________________________________
Instance 1 Redo Log: ___________________________________________________
Instance 2 Redo Log 1: ___/dev/vx/rdsk/ops_dg/ops2log1.log____20________
Instance 2 Redo Log 2: ___/dev/vx/rdsk/ops_dg/ops2log2.log____20________
Instance 2 Redo Log 3: ___/dev/vx/rdsk/ops_dg/ops2log3.log____20_________
Instance 2 Redo Log: _________________________________________________
Instance 2 Redo Log: __________________________________________________
Data: System ___/dev/vx/rdsk/ops_dg/system.dbf___400__________
Data: Temp ___/dev/vx/rdsk/ops_dg/temp.dbf______100_______
Data: Users ___/dev/vx/rdsk/ops_dg/users.dbf_____120_________
Data: Tools ___/dev/vx/rdsk/ops_dg/tools.dbf____15___________
Data: User data ___/dev/vx/rdsk/ops_dg/data1.dbf_200__________
Data: User data ___/dev/vx/rdsk/ops_dg/data2.dbf__200__________
Data: User data ___/dev/vx/rdsk/ops_dg/data3.dbf__200__________
Data: Rollback ___/dev/vx/rdsk/ops_dg/rollback.dbf__300_________(Oracle8)

parameter: spfile1 /dev/vx/rdsk/ops_dg/spfile1.ora __5_____(Oracle9)
Instance 1  undotbs1: /dev/vx/rdsk/ops_dg/undotbs1.dbf___312___(Oracle9)
Instance 2  undotbs2: /dev/vx/rdsk/ops_dg/undotbs2.dbf___312___(Oracle9)
Data: example1__/dev/vx/rdsk/ops_dg/example1.dbf__________160____(Oracle9)
data: cwmlite1__/dev/vx/rdsk/ops_dg/cwmlite1.dbf__100____(Oracle9)
Data: indx1__/dev/vx/rdsk/ops_dg/indx1.dbf____70___(Oracle9)
Data: drsys1__/dev/vx/rdsk/ops_dg/drsys1.dbf___90___(Oracle9)

規劃資料庫儲存設備

技術文件

» 目錄

» 索引

以 SLVM 規劃容體

以 CVM 規劃容體