SQL/MP Installation and Management Guide

Moving a Database
HP NonStop SQL/MP Installation and Management Guide—523353-004
9-38
Restoring a SQL/MP Database on a Node
Re-creating the SQL Catalogs (Step 1)
Use the SQLCI OBEY command to run the OBEY command file, created previously,
with the commands to re-create the catalogs with the same security and ownership.
The catalog owner is the user ID executing the CREATE CATALOG statement.
Ownership can later be given to another user ID, if necessary, by using the ALTER
CATALOG statement.
Restoring TMF Audited Files (Step 2)
Use the TMF RECOVER FILES command to recover all audited files except SQL
catalog files. The SQL catalog files were created in Step 1 on page 9-37.
For information about recovering audited files using the TMF RECOVER FILES
command, see the TMF Operations and Recovery Guide.
Restoring SQL Objects (Step 3)
Restoring SQL objects before restoring SQL programs is recommended. You can issue
the RESTORE commands at a TACL prompt, but it is probably more efficient to do the
RESTORE operation by using an OBEY command file.
To restore the SQL objects on a node to a new location, use the RESTORE utility with
the MAP NAMES and CATALOG options (when needed). Issue the RESTORE
command on the node renamed or renumbered.
This command restores objects on a node renamed from \source to \target:
56> RESTORE $TAPE2, *.*.*,
AUDITED,
MAP NAMES (\SOURCE.$VOL1.*.* TO \TARGET.$DATA1.*.*)
CATALOG ($DATA1.SALES FOR $DATA1.SALES.*,
$DATA1.ADMIN FOR $DATA1.PERSNL.*,
$DATA2.INVENT FOR $DATA1.INVENT.*)
Restoring SQL Programs (Step 4)
To restore SQL programs stored as Guardian files, specify the tape containing the
backed up programs in a RESTORE command. Use the SQLCOMPILE ON option if
you want these programs recompiled.
58> RESTORE $TAPE1, *.*.*,
AUDITED
SQLCOMPILE ON
To restore an SQL program stored in an OSS file, use the appropriate OSS utility. For
more information, see the Open System Services Shell and Utilities Reference Manual.
Note. You may need to create catalogs before recovery, either manually or by specifying the
AUTOCREATE CATALOG option of the RESTORE command.