Production database storage design
-
For the PROD Oracle RAC database, we created three volume groups:
- VM_OCR volume group with five volumes—Two 250 GB volumes each for the VM operating system and three 50 GB LUNs for Oracle clusterware including Oracle Cluster Registry (OCR), the voting disk, and the Grid Infrastructure Management Repository (GIMR).
- ORA_DATA volume group with nine volumes—Four 600 GB volumes for the PROD database datafile, four 25 GB REDO volumes, and one 100 GB volume for FRA.
- ORA_TEMP volume group with one volume—One 500 GB volume for the database TEMP tablespace is required for HammerDB TPC-C schema creation and index creation.
We created a dedicated ORA_DATA volume group that included DATA volumes, REDO volumes, and FRA volumes and put the TEMP in a separate volume group, ORA_TEMP. This design meets the requirement for a consistent snapshot of all the DATA, REDO, and FRA volumes to enable the creation of a snapshot database based on these volumes. The TEMP volume is not required to be a part of the snapshot.
The following table shows the volumes for the PROD Oracle RAC database:
Table 7. PROD database volume design
Volume group
Name
Purpose
Size (GB)
Host group
VM_OCR
PROD_VM(1-2)
Guest VM operating system
2x250
ORA_PROD_HOST_GROUP
PROD_OCR(1-3)
Votingdisk/GIMR
3x50
ORA_PROD_HOST_GROUP
ORA_DATA
PROD_DATA(1-4)
Data files
4x600
ORA_PROD_HOST_GROUP
PROD_REDO(1-4)
REDO LOGs
4x25
ORA_PROD_HOST_GROUP
PROD_FRA
FRA
100
ORA_PROD_HOST_GROUP
ORA_TEMP
PROD_TEMP
TEMP
500
ORA_PROD_HOST_GROUP
We created a host group to map these production database volumes to two PROD database servers. As shown in the following figure, this host group consists of two PROD database hosts, R740_92J-21 and R740-92-J19:
Figure 7. PROD host group
Each of the PROD database hosts has four initiators that are based on the HBAs installed on each of the hosts, as shown in the following figure:
Figure 8. Two PROD hosts with their FC initiators