If the data in a database VM is corrupted, Data Management for VMware Tanzu enables you to recover the database VM to resolve the issue. If the Namespace used to create the database VM is associated with both the Provider Administrator and the owner of the database VM, the Provider Administrator, can recover the database VM. An Organization Administrator can recover database VMs that are part of the organization. An Organization User can recover database VMs created by the <%=vars.org_user %.
You can recover a database VM either to an existing backup of the database VM or to a customised time and date that you specify. When you choose to specify a customised date and time for the recovery operation, the database VM recovers to the backup that is closest to the mentioned date and time. If you have not enabled automated backups for a database VM, you cannot recover it to a customised date and time of your choice. You have to align the recovery of such database VMs to the existing manual backups.
You cannot recover replicas of a Primary database. If you recover a Primary database from a backup that is created earlier than the replica, the replicas of the Primary database become INACTIVE. You need to delete the replicas in the INACTIVE state and create replicas of the Primary database again.
Perform the following procedure to recover a Standalone or Primary database:
Select Databases from the left navigation pane.
This action displays the Databases view, a table that lists the provisioned databases.
Examine the database VMs listed in the table, identify the database you want to recover, and navigate to that table row.
Click the DATABASE ACTIONS button in the top right corner of the view, and select Recover from the drop-down menu.
The Recovery form displays.
Set the following properties to recover the database:
|Property Name||Value||Default Value|
|Recovery Point||Use the drop-down list to select either Recover from Backup or Custom Timing.||Recover from Backup|
|Choose Backup||When you select Recover from Backup, select the backup from the drop-down list.||The latest backup of the database that is available|
|Choose Date||When you select Custom Timing, set the date of recovery.||The date of the latest backup|
|Choose Time||When you select Custom Timing, set the time of recovery.||The time of the latest backup|
Click RECOVER in the Recovery form.
The Confirm Recovery dialog displays that provides you information about the recovery function.
Click CONFIRM in the Confirm Recovery dialog.
Monitor the progress of the operation in the Operations tab or in the Database Operations view:
Locate the RECOVER DB operation type and click it.
Select the State History tab to view the subtasks of the operation and their status.
If the operation fails, select the Error Info tab to examine the returned error information.
When the database has automated backups enabled, a successful restore operation of the database VM triggers Data Management for VMware Tanzu to initiate a full backup of the recovered database.