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.

Report message to a moderator

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: 68773
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Because it knows what are its objects and see that some are missing.

Regards
Michel

Report message to a moderator

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: 1736
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 09 21:18:30 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.