This test case demonstrates how to establish a production application environment running Oracle RAC with storage provided by a PowerStore T system. For this test case, we placed the operating systems, Oracle binaries, and the HammerDB-generated databases on the PowerStore T to demonstrate the versatility and ease of management of the array.
The operating systems, Oracle binaries, and databases consumed 1.8 TB of logical space on the PowerStore T, creating an environment that would be slow and cumbersome to replicate using native Oracle tools. In the next test case, we set up this environment to showcase the features of the PowerStore T to create a test copy of the production Oracle RAC system using a second set of servers. This configuration is only intended as a demonstration of the features of the PowerStore T and does not reflect the scale and full complexity of a typical Oracle production system.
We used HammerDB to run an Online Transaction Processing (OLTP) style workload to confirm the smooth and consistent operation of the Oracle RAC configuration before, during, and after the creation of the test copy and attachment to the second set of servers. OLTP workloads consist of many short-duration database transactions that perform highly selective lookup, modify, create, or delete operations. Online retail is a widely used example of an OLTP workload that has many characteristics in common with custom enterprise applications that are developed to support internal and external businesses processes.
First we established that the simulated production Oracle RAC system was under a steady state of load that was provided by HammerDB. We then ran the automation scripts to create the secondary copy of the production database and validated that the Oracle database was recovered on the secondary test system.