Home » RDBMS Server » Server Administration » internals of oracle database (oracle 10g)
internals of oracle database [message #420155] Thu, 27 August 2009 05:31 Go to next message
g_suri24
Messages: 13
Registered: January 2007
Location: hyderabad
Junior Member
Hi,

when datafile or control file is lost,oracle 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 ?

Please do reply...

Thanks in advance.
Re: internals of oracle database [message #420160 is a reply to message #420155] Thu, 27 August 2009 05:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because it knows what are its objects and see that some are missing.

Regards
Michel
Re: internals of oracle database [message #420166 is a reply to message #420160] Thu, 27 August 2009 06:14 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


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

Good Question. Check backup/resotre/recover log file. There you come know...

Thanks
Previous Topic: ORA-01925
Next Topic: SMON error and DB startup hangup
Goto Forum:
  


Current Time: Fri Dec 02 20:36:26 CST 2016

Total time taken to generate the page: 0.12191 seconds