GI and Database patches and release updates
In this study, we tested with Oracle Grid Infrastructure 19.7 and Oracle RAC 19.7 Release Updates. The following table provides the details of the base images, patches, and the release updates (RU) that we applied:
Table 9. Oracle GI 19c and Oracle RAC 19c software stack versions
Oracle GI |
19.3.0.0 base |
Oracle GI 19c base software |
6880880 |
OPatch Upgrade |
274526.1 |
30189609 |
Passwordless SSH fix |
30189609.8 |
30899722 |
Oracle GI 19.7 Release Update |
30899722.8 |
Oracle RAC |
19.3.0.0 base |
Oracle RAC 19c base software |
6880880 |
OPatch Upgrade |
274526.1 |
30899722 |
Oracle RAC 19.7 Release Update |
30899722.8 |
30805684 |
Oracle JavaVM Component RU 19.7 |
30805684.8 |
ASM disk groups
The following table shows the Oracle ASM disk groups (DG) that we created using our recommended best practices.
Table 10. Oracle ASM disk group (DG) settings
OCR_VD |
+OCR_DG |
3 x 48 GB |
144 GB |
Coarse |
4 MB |
DATA |
+DATA_DG |
8 x 1 TB |
8 TB |
Coarse |
4 MB |
REDO |
+REDO1_DG |
2 x 48 GB |
96 GB |
Fine |
4 MB |
REDO |
+REDO2_DG |
2 x 48 GB |
96 GB |
Fine |
4 MB |
TEMP |
+TEMP_DG |
6 x 512 GB |
3 TB |
Fine |
4 MB |
REDO log groups design
The following table shows the Oracle REDO log groups that we created according to our recommended best practices.
Table 11. Oracle REDO log groups design
1 |
+REDO1_DG |
15 GB |
1 |
2 |
+REDO2_DG |
15 GB |
1 |
3 |
+REDO1_DG |
15 GB |
1 |
4 |
+REDO2_DG |
15 GB |
1 |
5 |
+REDO1_DG |
15 GB |
2 |
6 |
+REDO2_DG |
15 GB |
2 |
7 |
+REDO1_DG |
15 GB |
2 |
8 |
+REDO2_DG |
15 GB |
2 |
