7 Replies Latest reply on Apr 22, 2012 12:29 AM by user12215372

    Time recover database

      Hi, i have recovered a database of mode incomplete because i had the online redo logs, so i have been asked what hour of information is opened the database,

      So, for answer it, i think that this query give me this answer:

      select file#, checkpoint_change#, to_char(checkpoint_time,'DD/MM/YYYY HH24:MI:SS')
      from v$datafile_header
      order by file#

      So i would like to know if it is correct, that this query really can give me the hour that was opened the data in a database.