SQL/MP Installation and Management Guide

Performing Recovery Operations
HP NonStop SQL/MP Installation and Management Guide—523353-004
11-34
PUP DOWN (or PUP REMOVE) and PUP UP
back into operation. There is no danger of inconsistency as long as the disk brought up
is identical to the disk brought down. You should always perform a PUP STOPOPENS
on the volume and a PUP REFRESH on the volume to ensure valid file labels before
you make the volume inactive.
The only exception to the preceding rule is if the entire database has been consistently
brought down as a unit. For example, suppose that you use PUP DOWN to bring down
all the backup volumes of the mirrored pairs containing SQL objects in a consistent
state. The other mirrored set continues the active database, but the inactive mirrors
also contain a set of consistent SQL objects.
You can also use PUP DOWN bring down the active database and PUP UP to bring up
the saved database in a database swapping technique. This technique might be useful
for testing scenarios. As long as you bring each set of mirrors down and then up
together, each copy of the database continues to be consistent.
Caution. You cannot use PUP DOWN or PUP REMOVE on a volume and replace the volume
with an older version of that same volume without causing inconsistencies in the database.
Note. The corresponding SCF commands (G-series only) for the PUP commands (D-series
only) are listed on page 11-35
. Use the same strategies for recovering from SCF commands as
indicated for PUP commands.