Purpose
You can use this statement to drop a restore point.
Notice
You cannot create or drop restore points in the sys tenant.
Syntax
obclient> DROP RESTORE POINT restore_point;
Parameters
| Parameter | Description |
|---|---|
| restore_point | The name of the restore point. |
Examples
Query the existing restore points of a tenant.
obclient> SELECT * FROM V$RESTORE_POINT; +-----------+------------------+----------------------------+------+ | TENANT_ID | SNAPSHOT | TIME | NAME | +-----------+------------------+----------------------------+------+ | 1001 | 1630407064663511 | 2021-08-31 18:51:04.665692 | rp1 | +-----------+------------------+----------------------------+------+ 1 row in setDrop the restore point
rp1.obclient> DROP RESTORE POINT rp1; Query OK, 0 rows affected