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.
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | YES | The ID of the tenant. |
| SCN | NUMBER(38) | NO | The database system change number (SCN) when the restore point was created. |
| TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The time when the restore point was created. |
| NAME | VARCHAR2(512) | YES | The name of the restore point. |
Sample query
Query all restore points in the current tenant.
obclient [SYS]> SELECT * FROM SYS.V$RESTORE_POINT;
The query result is as follows:
+-----------+------------------+------------------------------+-----------+
| TENANT_ID | SNAPSHOT | TIME | NAME |
+-----------+------------------+------------------------------+-----------+
| 1002 | 1710987930807517 | 21-MAR-24 10.25.30.808594 AM | RT_ORACLE |
+-----------+------------------+------------------------------+-----------+
1 row in set