How to check database PITR after refresh

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 ;