Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 09, 2008 at 02:34 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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