list restorepoint

List Global Restore Points.

Syntax

list restorepoint [-start_time t1] [-end_time t2] [-start_scn_ s1] [-end_scn s2]

Options

Table 2-53 GDSCTL list restorepoint Options

Syntax	Description
-start_time time1	If specified, the command lists restore points that were created at or after this time. It must be specified in the format “YYYY-MM-DD HH:MM:SS[.FFF] where .FFF is a fraction of a second in the precision of milliseconds.
-end_time time2	If specified, the command lists restore points that were created at or before this time. Refer to the option “start_time” above for its format.
-start_scn scn1	If specified, the command lists restore points with SCNs equal to or greater than this SCN.
-end_scn scn2	If specified, the command lists restore points with SCNs equal to or less than this SCN.

Examples

The example below lists the available restore points in the sharded database (SDB) with the SCN between 2600000 and 2700000.

GDSCTL> list restorepoint -start_scn 2600000 -end_scn 2700000
Name                            SCN             Create Time                     
GRP_200726222838427_0400        2601938         2020-07-26 22:28:39.0           
GRP_200726232837677_0400        2613192         2020-07-26 23:28:38.0           
GRP_200727002838026_0400        2624200         2020-07-27 00:28:38.0           
GRP_200727012838351_0400        2634360         2020-07-27 01:28:38.0           
GRP_200727022837961_0400        2645399         2020-07-27 02:28:38.0           
GRP_200727032838402_0400        2654898         2020-07-27 03:28:39.0           
GRP_200727042837648_0400        2664398         2020-07-27 04:28:38.0           
GRP_200727052837932_0400        2673905         2020-07-27 05:28:38.0           
GRP_200727062838321_0400        2683840         2020-07-27 06:28:38.0