SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Planning Database Security and Recovery
HP NonStop SQL/MX Installation and Management Guide—523723-004
5-6
Planning Database Recovery
Planning Database Recovery
HP provides several recovery mechanisms, including:
•
Mirrored disk volumes are a primary protection against disk failures. These
volumes also provide the ability to repair and maintain disk volumes online, without
interrupting application processing. For information about how to use mirrored disk
volumes, see the Guardian User’s Guide and the Guardian Disk and Tape Utilities
Reference Manual.
•
The TMF subsystem provides the best online protection against application or
equipment failures. When used correctly, the TMF subsystem protects the
database from program failures that would leave the database inconsistent
because of incomplete transactions.
•
RDF maintains replicated databases at a remote site that can be used for
contingency planning. As end users modify the local database, RDF replicates
those changes in the remote database, keeping it continuously up to date. For
more information about managing a replicated SQL/MX database with RDF, see
the RDF System Management Manual.
•
The use of backup tapes for data files can provide a way to protect data in an
offline mode. Tapes can be physically removed from the site and saved for
possible disaster recovery.
Fault-tolerant hardware and software strategies provide maximum protection against
most equipment failures, power failures, and some catastrophic failures. This
protection, however, does not eliminate your need to plan carefully to protect database
and application software. After formulating a comprehensive recovery strategy,
practice carrying out the plan on a regular, consistent basis.
Using Guardian Physical Names for SQL/MX Objects
For information about using the MXGNAMES utility with TMF to facilitate the use of
Guardian physical names for SQL/MX objects, see.
When you plan the recovery strategies that involve TMF and RDF, you must consider
many options, limits, and caveats. For comprehensive information about these and
other topics related to TMF and RDF, see:
•
Backup and Restore 2 Manual
•
RDF System Management Manual
•
SQL/MX Reference Manual
•
TMF Operations and Recovery Guide
•
TMF Planning and Configuration Guide
•
TMF Reference Manual