Reason for Database shutdown

[gaddesr]

Hi all,

How can we know the reason & time of database shutdown? Because my database is in shutdown position yesterday. But nothing was written in the Alertlog file.
How & where can we find out when the shutdown happened and the user responsible for the shutdown?

Thanks in advance

[pravin]

what shutdown command was given. shutdown immediate or just plain shutdown.?

Check the alert log it should post some message.

Whats the OS u are using ?

[cyberman]

You can use the following scripts to know when the database was started.

select
to_char(logon_time,'Dy dd Mon HH24:MM:SS')
"Oracle Startup Time"
from
sys.v_$session
where
sid=1 -- sid=1 represents the PMON process
;

Here's an example of the output.

Oracle Startup Time
-------------------
Tue 20 Mar 07:03:24

[Sureshy]

If you shutdown your database, it WILL definitley log this in your alert log (even with shutdown abort).

If a shutdown is not recorded in alert.log, it probably means you had instance failure. Your server may have lost power.
Or someone maliciously deleted those entries from the alert.log.

How long has OS been running ?