Restore Data from a Restore Point |Teradata VantageCloud Lake - Restore Data from a Restore Point - Teradata VantageCloud Lake

Lake - Manage and Move Data
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
atx1683670417382.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
atx1683670417382
PrerequisiteBefore attempting to restore a backup, make sure you meet the following prerequisites for restoring data to same-site.
  • Self-Service Restoration of data on the same site is now supported on AWS, Azure, and GCP. Note that .
    The restore points created prior to February 2025 in GCP, are not eligible for self-service restoration
  • You have organization administrator privileges to create and restore backup jobs.
  • You have restore access rights to restore data to the target database on the target system. Use GRANT RESTORE ON "dbcmngr" TO <td-username>; to grant the privilege.
  • Grant create, alter, and drop permissions to the user.

    You must have the database credentials of the user, that is, <td-username> and its <password. Make sure the <td-username> has drop/create/alter permissions on the target database to restore data to the target system. For example, to restore data to a database named dbcmngr on the target system, use the following command to give drop/create/alter permissions.

    GRANT all on "dbcmngr" to <td-username>;

To restore backups:

  1. Sign on into the application.
  2. In the Environments pane, select your environment.
  3. In Manage Data, select Data protection.
  4. In the Restore points tab, select the restore point to restore.
    To do a full system restore (applicable only on AWS), select the appropriate Full System Restore eligible plan and select Restore.
  5. Select , then Restore.
  6. Enter the Restore Job name and click Next.
  7. In the Objects, select the required objects (including MOTF, if your backup supports), such as, databases and tables to restore:
    • For full system restore, select Include the most recent DBC backup data to restore metadata about the database system, including details about databases, tables, columns, indexes, users, privileges and more. If prompted, enter the login credentials for the restore point.
      For full system restore, the MOTF objects are excluded from the CSR-DR backup jobs and the failover jobs.
    • For full system recovery, make a note of the DBC credentials while creating the restore point. You’ll need them when restoring data from the Restore Points.
  8. Select Next.
  9. [Not applicable for full system restore]. In the Job settings tab select the required option from the following scenarios.
    Option Details
    Same database Restores data to the same database.
    Suffix in Renamed restored tables

    Select to add a suffix for renamed tables to differentiate from the original.

    Applicable only if tables are selected and not applicable if the selected restore point has only one table in the database, in which case, selecting the table selects the database. Also, not applicable for MOTF objects.
    Different database
    This option is available only when you select full databases but not individual tables.
    		 Restores data to the selected database.

    Enter the connection credentials to establish a connection, if required.
    Cancel job in access rights violation occurs

    The restore job proceeds even when the DUMP access rights violation occurs.

    Not applicable for full-system recovery.
    Skip statistics Select to skip collecting statistics during a backup or restore job.
  10. Select Save & Run.
  11. If requested, provide credentials, and select Save & Start.
  12. Open the History tab and check the Status of the restore job.
    You can't restore data while VantageCloud Lake upgrades are in progress.