Check Recovery Time

It's quite useful sometimes to be able to see the timestamp associated with a Database Recovery.

SELECT to_char((max(TIME_DP)),'DD MON YYYY HH24:MI') FROM smon_scn_time;