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 ;


How to analyze wait events in Oracle

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.