The following figure illustrates the architecture of SnapVX snapshots of the production (source) database volumes. It shows how these snapshots are linked to another set of target devices, which are accessed by the snapshot database host, to form a snapshot database such as a development or test database.
Figure 28. SnapVX snapshot creation and snapshot database mounting
For snapshot databases, we created two types of storage groups:
Table 32. New storage groups for snapshot databases
New storage group
Total size (GB)
Table 33. Source, snapshot, and link target storage groups for snapshot databases
Source storage group
SnapVX link target storage group
We then mapped all the new storage groups and the SnapVX link target storage groups that were created for the snapshot databases to their respective database ESXi hosts by creating the appropriate masking views. Within the respective ESXi hosts, we manually added all the volumes to the appropriate VM that was created for the snapshot database. Within the respective database guest VMs, we mounted these volumes to the snapshot database.
The following figure illustrates the snapshot creation, linking, and mounting process, using the Oracle OLTP database and its snapshot database as an example.