Applies To

All Users

Summary

 This document provides information to query information on the historical instance startup time.

Solution

Alert.log is one way of knowing the timestamp of the instance startup. However, if the alert.log has been deleted during housekeeping activities, we can use DBA_HIST_DATABASE_INSTANCE view which provides historical details about the instance startup time.

SQL> SELECT STARTUP_TIME FROM dba_hist_database_instance ORDER BY startup_time DESC;

STARTUP_TIME
---------------------------------------------------------------------------
04-JAN-16 01.04.35.000 PM
24-DEC-15 01.14.01.000 PM
22-DEC-15 05.33.36.000 PM
22-DEC-15 11.53.49.000 AM
18-DEC-15 06.59.20.000 AM
.
.
.
06-JUL-15 07.07.47.000 AM
25-JUN-15 08.39.29.000 PM
25-JUN-15 04.41.26.000 PM
25-JUN-15 04.40.57.000 PM

95 rows selected.

There is much more information captured in the view and the values of the column indicate valuable information.