Note
This view is available starting with V4.0.0.
Purpose
The V$RESTORE_POINT view displays information about restore points.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | YES | The tenant ID. |
| SNAPSHOT | bigint(20) | NO | The database 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