TMF Operations and Recovery Guide (G06.24+)

Managing SQL Objects
HP NonStop TMF Operations and Recovery Guide—522417-002
C-4
Operations for SQL/MP Only
If you mistakenly alter the AUDIT attribute from audited to nonaudited and the table
has not been modified since it was altered to nonaudited, do the following to restore
the table to its original condition:
•
Change the AUDIT attribute back to audited.
•
Make a new online dump of the table.
If you mistakenly alter the AUDIT attribute from audited to nonaudited and the table
has been modified since it was altered to nonaudited, do the following to restore the
table to its original condition:
•
Alter the AUDIT attribute back to audited.
•
Validate the dump entry in the TMF catalog by using the TMFCOM ALTER DUMPS
command; if the entry has been deleted from the catalog, use the TMFCOM ADD
DUMPS command to replace the entry.
•
Recover the table with the TMF file recovery feature using the TMFCOM
RECOVER FILES command with the TOFIRSTPURGE attribute. The table will be
recovered up to the records marking it as nonaudited. At the end of the recovery,
the table will be left as audited.
•
Make a new online dump of the table.
Altering the AUDIT attribute of a crashed table from audited to nonaudited and then
altering it back to audited has the following results:
•
The crash-open, undo-needed, and redo-needed flags for the table are cleared
erroneously.
•
All online dump entries for the table are marked RELEASED ON and INVALID ON,
so a dump can be accidentally deleted from the TMF catalog.
•
No TMF recovery of the crashed table can be performed. If the object is
inconsistent, you must repair it manually.
Determining if an SQL/MP Object is Audited
The FUP INFO and SQLCI FILEINFO commands can be used interchangeably to
display the audited and open state of objects. The output of both commands is very
similar, and includes the letter A as the file code if the table is audited:
113> FUP INFO $DATA.EMP.EMPDATA
CODE EOF LAST MODIF OWNER RWEP TYPE REC BLOCK
$DATA.EMP
EMPDATA A O 16:24 8,86 OOOO K Ta 460 4096
114> SQLCI
>> FILEINFO $DATA.EMP.EMPDATA;
CODE EOF LAST MODIF OWNER RWEP TYPE REC BLOCK
$DATA.EMP
EMPDATA A O 16:24 8,86 OOOO K Ta 460 4096