GV$RESTORE_POINT

select
rsp.inst_id,             -- INST_ID NUMBER
to_number (rsp.rspscn),  -- SCN NUMBER
rsp.rspincarn,           -- DATABASE_INCARNATION# NUMBER
'YES',                   -- GUARANTEE_FLASHBACK_DATABASE VARCHAR2(3)
rsp.rsplgsz,             -- STORAGE_SIZE NUMBER
to_timestamp (rsp.rsptime,
'MM/DD/RR HH24:MI:SS',
'NLS_CALENDAR=Gregorian'), -- TIME TIMESTAMP(9)
rsp.rspname              -- NAME VARCHAR2(128)
from
x$kccrsp rsp 
where
bitand (rsp.rspflags, 2) != 0 
union all 
select
rsp.inst_id,             -- INST_ID NUMBER
to_number (rsp.nrsscn),  -- SCN NUMBER
rsp.nrsincarn,           -- DATABASE_INCARNATION# NUMBER
'NO',                    -- GUARANTEE_FLASHBACK_DATABASE VARCHAR2(3)
0,                       -- STORAGE_SIZE NUMBER
to_timestamp (rsp.nrstime,
'MM/DD/RR HH24:MI:SS',
'NLS_CALENDAR=Gregorian'), -- TIME TIMESTAMP(9)
rsp.nrsname              -- NAME VARCHAR2(128)
from
x$kccnrs rsp 
where
bitand (rsp.nrsflags, 2) != 0
home |  up  |  mailbox