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

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 Go to previous messageGo to next message
Frank Naude
Messages: 4596
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 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.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 01 22:10:30 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.