SQL/MP Installation and Management Guide

Moving a Database
HP NonStop SQL/MP Installation and Management Guide—523353-004
9-7
DUP and BACKUP/RESTORE
Restoring Files to Multiple Nodes
When you restore a file set that resides on multiple nodes, the RESTORE utility
searches the network for a node that matches the node number of each remote file on
the tape.
Whether you are restoring files to the node from which the files were backed up, or to
another node on the same network, you need not be concerned about file names or
the destination of remote files. Local files are restored on the “local” node (as defined
under File set Considerations on page 9-6). Remote files are restored to their original
nodes. Thus, if you restore a file set to a node other than their original node, the
default behavior results in a node name change for local files but not for remote files.
Use the MAP NAME clause to redirect files as needed.
When restoring files from a BACKUP tape, note the following handling of wild-card
characters:
•
A file set with an asterisk in the volume, subvolume, and file-identifier positions
( *.*.* ) directs the RESTORE utility to restore all files on the tape, including local
and remote files.
•
A file set with a dollar sign in the volume location ( $*.*.* ) directs the RESTORE
utility to restore all of the local files on the tape. Files stored in the remote node
format will not be restored or listed using this format.
For example, if you run RESTORE on node \A and specify the file set “$*.*.*” for a tape
with a remote file set from node \B, RESTORE does not restore the tape:
RESTORE $Tape, ( $*.*.* )
\A
Files not found - Error 2013
$*.*
* *ERROR -2013* Fileset not dumped (ERROR 11)
In the preceding example, you could use the fileset “*.*.*” and an appropriate MAP
NAMES option to restore all files to the local node:
RESTORE $Tape, ( *.*.* ), MAP NAMES ( *.*.* TO $New.Sub.* )
\A.$New.Sub
TABLE1 TINDX
If you know the remote node name for the file set list, you can specify the node name
in the file set (by using the format \<node-name>.$*.*.* ) to direct the RESTORE utility
to restore all files from that node, as follows;
RESTORE $Tape, ( \B.$Vol.*.* ),
MAP NAMES ( \B.$VOL.*.* TO $NEW.SVOL.* )
\A.$New.Sub
Table1