SQL/MP Installation and Management Guide

Performing Recovery Operations
HP NonStop SQL/MP Installation and Management Guide—523353-004
11-16
Operations That Invalidate TMF Online Dumps
Table 11-1. SQL/MP Operations That Invalidate TMF Online Dumps
SQL Statement Option Effect Recovery Strategy
ALTER INDEX
and
ALTER TABLE
NO AUDIT Invalidates all online
dumps of the affected
object. The object does
not have any TMF file
recovery protection if it
is not audited.
If the AUDIT attribute is
later turned back on, make
new online dumps of all
partitions of the index or
table to retain TMF file
recovery protection.
ADD
PARTITION
(with data
movement)
Invalidates all online
dumps of the source
partition.
Make new online dumps of
the source partition and
added partition to retain
TMF file recovery
protection.
MOVE
(simple move)
Invalidates all online
dumps of the source
partition.
Make a new online dump
of the moved partition to
retain TMF file recovery
protection.
MOVE
(one-way split)
Invalidates all online
dumps of the source
partition.
Make new online dumps of
the source partition and
moved partition to retain
TMF file recovery
protection.
MOVE
(two-way split)
Invalidates all online
dumps of the source
partition.
Make online dumps of the
new partitions to provide
TMF file recovery
protection.
RENAME Invalidates all online
dumps of the renamed
object.
Make a new online dump
of the renamed object to
keep TMF file recovery
protection for it.