7 Replies Latest reply: Apr 21, 2012 7:29 PM by user12215372 RSS

    Time recover database

    user12215372
      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.

      Regards.