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
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 ?
Eat , Drink & Enjoy life -
You can use the following scripts to know when the database was started.
to_char(logon_time,'Dy dd Mon HH24:MM:SS')
"Oracle Startup Time"
sid=1 -- sid=1 represents the PMON process
Here's an example of the output.
Oracle Startup Time
Tue 20 Mar 07:03:24
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 ?
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
Click Here to Expand Forum to Full Width