Oracle RAC (VMware VMs) Active-Active DC Use Cases using DellEMC PowerMax Storage
Below are the some of the quick Use Cases to be demonstrated using Oracle RAC for active-active DC scenarios using Dell EMC PowerMax Storage
The Oracle RAC was built on VMware platform.
USE CASE 1
Write database index into common DB from both the RAC Nodes.
- Firstly count index records on both RAC instances before adding new records. I am using simple bash script that uses sqlplus and count the records. The scripts are attached in the bottom section.
2. Add new Index records into both the RAC instances. This action will prove that you can write into both the RAC DB instances using DELL EMC PowerMax SRDF Metro Active/Active DC operation. Once again I am using simple bash script that uses sqlplus and count the records. The scripts are attached in the bottom section.
Node01 – Insert records
Node02 – Insert records
USE CASE 2
While everything same as USE CASE 1. Use SwingBench Application to write database index into common DB from both the RAC Nodes.
Here i am using SwingBench benchmarking tool for Oracle RAC. I am accessing Oracle RAC Scan and global DB ID for the SwingBench Connection String. Also notice I am loading 10 users for benchmarking.
Noticed SwingBench started loading data into both the RAC DB instances simultaneously.
Noticed Unisphere GUI for PowerMax Storage shows that workload being generated from both the Storage arrays located at Site1 & Site2 respectively.
USE CASE 3 –
Witness Site goes down
When all the witnesses are inaccessible Oracle DB instances at both the Sites remain accessible. SRDF/Metro moves into Active-Bias State.
No impact to the SwingBench Load benchmarking on both the RAC DB instances.
METRO CASE 4 – Both Witness down and RDF DOWN
Once the Witness & RDF links between Storage Arrays Sites goes down, notice IO remains accessible to Site1 however Site goes not ready.
Unisphere GUI for Storage reflect similar behaviors as SwingBench. IO continues at Site1 however IOs stops at Site 2.
Hope you enjoyed this post, I’d be very grateful if you’d help sharing it on Social Media. Thank you!