Note
OceanBase Database V4.x does not support restore points. This view has been deprecated since OceanBase Database V4.0.0.
Purpose
The V$RESTORE_POINT view displays the information about restore points.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | YES | The ID of the tenant. |
| SNAPSHOT | bigint(20) | NO | The database system change number (SCN) when the restore point was created. |
| TIME | timestamp(6) | NO | The time when the restore point was created. |
| NAME | varchar(512) | YES | The name of the restore point. |
Sample query
Query all restore points in the current tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.V$RESTORE_POINT;
The query result is as follows:
+-----------+------------------+----------------------------+----------+
| TENANT_ID | SNAPSHOT | TIME | NAME |
+-----------+------------------+----------------------------+----------+
| 1001 | 1710987516261317 | 2024-03-21 10:18:36.263262 | rt1 |
| 1001 | 1710987957553230 | 2024-03-21 10:25:57.554246 | rt_mysql |
+-----------+------------------+----------------------------+----------+
2 rows in set