internals of oracle 10g

In this forum you can share stuff related to Oracle 11g, 10g, 9i.
Post Reply
g_suri24
Posts: 22
Joined: Thu Feb 22, 2007 8:39 am
Location: India

internals of oracle 10g

Post 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.
amirtai
Posts: 138
Joined: Sat Apr 08, 2006 5:54 pm
Location: Canada
Contact:

Post 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
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests