TMF Operations and Recovery Guide (G06.26+)

Online Dumps
HP NonStop TMF Operations and Recovery Guide—522417-003
5-8
Dumping SQL Objects
Files explicitly specified in the DUMP FILES command are dumped. The NOT option
of the DUMP FILES command, however, specifies the files that are not to be dumped,
whether or not they are specified elsewhere in the same DUMP FILES command.
If you must perform file recovery and have omitted alternate-key files from your online
dumps, you can use the following procedure to recover them:
1. Use the FUP ALTER command to change the audited alternate-key file to
nonaudited.
2. Recover the primary file using the TMFCOM RECOVER FILES command.
3. Use the FUP LOADALTFILE command to rebuild the alternate-key file from the
primary file.
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.