OraFAQ Forum: Performance Tuning » whether recovery is possible when instance crash occur

Home » RDBMS Server » Performance Tuning » whether recovery is possible when instance crash occur

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

whether recovery is possible when instance crash occur [message #65787]

Thu, 23 December 2004 19:10

Ravikumar.V
Messages: 26
Registered: July 2004

Junior Member

whether recovery is possible when instance crash occur

Report message to a moderator

Re: whether recovery is possible when instance crash occur [message #65790 is a reply to message #65787]

Thu, 23 December 2004 21:11

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

Hi,

Oracle will do instance recovery when you restart the instance after failure. If you use RAC, the surviving instances will do the instance recovery when the failure is detected. So, either way, Oracle should do it automatically. If it cannot, a DBA will have to intervene.

Best regards.

Frank

Report message to a moderator

Re: whether recovery is possible when instance crash occur [message #65792 is a reply to message #65787]

Fri, 24 December 2004 01:43

Milind Deshpande
Messages: 93
Registered: May 2004

Member

Hi,

Oracle performs Instance recovery automatically in stages Roll Forward and Roll backward which is done by SMON (System Monitor).

Regards

Milind.

Report message to a moderator

Previous Topic:	procedure or function which is best related to tuning
Next Topic:	Analysing sql query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 11:30:18 CST 2024