RDF/IMP and IMPX System Management Manual (RDF 1.3+)

Installing and Configuring RDF
Compaq NonStop™ RDF/IMP and IMPX System Management Manual—522204-001
3-7
Synchronizing the Primary and Backup Databases
9. Use the SQLCI DUP command to copy the primary system’s database to the backup
system:
DUP ( *.*.* FROM CATALOG \PRIM.$TEST.DBCAT ),
MAP NAMES ( \PRIM.$DATA1.*.* TO \BACK.$DATA1.*.* ,
\PRIM.$DATA2.*.* TO \BACK.$DATA2.*.* )
SAVEALL ON;
10. After using the SQLCI DUP command, perform a TMF online dump on the primary
system to create a recovery point.
Synchronizing Databases With BACKUP and RESTORE Utilities
You can use the BACKUP and RESTORE utilities to synchronize SQL/MP or Enscribe
databases by copying a database to tape on the primary system and restoring the
database from tape on the backup system. This method is preferable when you want a
backup tape of the primary system database, or when the database is large.
The following example of BACKUP and RESTORE commands shows how to copy a
SQL/MP database from the primary system \PRIM to the magnetic tape device named
$TAPE and how to restore the database to volumes of the same name on the backup
system \BACK. Note that you must include the AUDITED option in both the BACKUP
and RESTORE commands.
1. Back up the database from \PRIM onto tape:
BACKUP $TAPE, (*.*.* FROM CATALOG \PRIM.$TEST.DBCAT),
AUDITED, INDEXES IMPLICIT, LISTALL
2. Restore the database from tape onto \BACK (assuming the catalog was already
created):
RESTORE $TAPE, *.*.*, AUDITED,
MAP NAMES ( \PRIM.$DATA1.*.* TO \BACK.$DATA1.*.* ,
\PRIM.$DATA2.*.* TO \BACK.$DATA2.*.* ),
CATALOG \BACK.$DATA1.DBCAT, INDEXES IMPLICIT,
SQLCOMPILE OFF, LISTALL
The next examples of BACKUP and RESTORE commands show how to copy all files
from the primary system volumes $DATA01, $DATA02, $DATA03, and $DATA04 to the
magnetic tape device named $TAPE and how to restore these files to volumes of the
same name on the backup system. Note that you must include the AUDITED option in
both the BACKUP and RESTORE commands.
BACKUP $TAPE,($DATA01.*.*,$DATA02.*.*,$DATA03.*.*,
$DATA04.*.*), AUDITED
RESTORE $TAPE,($DATA01.*.*,$DATA02.*.*,$DATA03.*.*,
$DATA04.*.*), AUDITED