ERPstuff - Oracle EBS Community

Hi,

when datafile or control file is lost it asks for media recovery or instance recovery .Based on that we perform the recovery.

how oracle comes to know that instance recovery or media recovery needs to be performed ?

Thanks in advance.

Each control file has header information of the datafiles and SCN (system change number). If they are not matching with each other then it realize that something is missing. It asks for archive logs to apply all changes to the data file to make the SCN synchronize with control file SCN.

Regards
Amir