Find Oracle Shutdown & Startup Time



Share this article :

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

Related posts

ORA-00955: name is already used by an existing object
ORA-01161: db name A in file header does not match given name of B
Find Oracle Control File Location
Where to Find Oracle Listener Port & How to Change It
© 2017 ITsiti. All Rights Reserved
Powered by KEEM