To restore a database or table from a multistream backup when one or more of the disk or tape storage devices is unavailable, divide the restore into two or more jobs. In the next example, the backup job for the multistream-4streams database was created using four streams. Only two storage devices are available, therefore streams 1 and 2 are restored in the first job, and streams 3 and 4 in the second job.
-
Click .
The RESTORE object selection dialog box appears.
-
Select the object to restore, then .
The Script Options dialog box appears.
- Type a job name.
-
In Multi stream, change the number of streams to the number of streams that are available.
A dialog box advises reassigning the original clients and their streams before selecting fewer streams.
In this example, two streams are specified.
- Click OK. A warning that you are attempting to restore from fewer streams than the streams used for the original backup appears.
- Click Cancel.
- Click Cancel when asked if you want to revert to the original stream count.
- Select the Skip Build Steps check box. The build step must be done only by the last restore job for this database, or separately, after all restore jobs have completed.
-
Click Save, then Launch.
To display information on the job progress:
- Double-click the job or stream.
A dialog box appears.
- Select a stream to display its information in the bottom pane of the dialog box.
- Double-click the job or stream.
-
To create a new job for the remaining streams by editing the script for the job that just completed, click or Preview in the Script Options dialog box.
The Script Editor dialog box appears.
-
Add the keyword STREAMNAME for each stream included in this job.
The value of each STREAMNAME keyword is the name of each of the remaining streams.
In the following example, the job restores the remaining two streams of the database multistream-4streams backup.
The NO BUILD statement is not removed from the script, therefore a separate ARCMAIN build is required after job completion. If the NO BUILD statement is removed, ARCMAIN automatically performs the build step. - Save the job with a name different from the original job name, then click Launch. View the job in the Teradata Tiered Archive/Restore Architecture dialog box and the Job History dialog box.