Log Files To Check When the DB Crashes
About two week back, our production Database was down and it took whole DBA Team around 4 hours to bring it up.
Can anyone suggests which are the logs we need to Check ( I am not pure DBA ..but, rather IT Mgmt side and needs to
provide the report on this ) ?
I know that
- Automatic Db Diagnostic Monitor ( ADDM) and STATPACK Report would provide useful info on the current state of the
- However, what I need to know is what happened at the time of the Db Breakdown and how we can prevent it further
based on Updates in Standard DB Admin Policies. And it is logical to conclude that there must several log files which
would have registered the events leading to complete DB Crash. I need to know these log files with its location within
Any / ALL Inputs are highly Appreciated.