Home » RDBMS Server » Performance Tuning » Strange Database Shutdowns
Strange Database Shutdowns [message #132885] Tue, 16 August 2005 10:12 Go to next message
rkl1
Messages: 97
Registered: June 2005
Member
Dear All,

we have a strange situation.while building the indexes (some of them are massive bitmap indexes on a huge table (>170GB). Now when the index building was in progress, the database was shutdown two times for no reason.We have an index log file which showed no error message and only indicating that it can't build indexes when database is shutting down. Checking the alert.log showed that, database was in an immediate shutdown mode but no error message. Also no trace files were created about this shutdown. Database version is 9.2.0.6 and running under Solaris.

When sysdba shuts down the dbase explicitly, does it write any where besides the alert.log file. If database kernel was responsible for shutting it down, what could be the possible reason. We don't see any block corruption errors or any nasty stuffs like that.

Any help/suggestions would be acceptable and appreciated.

Thanks.
icon5.gif  Re: Strange Database Shutdowns [message #133453 is a reply to message #132885] Fri, 19 August 2005 02:24 Go to previous message
kugenuma
Messages: 9
Registered: August 2005
Location: Japan
Junior Member
Was it abort shutdown or normal shutdown??
Previous Topic: Drill to Evaluate
Next Topic: index performing bad
Goto Forum:
  


Current Time: Mon Nov 28 06:00:10 CST 2022