Creating guarantee restore point for oracle databsae

select name,database_role,open_mode,flashback_on,log_mode from v$database;

col NAME for a30
set trim on
col TIME for a35
SELECT NAME, SCN, TIME, DATABASE_INCARNATION#, GUARANTEE_FLASHBACK_DATABASE, STORAGE_SIZE FROM
V$RESTORE_POINT WHERE GUARANTEE_FLASHBACK_DATABASE='YES';

create restore point GRP_01242018248PM guarantee flashback database;


DROP RESTORE POINT GRP_01242018248PM;