Restoring Data to a Second Instance - BAR

Teradata Appliance Backup Utility Installation and User Guide

Product
BAR
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-07-13
dita:mapPath
dhb1488824663275.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-3134
lifecycle
previous
Product Category
Teradata Tools and Utilities
The process to restore data to a second instance of a Teradata Database requires the Appliance Backup Utility GUI, the abulaunch utility, and a script or command-line interface. You can also use the cron utility to schedule and launch the job.
  1. On the primary system, create a backup job using the Backup Selected Objects or the Backup All option.
  2. Launch the backup job using the GUI or abulaunch.
  3. (Optional) Use the cron utility to schedule and automatically launch the job.
  4. Copy the ABU backup jobfile to the secondary site's ABU job repository using a script or command-line interface, as shown in the following Linux example.
    1. At a command-line prompt, list the job files in the job information repository on the primary Appliance Backup Utility server. In the example, bar1 is the primary server, $ABUPARMS represents -u administrator, and -ethe path to encoded password file:
      bar1:~ # abujobquery $ABUPARMS -L
      List of summary Job information for all Job Files in the Job Information
      Repository on ABU Server '120.0.0.3'.
      File Name/Job ID       Job Name                         Date         Stream Cnt
      4cacebaa00000001  test1-cdbuild                  2010-10-06 14:41:33      2
      4cacebaa00000002  R-test1-cdbuild                2010-10-06 14:42:33      2
      4cacebaa00000003  test2-cdbuild-mntpointnotavail 2010-10-06 14:49:15      2
      4cacf20600000001  test1                          2010-12-01 13:24:49      2
      4cacf20600000002  mm_xrst                        2011-02-25 07:56:10      2
      4cacf20600000003  mm_xrst                        2011-02-25 08:15:00      2
      4cacf20600000004  mm_xrst                        2011-02-25 08:16:40      2
      4cacf20600000005  mm_xrst2                       2011-02-25 08:34:09      2
      4cacf20600000006  bb_sfe_2str                    2011-03-03 10:45:24      2
      4cacf20600000007  BackupAll                      2011-03-10 08:06:51      2
      4cacf20600000008  T505_to_brun                   2011-03-10 09:51:03      2
      List of summary Job information completed.
    2. Copy the file to the secondary server. In the example, 4cacf20600000008 is copied to bar2.
      bar1:~ # scp -p /var/opt/teradata/abu_service/service/jir/4cacf20600000008 root@bar2:/var/opt/teradata/abu_service/service/jir 
      4cacf20600000008       100% 9316     9.1KB/s   00:00

      If the destination paths are not shared between the two sites, copy the STREAMNAME values in the image name created by the backup job from the primary site to the secondary site.

      Stream 1 in an Appliance Backup Utility backup or restore job is the parent stream. All other streams in the job are child streams, which are directed by the parent stream.
  5. If you don't see abu_service on the secondary server, change the job file owner from root to abuservice in /var/opt/teradata/abu_service/service/jir:
    bar2: # ls -l 4cacf20600000008    -rw------- 1 root root 9316 Mar 10 09:58 4cacf20600000008
    
    bar2: # chown abuservice 4cacf20600000008
    
    bar2: # ls -l 4cacf20600000008    -rw------- 1 abuservice root 9316 Mar 10 09:58 4cacf20600000008
  6. Use the Appliance Backup Utility GUI on the secondary system to create a restore job or use a script template to automate the job:
    1. With the Appliance Backup Utility GUI, use the Restore Selected Objects option. Do not use the Restore Latest option.
    2. Assign the Stream 1 image name in the backup job to Stream 1 of the restore job.
    3. (Optional) If the secondary Appliance Backup Utility has fewer clients than the primary Appliance Backup Utility, use the Assign Clients dialog box to adjust the streams-to-client ratio on the secondary Appliance Backup Utility. For example, if the primary system has four clients and the secondary system has three clients, configure one of the clients in the secondary system for two streams.
      The backup images assigned to the child streams of the secondary restore job can be in any order if the Appliance Backup Utility clients have access to the image files.
    4. Update the UserName and Password.
    5. Edit the ARCMAIN script. In the Script Options dialog box, enter a job name. Click Preview to edit the job. In the Script Editor, replace the ARCMAIN keyword RESTORE with COPY.
      The target database needs to exist in the destination Teradata Database when you use the ARCMAIN COPY command. COPY creates a new table if it does not already exist on the target database.
  7. Launch the restore job from the Appliance Backup Utility GUI or abulaunch.