Full System Restore Using the BAR Portlets - Teradata Database

Teradata Database Node Software Migration Guide
Product
Teradata Database
Release Number
16.10
Published
November 30, 2017
Language
English (United States)
Last Update
2018-04-25
dita:mapPath
bkn1504122461303.ditamap
dita:ditavalPath
5942_Migrating_1610.ditaval
dita:id
B035-5942
lifecycle
previous
Product Category
Software
When using DSA to restore an archive made on a source system with hardware block-level compression, you must install the hardware compression driver package (teradata-expressdx) on all TPA nodes of the destination system. The installation requires a reboot of these nodes. Because it allows the destination system to read the compressed archive, this requirement applies even if the destination system is not set up for hardware compression.
The teradata-expressdx driver package is provided with systems that are equipped with compression hardware.
These steps wipe the system. Use these steps for a full system restore.

The backup jobs must have successfully completed to create restore jobs from the save sets.

You must create four restore jobs from the two backup job save sets. One includes only the DBC database and three are from the saveset that includes all the databases under DBC and excludes DBC.

  1. On the destination system, run SYSINIT with options appropriate to your system.
  2. On the destination system, start the DBS Database Initializing Program (DIP) and run the following:
    • [Teradata Database 15.0 and later] Run the DIPMIG script, which runs DIPERRS, DIPDB, DIPVIEWS, DIPVIEWSV, and DIPBAR.
    • [Teradata Database 14.10] Run the DIPERRS, DIPVIEWS, and DIPBAR scripts (1, 4, and 21).
  3. On the destination system, check the Time Zone setting status, and disable the setting if it is enabled.
  4. [DSA 16.0 and earlier] From the BAR Setup portlet, check the activation status of the destination system and do one of the following:
    • If the destination system is configured and enabled in the BAR Setup portlet, click Deactivate System, and then click Update system selector for JMS Messages.
    • If the destination system is not configured in the BAR Setup portlet, add the system and click Activate System.
  5. [DSA 16.10 and later] From the BAR Setup portlet, check the activation status of the destination system and do one of the following:
    • If the destination system is configured and enabled in the BAR Setup portlet, click Update for Selector: Update system selector for JMS messages.
    • If the destination system is not configured in the BAR Setup portlet, add the system and click Activate System.
  6. On the destination system, start DSMain from the Database Window (DBW) console supervisor screen by entering: start bardsmain -d DSCName , where DSCName is the unique name of your DSC server
  7. [DSA 16.0 or earlier] After DSMain starts, activate the system in the BAR Setup portlet.
  8. Enable logons for the DBC user only. On the destination system, enter the following from the DBW console supervisor screen: enable dbc logons
  9. Create a DBC-only restore job from the backup job save set that saved only the DBC database:
    1. In the Bar Operations Saved Jobs view, click for the DBC only backup job, and select Create Restore Job.
    2. Enter a Job Name, such as Restore-DBC-Only.
    3. Select a Destination System from the list.
    4. When prompted, enter logon credentials for the current DBC user and password for the target DBS.
    5. Select a Target Group from the list.
    6. Click Job Settings > Set Credentials to enter the credentials for the DBC user and password of the source system at the time the backup save set was generated.
    7. Click Save.
    8. Click for Restore-DBC-Only and select Run.
    9. If there are any errors, follow the instructions in the log file to correct the problem and run the post dbc script again. The post restore script output log files are saved in /var/opt/teradata/tdtemp/post_restore_dbs version .
    After the DBC restore is complete, the DBC password is set to the source system DBC password.
  10. Create a SYSLIB database restore job from the backup job save set of the databases under DBC, excluding DBC:
    1. In the Bar Operations Saved Jobs view, click on the backup job created for the databases under DBC, and select Create Restore Job.
    2. Enter a Job Name, such as Restore-SYSLIB.
    3. Select a Destination System from the list.
    4. When prompted, enter logon credentials for the current DBC user and password for the destination DBS.
    5. Select a Target Group from the list.
    6. On the Objects tab, clear the top checkbox, then expand the tree and select the checkbox for only SYSLIB.
    7. Click Save.
    8. Click on Restore-SYSLIB and select Run.
  11. [Teradata Database 15.00 and later] From the BAR Operations Saved Jobs view, create a TD_SERVER_DB restore job from the backup job save set of the databases under DBC, excluding DBC:
    1. Click for the backup job for the databases under DBC, and select Create Restore Job.
    2. Enter a Job Name, such as Restore-TD_SERVER_DB.
    3. Select a Destination System from the list.
    4. When prompted, enter logon credentials for the current DBC user and password for the destination DBS.
    5. Select a Target Group from the list.
    6. On the Objects tab, clear the top checkbox, then expand the tree and select the checkbox for only TD_SERVER_DB.
    7. Click Save.
    8. Click on Restore-TD_SERVER_DB and select Run.
  12. Create a restore job for all other data from the backup job save set of the databases under DBC, excluding DBC:
    1. In the Bar Operations Saved Jobs view, click for the backup job for the databases under DBC, and select Create Restore Job.
    2. Enter a Job Name, such as Restore-DBC-All.
    3. Select a Destination System from the list.
    4. When prompted, enter logon credentials for the current DBC user and password for the destination DBS.
    5. Select a Target Group from the list.
    6. [Teradata Database 15.00 or later] Clear the checkbox for TD_SERVER_DB in the Objects tab. TD_SERVER_DB has dependencies that must be met before restoration.
    7. Click Save.
    8. Click for Restore-DBC-All and select Run.
    9. If there are any errors, follow the instructions in the log file to correct the problem and run the post data script again. The post restore script output log files are saved in /var/opt/teradata/tdtemp/post_restore_dbs version .
  13. On the destination system, start the DIP and run the DIPALL script.
  14. If you disabled the Time Zone setting on the destination system, enable it.
  15. On the destination system, from the DBW console supervisor screen, enable logons for all users. enable logons