SQL/MP Installation and Management Guide

Performing Recovery Operations
HP NonStop SQL/MP Installation and Management Guide—523353-004
11-18
Recovering Views and Indexes
The disadvantage is that it requires a lot of work because you must continually
keep track of all interdependent objects and process many tapes during
recovery.
°
If you perform collective dumps of the SQL catalog and all its objects, you
might gain a faster recovery, but you must continually update the SQL OBEY
command files that you use to rebuild your SQL objects.
Finally, before dropping an object, check that you have:
•
A current OBEY command file for re-creating your objects
•
Output from a SQLCI DISPLAY USE OF command, showing for each object the
other objects that depend upon it
•
Current online dumps of the objects
•
Hard copies of the TMF catalog and object dumps, obtained with the TMFCOM
INFO DUMPS, OBEYFORM command
Recovering Views and Indexes
If the SQL object purged is a view or an index and its related table still exists in the
system, you can recover the object by simply re-creating it:
•
An SQL view does not contain data. The data referenced by the view is stored in
the underlying table. Therefore, you can easily return a purged view to the
database by re-creating the view definition using the SQLCI CREATE VIEW
statement. After you recover the view, be sure to make a new online dump of the
view and its related table.
•
An SQL index specifies an alternate access path to a table. You can recover a
purged index by re-creating it using the SQLCI CREATE INDEX statement. This
approach ensures that the new index includes keys for all rows of the table. After
you recover the index, make a new online dump of the index and its related table.
You can also recover a view or an index by using the TMFCOM RECOVER FILES
command, using the steps described under Recovering Tables on page 11-19.
However, because it is potentially more complex and open to error, do not use the
TMFCOM RECOVER FILES command if you are attempting to recover views and
indexes only. To recover only views or indexes, use the SQLCI CREATE statements
discussed previously.
Note. You can use OBEY command files containing TMFCOM command scripts for
TMF tasks that you perform repeatedly.