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 cluster.
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 |
| 1002 | 1710987930807517 | 2024-03-21 10:25:30.808594 | RT_ORACLE |
| 1001 | 1710987957553230 | 2024-03-21 10:25:57.554246 | rt_mysql |
+-----------+------------------+----------------------------+-----------+
3 rows in set