Log Files To Check When the DB Crashes

[Former Member]

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

DB

- 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.

Thanks,

Regards,

- Ishan

[Former Member]

Ishan,

as your DBA team were capable of resolving this issue, they should be able to point you in the right direction, however, you could start with:

/oracle/SID/saptrace/background/alert_SID.log

[Former Member]

Thanks for the valued inputs, Scotts !! Appreciate it.

I need to do this, without any interaction to DBA Team and that's where this Q comes.

Best Regards,

- Ishan