Home » RDBMS Server » Server Administration » 10g database related (oracle 10g)
10g database related [message #420156] Thu, 27 August 2009 05:40 Go to next message
g_suri24
Messages: 13
Registered: January 2007
Location: hyderabad
Junior Member
Hi,

In 9i,if redo logfile or control file is lost database shuts down.But in 10g it doesn't(shutdown) happen .why?

Please expalin the reason.

thanks....
Re: 10g database related [message #420159 is a reply to message #420156] Thu, 27 August 2009 05:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It happens the same way.
If you have some proof of the opposite then post them.

Regards
Michel
Re: 10g database related [message #420163 is a reply to message #420159] Thu, 27 August 2009 06:06 Go to previous messageGo to next message
g_suri24
Messages: 13
Registered: January 2007
Location: hyderabad
Junior Member
Actually,i am asking u experts to post the answer.i don't know about the internals of 9i or 10g regarding this question.

please reply ...
Re: 10g database related [message #420168 is a reply to message #420163] Thu, 27 August 2009 06:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The reply is there is no difference but you claim the opposite so post your proof.

Regards
Michel
Re: 10g database related [message #420179 is a reply to message #420168] Thu, 27 August 2009 07:29 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
To be fair, I question the statement that a 9i database will automatically shut down if a redo logfile or control file is lost.

It won't be working, but I don't believe it will automatically perform a shutdown.
Re: 10g database related [message #420195 is a reply to message #420179] Thu, 27 August 2009 09:18 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Well, it does not perform a shutdown, it aborts/crashes as soon as it realizes one of these is missing.

Regards
Michel
Previous Topic: SMON error and DB startup hangup
Next Topic: ORA-01555
Goto Forum:
  


Current Time: Sat Dec 10 08:58:51 CST 2016

Total time taken to generate the page: 0.08104 seconds