Find Oracle Shutdown & Startup Time

Symptom

You want to check the Oracle shutdown & startup time.

Solution

1. Execute below command for startup time.

SQL> select to_char (startup_time, 'dd-mon-yyyy hh24:mi:ss') 
start_time from V$instance;

START_TIME
--------------------------
13-may-2013 19:17:59

2. Or this command.

SQL> SELECT startup_time "DB Startup Time" FROM v$instance;

DB Startup Time
---------------
13-MAY-13

3. Or below command for both downtime and startup time.

SQL> SELECT SCN_TO_TIMESTAMP(TIMESTAMP_TO_SCN(startup_time)) "DB Shutdown Time" ,
 startup_time "DB Startup Time" FROM v$instance;

DB Shutdown Time                  DB Startup Time
------------------------------    ---------------
13-MAY-13 07.09.30.000000000 PM   13-MAY-13

1 Comment