Dear Friends ..
How can we know the reason & time of database shutdown? How & where can we find out when the shutdown happened and the user responsible for the shutdown?
Thanks
Rajeev
Printable View
Dear Friends ..
How can we know the reason & time of database shutdown? How & where can we find out when the shutdown happened and the user responsible for the shutdown?
Thanks
Rajeev
The alert log will give you the time of the shutdown and startup. Your init.ora file will tell you where the alert file is.
BACKGROUND_DUMP_DEST=