RDF/IMP, IMPX, and ZLT System Management Manual

Installing and Configuring RDF
HP NonStop RDF/IMP, IMPX, and ZLT System Management Manual—524388-002
3-4
Synchronizing the Primary and Backup Databases
To make it easy to compare catalogs on the primary and backup systems, it is strongly
recommended that you register objects protected by RDF in separate catalogs from
objects not protected by RDF. Either all the tables in a catalog should be protected or
none of the tables should be protected.
Every NonStop SQL/MP object maintained on the backup system must be registered in
a catalog, even if the object is not protected by RDF.
Synchronizing the Primary and Backup Databases
For databases to be synchronized in an RDF environment, the database on the backup
system must be logically identical to the database on the primary system. There are
two ways to synchronize your databases: offline and online. This topic covers offline
database synchronization. For a description of online database synchronization, see
Section 7, Online Database Synchronization.
To ensure consistency between the primary and backup databases, you should copy
the primary database to the backup system before RDF updating starts. The most
effective way to synchronize the databases follows:
1. Stop TMF auditing on the primary system by turning off the applications and
stopping TMF.
2. Create a copy of the primary database on the backup system.
The tools for synchronizing databases on HP NonStop systems are as follows:
•
The TACL OBEY command enables you to create the same database structures
on the primary system and the backup system by using commands in an EDIT file
to create reusable TACL macros and routines.
•
The SQLCI CREATE CATALOG command can re-create NonStop SQL/MP
catalogs on the backup system.
•
The SQLCI DUP utility can copy NonStop SQL/MP objects and Enscribe files from
one system to another.
•
The BACKUP and RESTORE utilities can copy NonStop SQL/MP objects and
Enscribe files to and from tape.
•
The FUP DUP command can copy Enscribe files from one system to another.
•
The HP NonStop Autosync product can replicate all application programs and files
other than your RDF database.
Backing up partitioned files requires some extra planning, as explained in
Synchronizing Partitioned Files later in this section.
For a complete discussion of synchronized versus unsynchronized databases and their
ramifications, see Understanding Database States in section 6.