Recovery | Arch

1. status of the datafiles:


select status,checkpoint_change#,checkpoint_time, resetlogs_change#, resetlogs_time, count(*), fuzzy from v$datafile_header group by status,checkpoint_change#,checkpoint_time, resetlogs_change#, resetlogs_time, fuzzy;
The goal is to have the above query return 1 row and fuzzy column value as NO.

NOTE:  if checkpoint_change# in query returns 0, this indicates that Oracle cannot read the file header. 
This is possibly because the location and name of the datafile within the controlfile is not the one on disk. 
2. Check the archivelog sequence numbers needed to recover the files.  Execute:

select min(fhrba_Seq), max(fhrba_Seq) from X$KCVFH;