RDF System Management Manual

Installing and Configuring RDF
HP NonStop RDF System Management Manual—524388-003
3-7
Synchronizing the Primary and Backup Databases
7. Enter commands to specify the data to be inserted into the table on the primary
system:
INSERT INTO =EMPLOYEE ( EMPNUM, FIRST_NAME, LAST_NAME )
VALUES ( 826, "Evans", "Joan" );
INSERT INTO =EMPLOYEE ( EMPNUM, FIRST_NAME, LAST_NAME )
VALUES ( 3351, "MacArthur", "Bill" );
INSERT INTO =EMPLOYEE ( EMPNUM, FIRST_NAME, LAST_NAME )
VALUES ( 10809, "Gember", "Tom" );
Now direct your attention to the backup system (\BACK). As you perform the
necessary tasks on this system, note the following considerations:
•
DEFINEs cannot be used if you specify MAP NAMES parameter in the DUP
command.
•
The DUP operation moves the entire database, including all partitions and
indexes, by default.
•
The catalog \BACK.$DATA1.DBCAT is used for all partitions and all indexes.
8. Specify the catalog for the backup system:
CATALOG \BACK.$DATA1.DBCAT;
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 NonStop SQL/MP,
NonStop SQL/MX, 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
NonStop 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 parameter in
both the BACKUP and RESTORE commands.