The qrestore_point script will show any restore points that are in the database.

SQL

col name format a25

select name,scn,time,database_incarnation#,guarantee_flashback_database,storage_size
from v$restore_point;

Output