Datafiles not Restored — using V$DATAFILE and V$DATAFILE_HEADER

(Hemant K Chitale) Building on my previous blog post “Does a STARTUP MOUNT verify datafiles ?”, here’s how I can use the V$DATAFILE and V$DATAFILE_HEADER views from the controlfile to identify datafiles that are / are not restored. This is a case where I have to do a FULL Restore.

Read More - Register for Free Membership