All Products
Search
Document Center

CREATE RESTORE POINT

Last Updated: Jun 18, 2021

Description

You can use this statement to create a restore point. You can use this feature to create a data snapshot for the current moment and query data in this data snapshot in the future. The current OceanBase Database version does not support data rollback to this restore point.

After you create a restore point, you can query the snapshot value of this restore point in the V$RESTORE_POINT view, and then run SELECT * FROM table_name AS OF SNAPSHOT snapshot; to query values in the data snapshot.

Notice

You cannot create restore points under the system tenant.

Syntax

obclient> CREATE RESTORE POINT restore_point;

Parameters

Parameter

Description

restore_point

Specifies the name of the restore point.

Example

  • Create restore point rp1.

    obclient> CREATE RESTORE POINT rp1;
    Query OK, 0 rows affected (0.01 sec)