Reason for Database shutdown
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Reason for Database shutdown

  1. #1
    Join Date
    Jun 2002
    Posts
    1
    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

  2. #2
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    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 -

    pravin_kini@hotmail.com

  3. #3
    Join Date
    Apr 2002
    Posts
    10
    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

  4. #4
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width