[20201106]了解oracle数据库启动时间.txt

[20201106]了解oracle数据库启动时间.txt --//前几天上班就知道exadata服务器发生了重启,查看alert.log可以确定。 --//但是我发现查询alert文件比较麻烦，主要是文件很大。通过grep过滤定位。 $  grep -n -C 2 "Starting ORACLE instance"  alert_XXXX1.log 61068-Instance terminated by PMON, pid = 23988 61069-Thu Jul 16 16:04:30 2020 61070:Starting ORACLE instance (normal) 61071-************************ Large Pages Information ******************* 61072-Parameter use_large_pages = ONLY -- 61183-Instance terminated by USER, pid = 19877 61184-Thu Jul 16 16:31:29 2020 61185:Starting ORACLE instance (normal) 61186-************************ Large Pages Information ******************* 61187-Parameter use_large_pages = ONLY -- 61298-Instance terminated by USER, pid = 46733 61299-Thu Jul 16 16:33:11 2020 61300:Starting ORACLE instance (normal) 61301-************************ Large Pages Information ******************* 61302-Parameter use_large_pages = ONLY -- 61413-Instance terminated by USER, pid = 49079 61414-Thu Jul 16 16:45:35 2020 61415:Starting ORACLE instance (normal) 61416-************************ Large Pages Information ******************* 61417-Parameter use_large_pages = ONLY -- 61528-Instance terminated by USER, pid = 61264 61529-Thu Jul 16 16:53:45 2020 61530:Starting ORACLE instance (normal) 61531-************************ Large Pages Information ******************* 61532-Parameter use_large_pages = ONLY --//不知道什么回事，启动了这么多次。 XXXX> select * FROM dba_hist_database_instance ORDER BY startup_time ; XXXX> @ prxx ============================== DBID                          : 2417323702 INSTANCE_NUMBER               : 2 STARTUP_TIME                  : 2014-12-11 03:03:11.000 PARALLEL                      : YES VERSION                       : 11.2.0.4.0 DB_NAME                       : XXXX INSTANCE_NAME                 : XXXX2 HOST_NAME                     : dm01dbadm02 LAST_ASH_SAMPLE_ID            : 189431839 PLATFORM_NAME                 : Linux x86 64-bit ============================== DBID                          : 2417323702 INSTANCE_NUMBER               : 1 STARTUP_TIME                  : 2020-07-16 16:55:00.000 PARALLEL                      : YES VERSION                       : 11.2.0.4.0 DB_NAME                       : XXXX INSTANCE_NAME                 : XXXX1 HOST_NAME                     : dm01dbadm01 LAST_ASH_SAMPLE_ID            : 189304861 PLATFORM_NAME                 : Linux x86 64-bit PL/SQL procedure successfully completed. dbcn> select * from gv$instance   2  @ prxx ============================== INST_ID                       : 2 INSTANCE_NUMBER               : 2 INSTANCE_NAME                 : dbcn2 HOST_NAME                     : dm01dbadm02 VERSION                       : 11.2.0.4.0 STARTUP_TIME                  : 2014-12-11 03:02:36 STATUS                        : OPEN PARALLEL                      : YES THREAD#                       : 2 ARCHIVER                      : STARTED LOG_SWITCH_WAIT               : LOGINS                        : ALLOWED SHUTDOWN_PENDING              : NO DATABASE_STATUS               : ACTIVE INSTANCE_ROLE                 : PRIMARY_INSTANCE ACTIVE_STATE                  : NORMAL BLOCKED                       : NO ============================== INST_ID                       : 1 INSTANCE_NUMBER               : 1 INSTANCE_NAME                 : dbcn1 HOST_NAME                     : dm01dbadm01 VERSION                       : 11.2.0.4.0 STARTUP_TIME                  : 2020-07-16 16:53:46 STATUS                        : OPEN PARALLEL                      : YES THREAD#                       : 1 ARCHIVER                      : STARTED LOG_SWITCH_WAIT               : LOGINS                        : ALLOWED SHUTDOWN_PENDING              : NO DATABASE_STATUS               : ACTIVE INSTANCE_ROLE                 : PRIMARY_INSTANCE ACTIVE_STATE                  : NORMAL BLOCKED                       : NO PL/SQL procedure successfully completed.