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.
-
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
- Click 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.