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-5
Synchronizing the Primary and Backup Databases
Re-Creating an Empty Database With an OBEY Command
If a database on the primary system does not contain any data yet, use either an
OBEY command file or a TACL macro to re-create the database on the backup
system.
To create logically identical database structures on the primary and backup systems,
first do the following at the primary system:
1. Place the database creation commands in either an EDIT (command) file or TACL
macro or routine. See the HP NonStop TACL Reference Manual for more
information.
2. Through the TACL command interpreter, issue an OBEY filename command or run
the macro to create the primary database.
3. Copy the command file or TACL macro to the backup system.
Now do the following on the backup system:
•
Change any system references in the command file or TACL macro from the
primary system name to the backup system name. If the volume names are
different or if you want a different database layout on the backup system, change
volume references as well.
•
Through the TACL command interpreter, issue an OBEY filename command or run
the macro to create the backup database.
Synchronizing Databases With SQLCI Commands
You can use SQLCI commands to synchronize NonStop SQL/MP or Enscribe
databases online. For NonStop SQL/MP databases, you create the catalog or catalogs
on the backup system and then duplicate the objects registered in each catalog. For
Enscribe databases, you duplicate the database files.
For complete information about using SQLCI to copy databases, see the information
on moving databases in the HP NonStop SQL/MP Installation and Management Guide.
For the syntax of SQLCI commands, see the SQLCI online help or the HP NonStop
SQL/MP Reference Manual.
The following example shows how you can create a partitioned NonStop SQL/MP table
with an alternate index on the primary system with the SQLCI CREATE command, and
then duplicate this table on the backup system by using the SQLCI DUP command. In
this example, \PRIM is the primary system and \BACK is the backup system.
Notice that the catalog for this NonStop SQL/MP table is created on the backup system
before starting RDF on the primary system so that RDF will recognize the backup
catalog and not report errors when attempting to process audit data for this catalog.
1. Using SQLCI, enter a CREATE command to create the catalog on the backup
system. TMF must be up for NonStop SQL/MP catalog updating:
CREATE CATALOG \BACK.$DATA1.DBCAT;