Manually Restoring a Multistream Archive Using Fewer Streams - NetBackup

Teradata Extension for NetBackup Administrator Guide

Product
NetBackup
Release Number
16.20
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-02
dita:mapPath
bby1489436039204.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2400
Product Category
Teradata Tools and Utilities

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 database BARAC_AC backup was created using four streams. Only two storage devices are available, therefore the example restores streams 1 and 2 in the first job, and streams 3 and 4 in the second job.

  1. Click Teradata Tiered Archive/Restore Architecture > Task > Restore.

    The RESTORE object selection dialog box appears.

  2. Select the object to restore, then File > Build ARC Script.

    The Script Options dialog box appears.

  3. Type a job name.
  4. 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.
  5. Click OK.

    A warning that you are attempting to restore from fewer streams than the streams used for the original backup appears.

  6. Click Cancel.
  7. Click Cancel when asked if you want to revert to the original stream count.
  8. 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.
  9. Click Save, then Launch.
  10. To display information on the job’s progress, double-click the job or stream in Teradata Tiered Archive/Restore Architecture.

    A dialog box appears.



  11. Select a stream to display its information in the bottom pane of the dialog box.
  12. Create a new job for the remaining streams by editing the script for the job that just completed. Click Teradata Tiered Archive/Restore Architecture > Options > Edit or Preview in the Script Options dialog box.

    The Script Editor dialog box opens.

  13. 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 this example, the job restores the remaining two streams of the database BAR_AC backup.



    In the example, 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 from this script, arcmain automatically performs the build step.
  14. Save the job with a name different than the original job name, then click Launch.