OraFAQ Forum: Server Administration » internals of oracle database

Home » RDBMS Server » Server Administration » internals of oracle database (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

internals of oracle database [message #420155]

Thu, 27 August 2009 05:31

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

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: internals of oracle database [message #420166 is a reply to message #420160]

Thu, 27 August 2009 06:14

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 03:46:28 CDT 2024