- Use the Appliance Backup Utility GUI to create a restore job.
- Add any STREAM, STREAMNAME, or DESTINATIONPATH overrides to the script.
- STREAM lines
Assign a client to each stream. The first STREAM line represents stream 1, and so on. The STREAM lines must be located immediately after the MULTISTREAM line. Modify these lines only if you need to change client stream assignments.
- DESTINATION PATH lines
Assign a directory path to a stream's image. The first DESTINATIONPATH represents the path assigned to stream 1, and so on. DESTINATIONPATH lines must be located after STREAM lines and before the SCRIPT line.
Add a value to the right of the DESTINATIONPATH keyword, as in the following example. If there is no value, the first path defined for that stream's client is used.
STREAMNAME lines are optional. Assign a stream image name to each stream. A stream image name is the file name of the stream that was backed up at the primary site and is now accessible to the secondary site. If STREAMNAME lines are present, they must be located immediately after STREAM lines and must account for all the streams. The first STREAMNAME line represents stream 1, and so on.
In the script, replace the ARCMAIN keyword RESTORE with COPY and assign the JobID that created the backup image dataset as the SOURCEUID value. The JobID is the name of the JobFile that was copied from the primary Teradata system.
In the following example, there are four streams in the job that backs up the primary Teradata Database instance. The secondary site has two Teradata Database nodes that can access the four primary stream images as mount points.
JOB T505_from_prod SESSIONS 4 MULTISTREAM 4 STREAM smp001-7 STREAM smp001-8 STREAM smp001-7 STREAM smp001-8 STREAMNAME T505_from_prod_4d7912ba00000003_DSTREAM0001 STREAMNAME T505_from_prod_4d7912ba00000003_DSTREAM0004 STREAMNAME T505_from_prod_4d7912ba00000003_DSTREAM0002 STREAMNAME T505_from_prod_4d7912ba00000003_DSTREAM0003 COMMANDLINE TDPID barbunk USERID dbc PASSWORD LoNHBWeIkEaCKwOIl0_yGeLz7KcdppR7KmQaZHX5orhN3Tqt1c8uNGATAsSTmmgXyBZahYS35E71zZ0x SOURCEUID 4d7912ba00000003 DESTINATIONPATH /var/abu_storage/disk1 DESTINATIONPATH /var/abu_storage/disk4 DESTINATIONPATH /var/abu_storage/disk2 DESTINATIONPATH /var/abu_storage/disk3 SCRIPT Restore LOGON $LOGON; COPY DATA TABLES (……………), RELEASE LOCK, FILE=ARCHIVE; LOGOFF; ENDSCRIPT