規劃資料庫儲存設備

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規劃容體