To restore a database or table from a multistream backup when one or more of the disk or tape storage devices is unavailable, the restore job must be divided into two or more jobs.
-
Click
.
The RESTORE object selection dialog box appears.
-
Select the object to restore, then
.
The Script Options dialog box appears.
- Enter a job name.
-
To reassign client streams, click Assign Clients.
The Assign Clients dialog box opens.
- Select a client group or node for each stream, then click OK.
-
In the Multi stream box of the Script Options dialog box, change the number of streams to the number of streams that are available.
For example, if a backup job was created using 16 streams but only 4 storage devices are available for the restore job, select 4 streams.
A dialog box requests validation of the client and stream assignments, and the stream count.
-
Click OK if the client and stream assignments are correct.
If you click Cancel, the original stream count is restored.
A dialog box notifies you that multiple jobs must be created to complete the entire restore job.
-
Click OK.
Job scripts are created for the streams that were specified and are displayed in the Teradata Tiered Archive/Restore Architecture dialog box.
-
In the Teradata Tiered Archive/Restore Architecture dialog box, select the first job script.
In the example, 4 streams are specified for a restore job called new_test. The scripts that are created for the job are:
-
new_test_1.res
-
new_test_2.res
-
new_test_3.res
-
new_test_4.res
Each job script contains 4 of the 16 streams specified in the backup job and must be run sequentially. In the example, new_test_1.res would be run first.
-
- Click Launch, then confirm job launch.
- Select and launch the next job that was created for the multistream restore job. In the example, new_test_2.res would be run.
- Run the remainder of the job scripts sequentially.
-
[Optional] To display information job progress:
- Double-click the job or stream in the Teradata Tiered Archive/Restore Architecture dialog box. A dialog box appears with the job name.
- Select a stream to display its information in the bottom pane of the dialog box.