Page 1 of 1

internals of oracle 10g

Posted: Wed Aug 26, 2009 11:48 am
by g_suri24
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.

Posted: Sat Aug 29, 2009 2:24 am
by amirtai
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