Restore a Teradata Viewpoint Database | Teradata Viewpoint - Restoring a Teradata Viewpoint Database - Teradata Viewpoint

Teradata® Viewpoint Installation, Configuration, and Upgrade Guide for Customers
Product
Teradata Viewpoint
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-05-30
dita:mapPath
ktu1628075596955.ditamap
dita:ditavalPath
acl1501004736403.ditaval
dita:id
B035-2207
lifecycle
previous
Product Category
Analytical Ecosystem
  1. If the Teradata Notification Service is running on a Windows server, stop this service.
  2. If the backup files are located on network storage or on a third-party application backup server, do the following:
    1. Copy the backup files to /data/backup on the Viewpoint server being restored.
    2. Make sure the directory and file permissions within /data/restore are readable by the postgres Linux user.
  3. Run the /opt/teradata/viewpoint/bin/restore.sh script.
  4. Validate that the script completed successfully by looking for the message: Restore or migration performed successfully. If historical data is also being restored or migrated, progress of this operation can be viewed in the portal's notification bar.
    If the restoration process fails, an error message is displayed instead of the success message.
  5. If a warning message appears in the notification bar with the message Tables were skipped during migration…, do the following:
    1. Open restoreFailedFilesList.json from /etc/opt/teradata/Viewpoint.
    2. Get the list of files which failed during restore from /data/backup.
    3. Delete the files in the failed list from /data/backup.
    4. Take a fresh backup.
    5. Run the restore script with the Full restore option.
    6. Provide y to the command prompt to restore only on the failed files from previous restore.
      Another prompt appears as following:

      Verify if fresh backup of the files are taken. Do you want to continue the restore process on failed list of files?

    7. Provide y. If the restoration process succeeds, a success message appears.
      The restoreFailedFilesList.json gets updated with every restore.
  6. If the restoration process fails or is interrupted in any manner, fix the problem that caused the failure and perform these steps again.
  7. If you want the Teradata Notification Service to run on a Windows server, start this service.