TMF Operations and Recovery Guide (G06.24+)

Online Dumps
HP NonStop TMF Operations and Recovery Guide—522417-002
5-7
Dumping SQL Objects
4. Use the FUP ALTER command to change the nonaudited alternate-key file back to
audited.
See the File Utility Program (FUP) Reference Manual for instructions on using FUP
commands.
Dumping SQL Objects
TMF dumps only the SQL objects you specify in the DUMP FILES command: it does
not automatically dump dependent objects, such as indexes and views or secondary
partitions. Dependent objects, such as indexes and views, must be explicitly dumped if
you must later perform file recovery of these audited files.
SQL catalogs are dumped and recovered exactly like any other SQL table. However,
SQL catalogs and their associated objects must be recovered synchronously; that is, if
an SQL catalog is recovered to a specific time, the associated objects defined in the
catalog must also be recovered to the same time. If the catalog tables and the objects
defined in that catalog are not recovered to the same point, the dictionary definition of
the object might not reflect the actual object’s definition.
See the SQL/MP Installation and Management Guide and SQL/MX Installation and
Management Guide for complete information on dumping and recovering SQL objects.
Dumping to Remote Systems
Dumping audited files to a remote system is not considered a TMF distributed
operation. A remote system does not have to be running TMF to receive online
dumps.
You can dump audited files to a tape drive or a disk on a remote system.
Tape Dumping
Use the SYSTEM option of the DUMP FILES command to identify a remote system for
dumping audited files to tape. The remote system need not be running TMF, but it
must be configured for labeled-tape processing. Tapes used for a remote dump must
be registered in the local TMF catalog.
Here is a DUMP FILES command example for making an online dump to tape on a
remote system:
TMF 2> DUMP FILES $DATA.*.*,TAPEMEDIA DMP005, SYSTEM \REMOTE1, &
>>>VERIFYTAPE ON
See the TMF Reference Manual for instructions on using the DUMP FILES command.
Disk Dumping
Use the DISKMEDIA option of the DUMP FILES command to identify a remote system
for dumping audited files to magnetic disk.