Database refresh is common task for a DBA. But after every database refresh, you must check the PITR date and time. This should be checked before you issue OPEN RESETLOGS command.
Query to Check PITR – Issue it before OPEN RESETLOGS
sql">select distinct to_char(checkpoint_time,'dd/mm/yyyy hh24:mi:ss') checkpoint_time from v$datafile_header ;
