Restoring the Repository - Data Stream Architecture

Teradata Data Stream Architecture (DSA) User Guide

Product
Data Stream Architecture
Release Number
16.10.01
Published
November 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
fyx1509665931452.ditamap
dita:ditavalPath
3150_DSA_UG_1610.ditaval.ditaval
dita:id
B035-3150
Product Category
Software
Teradata Tools and Utilities
This task describes how to restore a backup of DSC repository metadata.
If you abort a DSC repository restore job while the job is in progress or if the restore job fails, DSC repository metadata will be corrupted. DSC triggers a command to restore all repository tables to their initial state, which is an empty table.
  1. From the DSC Servers list, select your DSC server.
  2. From the Categories list, click Repository Backup.
  3. Click Restore DSC Now. During the restore job, the BAR Setup and BAR Operations portlets are unavailable.
  4. Select a save set to restore.
  5. Click Continue.
  6. If the restore job ends with a warning, follow these steps:
    1. Check the job status. In the following example, repo1_restore_job is the job name.
      dsc.sh job_status -n repo1_restore_job -B
    2. If the status indicates the foreign keys were not restored, run the foreign key repair script at /opt/teradata/client/version/dsa/dsc/recreateFk_version.sh. When the restore job is complete, the BAR Setup and BAR Operations portlets become available.
  7. After the repository restore job is complete, perform a tpareset of the DSC repository database.