vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/opengauss/umn/opengauss_01_0066.html
Wang , Deng Ke 04da47cae2 openGauss UMN 20221109 version 
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Wang , Deng Ke <wangdengke2@huawei.com>
Co-committed-by: Wang , Deng Ke <wangdengke2@huawei.com>
2022-11-29 07:39:44 +00:00

5.9 KiB
Raw Permalink Blame History

Restoring DB Instances to a Specific Point in Time

Scenarios

You can use an automated backup to restore a DB instance to a specified point in time.

Backups can be restored to a new DB instance.

Constraints

  • If you restore backup data to a new DB instance:
    • The DB engine and major version are the same as those of the original DB instance and cannot be changed.
    • You need to set a new administrator password.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List. Under Database, click GaussDB.
  4. In the navigation pane on the left, choose GaussDB(openGauss) > Instance Management.
  5. On the Instance Management page, click the target DB instance.
  6. In the navigation pane on the left, choose Backups & Restorations. On the displayed page, click Restore to Point in Time.
  7. Select a restoration date and time range, enter a time point within the selected time range, and click OK.

    Restoring data to a new DB instance

    The Create New Instance page is displayed.

    • The DB engine and version of the new DB instance are the same as those of the original DB instance and cannot be changed.
    • Storage space of the new DB instance is the same as that of the original DB instance by default and cannot be less than that of the original DB instance. The administrator password needs to be reset.
    • The instance class of the new DB instance is the same as that of the original DB instance by default and must be greater than or equal to that of the original DB instance.
    • The number of CNs and shards of the new DB instance must be the same as that of the original DB instance during the backup.

    Select an existing DB instance and click OK.

  8. View the restoration result.

    Restoring data to a new DB instance

    A new DB instance is created using the backup data. The status of the DB instance changes from Creating to Available.

    The new DB instance is independent from the original one.

    On the Instance Management page, the status of the DB instance changes from Restoring to Available.

    A full backup is triggered after the new DB instance is created.

Parent topic: Backup and Restoration