PrerequisiteBefore attempting to restore a backup, make sure you meet the following prerequisites for restoring data to same-site.
- You have the environment hosted either on AWS or Azure cloud platforms.Google Cloud platform doens't support self-service restoration of data.
- 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:
- Sign on into the application.
- In the Environments pane, select your environment.
- In Manage Data, select Data protection.
- In the Restore points tab, select the restore point to restore.
- Select , then Restore.
- Enter the Restore Job name and click Next.
- In the Objects, select the required objects, such as, databases and tables to restore and select Next.
- [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.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.
Skip statistics Select to skip collecting statistics during a backup or restore job. - Select Save & Run.
- If requested, provide credentials, and select Save & Start.
- Open the History tab and check the Status of the restore job.You can't restore data while VantageCloud Lake upgrades are in progress.