Creating an off-host replica database


Creating an off-host replica database
Prev	Using a replica database for decision support	Next

Figure: Example system configuration for off-host decision support shows an example where the primary database volumes to be backed up, dbase_vol and dbase_logs, are configured on disks attached to controllers c1 and c2, and the snapshots are to be created on disks attached to controllers c3 and c4.

There is no requirement for the off-host processing host to have access to the disks that contain the primary database volumes.

Note:

If the database is configured on volumes in a cluster-shareable disk group, it is assumed that the primary host for the database is the master node for the cluster. If the primary host is not also the master node, all VxVM operations on shared disk groups must be performed on the master node.

Figure: Example system configuration for off-host decision support

To set up a replica database to be used for decision support on another host

Prepare the full-sized snapshot.

See Preparing a space-optimized snapshot for a database backup.
Create snapshot mirrors for volumes containing VxFS file systems for database files to be backed up.
Make the database replica.
All commands require superuser (root) or equivalent privileges.

Prev	Up	Next
Creating a replica database	Home	Setting up a replica database for off-host decision support