XtremIO Virtual Copy Database Environment Setup

This chapter describes the steps that are required to deploy and configure the stand-alone OLAP and OLTP databases, which were created from snapshots that were taken and managed by XVC. XVC enables instant, highly efficient database copies that can then be mounted and used as normal database instances.

The XVC snapshot database deployment process consists of the following tasks, which are described in detail in the subsequent sections:

1. Configure XtremIO storage:
   1. Create an Initiator Group.
   2. Create non-snapshot volumes.
   3. Map non-snapshot volumes to the XVC database server.

2. Configure LAN and SAN switches:
   1. Configure redundant ToR 10 GbE switches.
   2. Configure redundant 16 Gbps SAN FC switches, including zoning.
3. Configure the XVC database server:
   1. Prepare the PowerEdge server.
   2. Configure the operating system, network, and storage.
   3. Install the DBMS and database.
4. Take an XVC snapshot on the PROD database:
   1. Configure snapshot devices on the XVC server.
   2. Take a snapshot of the consistency group.
   3. Map the consistency group to the XVC server.
5. Create a snapshot database on the XVC server:
   1. Prepare the multipath and udev rules for the XVC snapshot volumes.
   2. Rename the disk groups of the XVC snapshot volumes.
   3. Mount the snapshot database.
   4. Change the database files names.
   5. Open the snapshot database and change the database name and DBID.[6]
   6. Re-create any DBMS system files as required.