Example 2: Restore Script for Single Node Backup - Tivoli

Teradata Extension for Tivoli Storage Manager Administrator Guide

Product
Tivoli
Release Number
16.20
16.10
Published
May 2017
Language
English (United States)
Last Update
2019-03-22
dita:mapPath
beb1489436039198.ditamap
dita:ditavalPath
beb1489436039198.ditaval
dita:id
wkq1486409855180
Product Category
Teradata Tools and Utilities

This example restores a backup that originates from a single TSM node, NODE1. To restore the latest generation of the first backup, change the ARCMAIN script to use a RESTORE or COPY statement. The command line stays the same.

To create this type of backup:

  1. Ensure that the file pointed to by ARCDFLT environment variable is Iomodule=’tivbar.dll’.
  2. On the command line, type:

    tivarc <arcin.txt

Output

arcin ARC Script

Logon td1/dba1 , pwd;
Restore data tables (db1)
,  release lock
,  file=  db1_data;
Logoff  ;
Backup Information in the TSM Catalog
  • Node = NODE1
  • Filespace = Teradata
  • High Level = db1_data
  • Low Level = F0000, 0001, F0002, and so on

Other Considerations

To restore the backup generation just before the latest backup, use this IOPARM value:

tivarc <arcin.txt ioparm=’generation=-1’

For information about specifying relative and absolute generation numbers, see Parameter Definitions.