SQL/MP Installation and Management Guide

Performing Recovery Operations
HP NonStop SQL/MP Installation and Management Guide—523353-004
11-27
Recovery Example
Recovering Files to New Volumes, Subvolumes, or File-IDs
You can also re-create SQL objects under different file IDs and place them on different
volumes or subvolumes than the source objects. Target objects can be created in a
different SQL catalog, but the target object description in the catalog must match that in
the source catalog. For example, in the case of a partitioned file, both the target and
source files must have the same number of partitions. Indexes for the target and
source files must match.
Because TMF does not apply SQL file-label modification records encountered in an
audit trail for a source object being recovered to the target object, the file label in the
online dump must match the file label of the newly created target, and the target’s file
label must match the final form of the source file label. Therefore, to recover to a new
location, you must take new online dumps each time the file label is modified.
SQL objects being recovered to a new location must be created before recovery, and
the target objects must exactly match the source objects. If you attempt to recover
without creating the target object, the restore process fails with Error 9037, as shown in
this example, and the object is not recovered:
NonStop TMF on \PLUTO *0202* RECOVER FILES [58]
OnLineRestore Process #1 OnlineDumpMgmt: *ERROR*
TMF-9037: $DATA17.PERSNL.EMPLOYEE: File System error 11
occurred attempting to retrieve the SQL file label from
disk.
If, for any other reason, the target object is inaccessible during the restore process, this
process also fails with Error 9037. For example:
NonStop TMF on \PLUTO *0202* RECOVER FILES [58]
OnLineRestore Process #1 OnlineDumpMgmt: *ERROR*
TMF-9037: $DATA17.PERSNL.EMPLIST: File System error 1059
occurred attempting to retrieve the SQL file label from
disk.
If TMF detects a mismatch between the source file’s label and the target file’s label, the
object’s recovery fails with Error 9036. For example:
NonStop TMF on \PLUTO *0202* RECOVER FILES [59]
OnLineRestore Process #1 OnlineDumpMgmt: *ERROR*
TMF-9036: $DATA17.PERSNL.EMPLOYE2: The SQL label for this file
does not match the label for the source $DATA17.PERSNL.EMPLOYEE.
If no mismatches occur, file recovery completes successfully. At the end of this
recovery, verify the SQL objects recovered to a different location and perform Step 9
on page 11-26 if needed.
When recovering purged SQL objects to a different location, you do not need to re-
create the source objects before recovery. Only the target objects must exist and
match the source objects in terms of indexes, number of partitions, and so forth. You
Caution. Do not attempt to recover SQL catalog files to a new location, because this action
creates unusable SQL objects.