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

Teradata® Viewpoint Installation, Configuration, and Upgrade Guide for Customers - 23.10
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Release Number
23.10
Published
October 2023
Language
English (United States)
Last Update
2023-11-01
dita:mapPath
ycr1693898939625.ditamap
dita:ditavalPath
acl1501004736403.ditaval
dita:id
ulq1467244577135
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.