SQL/MP Installation and Management Guide

HP NonStop SQL/MP Installation and Management Guide—523353-004
11-1
11
Performing Recovery Operations
The success of recovery operations depends on the effectiveness and consistency of
the plan developed for handling recovery situations. Before you begin any recovery
operation, you should thoroughly evaluate the tools—backup tapes, TMF online
dumps, and so forth—available and appropriate for the type of failure.
Recovery procedures described in this section use these tools:
•
BACKUP and RESTORE: Guardian utilities for dumping files or tables to tape and
restoring them
•
Peripheral Utility Program (PUP): The Guardian utility used in D-series and earlier
RVUs to manage disks and other peripheral devices, and perform various
operations on disk volumes in the SQL/MP database environment. In G-series
RVUs, PUP functions are performed by the SCF.
•
Subsystem Control Facility (SCF): An interactive interface for configuring,
controlling, and collecting information from a subsystem and its objects. SCF
enables you to configure and reconfigure devices, processes, and some system
variables while your HP NonStop S-series server is online.
•
Volume recovery: A TMF recovery mechanism that returns a database to a
consistent state after a system failure. Volume recovery reapplies committed
transactions to ensure they are reflected correctly in the database and then backs
out all transactions that were incomplete at the time of the interruption.
•
File recovery: A TMF recovery mechanism used for recovery from disk and media
failures and the effects of incorrect programs. File recovery restores the database
from the most recent online dumps, applying the after-images from the audit trail to
the database records, and then backs out all transactions that were incomplete at
the time of the system interruption or failure.
If you need to recover a database to a different node, see Renaming or Renumbering a
Node on page 9-32 in addition to the material in this section.
For information about using the RDF product to maintain a duplicate database at a
remote site, see the RDF/IMP and IMPX System Management Manual.