Database Backup (DBS) allows you to restore data by database or table. If data is deleted from a specific database or table by mistake, you can restore the database or table without the need to restore the entire database instance. This shortens the recovery time objective (RTO).
- Log on to the DBS console.
- In the left-side navigation pane, click Backup Schedules. On the Backup Schedules page, select a region in the upper-left corner.
- On the Backup Schedules page, find the ID of your backup schedule and click Manage in the Actions column.
- On the Configure Task page, click Restore Database in the upper-right corner.
- In the Set Time Restored To step, set the parameters in the Set Time Restored To and Configure Destination Database sections and click Next. Note
- If the incremental backup feature is enabled, DBS allows you to restore the data to a point in time from the completion of the first full backup to the completion of the last incremental backup.
- If the incremental backup feature is disabled, DBS allows you to restore the data to a point in time when a full backup is complete.
- In the Configure Objects to Restore step, set the Conflict Handling parameter and specify the databases or tables to be restored in the Objects to Restore section.
Parameter Description Conflict Handling Select one of the following methods for conflict handling:
- Fail when Object with the Same Name Exists.
- Rename Object with the Same Name: If you select this option, DBS renames the new table that is to be created by the
restore task. For example, a table to be restored in the source database and an existing
table in the destination database have the same name
job_info. The system renames the new table that is restored from the table in the source database in the following format:
job_info_dbs_<ID of the restore task>_</Timestamp>.
Objects to Restore The database or table that you want to restore. Select the database or table that you want to restore in the Available section and click the right arrow to add it to the Selected section. In this example, only the
sbtest100tables are selected for restoration.
- In the lower-right corner of the page, click Precheck. The system checks the preceding configurations, database connectivity, and database permissions.
- After the Precheck Passed message appears in the Precheck dialog box, click Start Task. After you click Start Task, you can click Restore Tasks in the left-side navigation pane to view the database restoration progress on the details page of the backup schedule.Note The restoration time depends on the data volume and backup schedule specifications. For more information, see Performance description of backup and restoration.