TMF Operations and Recovery Guide (G06.24+)

Recovery Methods
HP NonStop TMF Operations and Recovery Guide—522417-002
7-22
Responding to Accidental Loss of an Audited SQL
Object
3. Issue a RECOVER FILES command with the FROMARCHIVE option and either
the TIME option or the TOFIRSTPURGE option and any other options needed to
recover the purged file. If you want to recover all files up to the first file purged in a
fileset, it is more straightforward and risk-free to use the TOFIRSTPURGE option
rather than the TIME option.
4. Make a new online dump of the file once the file recovery process has completed.
Responding to Accidental Loss of an Audited SQL Object
If an SQL object has been accidentally dropped from the system, you may be able to
recover the object by using TMF file recovery together with SQL conversational
interface commands. The particular recovery steps depend on whether the object
dropped was a view, an index, or a table. Performing the recovery, especially in the
case of a table, requires substantial knowledge of both SQL and TMF. For details
about the recovery steps, see SQL/MP Installation and Management Guide and
SQL/MX Installation and Management Guide.
Recovering a File Damaged After the AUDIT Attribute is Turned
Off
If a file is damaged after its AUDIT attribute has been turned off, recovery might still be
possible if the online and audit dumps are still available. To attempt the recovery,
follow these steps:
1. Use the INFO DUMPS, DETAIL command to see if the TMF catalog still has an
entry for the most recent online dump for the file:
•
If there is no entry for the file, issue an ADD DUMPS command to replace the
entry. Use the output from a previous INFO DUMPS command or consult your
hardcopy dump tracking forms to obtain the necessary information.
•
If there is an entry for the file but the dump status is released or invalid, issue
an ALTER DUMPS command with the INVALID OFF and RELEASED OFF
options to change the dump status.
2. Issue another INFO DUMPS, DETAIL command to make sure the TMF catalog
now has a correct entry for an online dump for the file.
3. Issue a RECOVER FILES command with the FROMARCHIVE option, and if you
choose, the TIME option. Also include any other options needed to recover the
damaged file.
4. Make a new online dump of the file once the file recovery process has completed.
Note. TMF can only recover the file up to the point where the AUDIT attribute was turned
off (or to an earlier point, through the TIME option). Thus, if you turn AUDIT off for a file
and later turn it back on, you cannot recover the file to its most recent state if the last
online dump was taken before AUDIT was turned off; new online dumps are always
required for file recovery after any point when the file’s AUDIT attribute is turned on.