1、
https://blog.51cto.com/u_15338523/6194204
SELECT incarnation#
,resetlogs_change#
,TO_CHAR(resetlogs_time, 'yyyy-mm-dd hh24:mi:ss') db_restored_time
,resetlogs_change#
--,scn_to_timestamp(resetlogs_change#) db_recovery_till_time
FROM v$database_incarnation
WHERE resetlogs_change# !=
(SELECT MIN(resetlogs_change#) FROM v$database_incarnation
);
2、