RDF System Management Manual

Table Of Contents
Installing and Configuring RDF
HP NonStop RDF System Management Manual524388-003
3-5
Synchronizing the Primary and Backup Databases
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.
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
This topic only applies to NonStop SQL/MP databases. For instructions on how to
synchronize NonStop SQL/MX databases, see Section 15, NonStop SQL/MX and
RDF.
You can use SQLCI commands to synchronize NonStop SQL/MP 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 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