Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Log Files To Check When the DB Crashes

Hi Everybody,

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

Oracle Db

Any / ALL Inputs are highly Appreciated.



- Ishan

Former Member
Not what you were looking for? View more on this topic or Ask a question