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.
- On the primary system, create a backup job using the Backup Selected Objects or the Backup All option.
- Launch the backup job using the GUI or abulaunch.
- (Optional) Use the cron utility to schedule and automatically launch the job.
-
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.
-
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.
-
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.
-
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:
-
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
-
Use the Appliance Backup Utility GUI on the secondary system to create a restore job or use a script template to automate the job:
- With the Appliance Backup Utility GUI, use the Restore Selected Objects option. Do not use the Restore Latest option.
- Assign the Stream 1 image name in the backup job to Stream 1 of the restore job.
-
(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.
- Update the UserName and Password.
-
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.
- Launch the restore job from the Appliance Backup Utility GUI or abulaunch.