SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

Performing Recovery Operations
HP NonStop SQL/MX Installation and Management Guide—544536-007
12-19
Recovering Tables
>>> $DATA10.ZDST5356.NPFH8J01), INVALID OFF,&
>>> RELEASED OFF, SERIAL 70
8. Recover the table and its indexes.
To conduct the recovery, you use the TMFCOM RECOVER FILES command. You
can use the MXGNAMES output as input to the RECOVER FILES command, as
was done in Step 3:
$SYSTEM ZMXTOOLS 29> MXGNAMES HRDATA.PERSNL.EMPLOYEE -TMF
Hewlett-Packard NonStop (TM) SQL/MX Guardian Name Listing Utility
(c) Copyright 2003 Hewlett-Packard Development Company, LP.
(-- Table HRDATA.PERSNL.EMPLOYEE -- &
$DATA10,ZSDT5356.NG59FJ*,&
-- Index XEMPNAME ON HRDATA.PERSNL.EMPLOYEE -- &
$DATA10.ZSDT5356.JN9V5J*,&
-- Index XEMPDEPT ON HRDATA.PERSNL.EMPLOYEE -- &
$DATA10.ZSDT5356.NPFH8J* &
--End of Table HRDATA.PERSNL.EMPLOYEE -- &
)
TMF 3>RECOVER FILES (-- Table HRDATA.PERSNL.EMPLOYEE -- &
$DATA10.ZSDT5356.NG59FJ*,&
-- Index XEMPNAME ON HRDATA.PERSNL.EMPLOYEE--&
$DATA10.ZSDT5356.JN9VFJ*,&
-- Index XEMPDEPT ON HRDATA.PERSNL.EMPLOYEE--&
$DATA10.ZSDT5356.NPFH8J* &
--End of Table HRDATA.PERSNL.EMPLOYEE--&
),FROMARCHIVE, TOFIRSTPURGE
9. The objects are now recovered in the database. However, additional work might
need to be done because of possible inconsistencies between the objects’ file
labels on disk and the corresponding information for them in the SQL/MX
metadata.
TMF does not update or insert entries in the SQL catalog during a RECOVER
FILES operation for an SQL/MX object. As it performs the recovery, TMF will
attempt to automatically synchronize the objects’ create and redefinition
timestamps between the catalog and the file label on disk. If TMF cannot perform
this synchronization, it will display EMS Message 203 (with Subsystem Error 9038)
for each inconsistency, for example:
NonStop TMF on \PLUTO *0203* RECOVER FILES [57]
OnLineRestore Process #1 OnlineDumpMgmt: *WARNING*
TMF-9038: $DATA10.ZSDT5356.NPFH8J00: Unable to retrieve the CreateTime
and RedefTime for this object from disk. Using the values from the online
dump instead.
At the end of the recovery operation, you can use these EMS messages to
determine which files have timestamps on disk that are inconsistent with their
Note. If, for any reason, the dumps were completely removed from the TMF catalog,
you would need to add them again, using the TMFCOM ADD DUMPS command. In this
command, you would also set the INVALID and RELEASED attributes to OFF.
Caution. Objects to be recovered are spread across different disk volumes and subvolumes.
However, if some of the objects are located in the same subvolume as the SQL/MX catalog or
schema, be careful to avoid recovering the catalog or schema tables, so that the current state
of the catalog is maintained.