Databases Reference
In-Depth Information
When performing an incomplete recovery, before you can open the database with a resetlogs option, the
checkpoint SCN for all online, read-write datafiles must be identical. You can view the data file checkpoint SCNs via
this query:
SELECT
file#
,fuzzy
,status
,checkpoint_change#
,to_char(checkpoint_time,'dd-mon-rrrr hh24:mi:ss')
,error
FROM v$datafile_header;
After you open your database with the resetlogs clause, the checkpoint SCN in the control file will be
synchronized with the checkpoint SCN in the data file headers.
