重庆思庄技术分享——查看数据库最近重启时间和重启时间历史

查看数据库最近重启时间和重启时间历史

Oracle 数据库实例上次重启时间
SQL> select instance_name,
to_char(startup_time,'mm/dd/yyyy hh24:mi:ss') as startup_time
from v$instance;
INSTANCE_NAME STARTUP_TIME
---------------------- ----------------------
orahowdb 09 /03/2020 03:24:03

数据库启动历史
SQL> select * from
( select STARTUP_TIME FROM dba_hist_database_instance ORDER BY startup_time DESC)
WHERE rownum < 10;

STARTUP_TIME
-----------------------------
03-SEP-20 03.24.43.000 AM
03-SEP-20 03.24.27.000 AM
01-SEP-20 02.32.32.000 PM
01-SEP-20 02.32.31.000 PM
08-AUG-20 02.35.45.000 PM
08-AUG-20 02.35.44.000 PM
08-AUG-20 09.05.24.000 AM
08-AUG-20 08.02.43.000 AM
03-AUG-20 01.25.07.000 PM
9 rows selected.