SQL/MP Installation and Management Guide

Performing Recovery Operations
HP NonStop SQL/MP Installation and Management Guide—523353-004
11-25
Recovery Example
NonStop TMF on \PLUTO *0203* RECOVER FILES [57]
OnLineRestore Process #1 OnlineDumpMgmt: *WARNING*
TMF-9038: $DATA.PERSNL.EMPLIST: Unable to retrieve the
CreateTime and RedefTime for this object from disk. Using the
values from the online dump instead.
8. At the end of recovery operation, use these EMS messages to determine which
files have timestamps on disk that are inconsistent with their timestamps in the
SQL catalog. You must then manually perform the synchronization for these
objects, as explained in Step 9 on page 11-26.
Alternatively, use the SQLCI VERIFY utility to list the inconsistencies between the
object descriptions in the file labels and in the SQL catalog:
>>VERIFY $DATA.PERSNL.*;
.
.
.
--- Verifying $DATA.PERSNL.EMPLIST
*** ERROR from SQL [-9853]: Column LA^CrTime^F in disk label does
*** not match TABLES.CreateTime in catalog \HIL3.$DATA.PERSNL.
*** ERROR from SQL [-9886]: Value of LA^CrTime^F is:
*** 211929379570628303 in partition \HIL3.$DATA.PERSNL.EMPLIST
*** ERROR from SQL [-9853]: Column CatalogOptime^F in disk label
*** does not match TABLES.Redeftime in catalog
*** \HIL3.$DATA.PERSNL.
*** ERROR from SQL [-9886]: Value of CatalogOptime^F is:
211929379552916402 in partition \HIL3.$DATA.PERSNL.EMPLIST
.
--- Verifying $DATA.PERSNL.EMPLOYEE
--- $DATA.PERSNL.EMPLOYEE verified.
.
.
.
--- Verifying $DATA.PERSNL.MGRLIST
--- $DATA.PERSNL.MGRLIST verified.
.
.
.
--- Verifying $DATA.PERSNL.XEMPDEPT
-- $DATA.PERSNL.XEMPDEPT verified.
.
.
.
--- Verifying $DATA.PERSNL.XEMPNAME
-- $DATA.PERSNL.XEMPNAME verified.
.
.
.
>>VERIFY $DATA.SALES.*;
.
.
.
--- Verifying $DATA.SALES.ORDREP
-- $DATA.SALES.ORDREP verified.
.
.
.
--- SQL operation complete.