SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

Performing Recovery Operations
HP NonStop SQL/MX Installation and Management Guide—544536-007
12-5
Recovering Files to New Locations
are located on $DATA10 for the source and $DATA12 for the target, you can use the
RECOVER FILES command to recover these objects:
RECOVER FILES $DATA10.ZSDT5356.*, NOT $DATA10.ZSDT5356.*1, &
MAP NAMES ($DATA10.ZSDT5356.* TO DATA12.ZSDT3122.*)
SQL/MX objects being recovered to a new location must be created before the
recovery process is run, and the target objects must exactly match the source objects.
If you attempt to recover without creating the target object, the restore operation 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.ZSDT5356.J24Z5J00: 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.ZSDT5356.J24Z5J00: 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.ZSDT5356.J24Z5J00: The SQL label for this
file does not match the label for the source
$DATA16.ZSDT5356.J24Z5J00.
If no mismatches occur, file recovery completes successfully. At the end of this
recovery, perform Step 9 through Step 15 under Example: Recovering an Accidentally
Dropped Table on page 12-14 for the target SQL/MX objects as needed.
When recovering dropped SQL/MX objects to a different location, you do not need to
re-create the source objects before the recovery. Only the target objects must exist and
match the source objects in terms of indexes, number of partitions, and so forth. You
must alter the dumps of the purged objects to reset the INVALID and RELEASED flags
before attempting the recovery.