Home » RDBMS Server » Server Administration » Is it possible to set size of redo buffer to b nil (i.e. 0)?
Is it possible to set size of redo buffer to b nil (i.e. 0)? [message #138297] Wed, 21 September 2005 04:07 Go to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi,

It seems very stupid question but ... can any one tell me if i dont want to recover my database when it is crashed than ...can i have my redobuffer size set to be Nil (i.e zero)?
If no then why ?

regards
Always friend sunil

Report message to a moderator

Re: Is it possible to set size of redo buffer to b nil (i.e. 0)? [message #138299 is a reply to message #138297] Wed, 21 September 2005 04:19 Go to previous messageGo to next message
alliejane
Messages: 59
Registered: July 2005
Location: Glasgow
Member
I'm afraid not, it's an essential component of the SGA.

A basic reason would be I guess, that you have not choice but to recover the database after an instance crash (if you want to open it for use again!!) it's in an inconsistent state.. STARTUP will do that for you automatically.

As far as I'm aware there is no workaround, not that I would want no recovery anyway.

Allie

Report message to a moderator

Re: Is it possible to set size of redo buffer to b nil (i.e. 0)? [message #138301 is a reply to message #138299] Wed, 21 September 2005 04:25 Go to previous message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member

hi

Thank you alliejane for your reply.

Always friend sunilkumar

Report message to a moderator

Previous Topic: Oracle Service not starting on Windows 2000
Next Topic: Is it OK to coalease tblsp every hour
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jan 25 08:07:29 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.