Home » RDBMS Server » Performance Tuning » whether recovery is possible when instance crash occur
whether recovery is possible when instance crash occur [message #65787] Thu, 23 December 2004 19:10 Go to next message
Ravikumar.V
Messages: 26
Registered: July 2004
Junior Member
whether recovery is possible when instance crash occur
Re: whether recovery is possible when instance crash occur [message #65790 is a reply to message #65787] Thu, 23 December 2004 21:11 Go to previous messageGo to next message
Frank Naude
Messages: 4579
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
Re: whether recovery is possible when instance crash occur [message #65792 is a reply to message #65787] Fri, 24 December 2004 01:43 Go to previous message
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.
Previous Topic: procedure or function which is best related to tuning
Next Topic: Analysing sql query
Goto Forum:
  


Current Time: Thu Mar 28 21:08:56 CDT 2024