Restore the Postgres DSC Repository: Command Line | Teradata DSA - Restoring the Postgres DSC Reporitory When Any or Old Bootstrap File is Available: Command Line - BAR - Data Stream Architecture

Teradata® DSA User Guide

Product
BAR
Data Stream Architecture
Release Number
17.10
Published
April 2022
Language
English (United States)
Last Update
2022-04-08
dita:mapPath
het1611950545663.ditamap
dita:ditavalPath
vwp1576617377804.ditaval
dita:id
B035-3150
lifecycle
previous
Product Category
Software
Teradata Tools and Utilities
  1. Copy the bootstrap_<backupID>.out into the landing zone and run the following commands.
    (default is: /var/opt/teradata/dsa/postgres)
  2. Navigate to /opt/teradata/client/17.06/dsa/dsc: cd $DSA_DSC_ROOT
  3. User:
    su dscuser
  4. Restore the repository:
    sh recover.sh -m recovery
  5. Check the list of backup IDs available on the replication target group:
    sh recover.sh -m list_backupids -r replicating_target_group
  6. Get the bar_<backupID>.out from replication target group:
    sh recover.sh -m replicate_from -v <backupID> -r <replicationTargetGroupName>
    For example, sh recover.sh -m replicate_from -v 1602081495349 -r TGP
  7. Check the replication status:
    sh recover.sh -m save_sets_replication_status
  8. Restore the backup:
    sh recover.sh -m restore -v <backupID>
    For example, sh recover.sh -m restore -v 1602081495349
  9. Exit dscuser:
    exit
  10. Restart DSC:
    /etc/init.d/dsc restart