告警日志

----警告日志介绍
告警日志文件是一类特殊的跟踪文件（trace file）数据库告警日志文件是按时间顺序记录message和错误信息
  告警日志文件命令一般为alert_<SID>.log，其中SID为oracle数据库实例名称。

---警告日志位置
SQL> show parameter dump_dest


NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
background_dump_dest                 string      /u01/app/oracle/diag/rdbms/ora
                                                 11gr2/ORA11GR2/trace
core_dump_dest                       string      /u01/app/oracle/diag/rdbms/ora
                                                 11gr2/ORA11GR2/cdump
user_dump_dest                       string      /u01/app/oracle/diag/rdbms/ora
                                                 11gr2/ORA11GR2/trace
SQL> 
----查看警告日志的内容
[oracle@host ~]$ cd /u01/app/oracle/diag/rdbms/ora11gr2/ORA11GR2/trace/
[oracle@host trace]$ ls
alert_ORA11GR2.log       ORA11GR2_lgwr_12413.trm  ORA11GR2_ora_25134.trm
ORA11GR2_arc3_24398.trc  ORA11GR2_lgwr_16243.trc  ORA11GR2_ora_25209.trc
ORA11GR2_arc3_24398.trm  ORA11GR2_lgwr_16243.trm  ORA11GR2_ora_25209.trm
ORA11GR2_cjq0_24982.trc  ORA11GR2_lgwr_24917.trc  ORA11GR2_ora_25220.trc
ORA11GR2_cjq0_24982.trm  ORA11GR2_lgwr_24917.trm  ORA11GR2_ora_25220.trm
ORA11GR2_cjq0_25434.trc  ORA11GR2_lgwr_25356.trc  ORA11GR2_ora_25285.trc
ORA11GR2_cjq0_25434.trm  ORA11GR2_lgwr_25356.trm  ORA11GR2_ora_25285.trm
ORA11GR2_ckpt_12417.trc  ORA11GR2_m000_24960.trc  ORA11GR2_ora_25290.trc
ORA11GR2_ckpt_12417.trm  ORA11GR2_m000_24960.trm  ORA11GR2_ora_25290.trm
ORA11GR2_dbrm_12397.trc  ORA11GR2_m000_25300.trc  ORA11GR2_ora_25304.trc
ORA11GR2_dbrm_12397.trm  ORA11GR2_m000_25300.trm  ORA11GR2_ora_25304.trm
ORA11GR2_dbrm_16226.trc  ORA11GR2_m000_5062.trc   ORA11GR2_ora_25312.trc
ORA11GR2_dbrm_16226.trm  ORA11GR2_m000_5062.trm   ORA11GR2_ora_25312.trm
ORA11GR2_dbrm_24901.trc  ORA11GR2_mman_12405.trc  ORA11GR2_ora_25398.trc
ORA11GR2_dbrm_24901.trm  ORA11GR2_mman_12405.trm  ORA11GR2_ora_25398.trm
ORA11GR2_dbrm_25162.trc  ORA11GR2_mman_16234.trc  ORA11GR2_ora_2773.trc
ORA11GR2_dbrm_25162.trm  ORA11GR2_mman_16234.trm  ORA11GR2_ora_2773.trm
ORA11GR2_dbrm_25340.trc  ORA11GR2_mman_24804.trc  ORA11GR2_ora_28204.trc
ORA11GR2_dbrm_25340.trm  ORA11GR2_mman_24804.trm  ORA11GR2_ora_28204.trm
ORA11GR2_dm00_1393.trc   ORA11GR2_mman_24909.trc  ORA11GR2_ora_2866.trc
ORA11GR2_dm00_1393.trm   ORA11GR2_mman_24909.trm  ORA11GR2_ora_2866.trm
ORA11GR2_dm00_2155.trc   ORA11GR2_mman_25170.trc  ORA11GR2_ora_3043.trc
ORA11GR2_dm00_2155.trm   ORA11GR2_mman_25170.trm  ORA11GR2_ora_3043.trm
ORA11GR2_dm00_25062.trc  ORA11GR2_mman_25348.trc  ORA11GR2_ora_31027.trc
ORA11GR2_dm00_25062.trm  ORA11GR2_mman_25348.trm  ORA11GR2_ora_31027.trm
ORA11GR2_dm00_2516.trc   ORA11GR2_mmnl_25376.trc  ORA11GR2_ora_32333.trc
ORA11GR2_dm00_2516.trm   ORA11GR2_mmnl_25376.trm  ORA11GR2_ora_32333.trm
ORA11GR2_dm00_2777.trc   ORA11GR2_mmon_12429.trc  ORA11GR2_ora_32440.trc
ORA11GR2_dm00_2777.trm   ORA11GR2_mmon_12429.trm  ORA11GR2_ora_32440.trm
ORA11GR2_dm00_2870.trc   ORA11GR2_mmon_16259.trc  ORA11GR2_ora_32492.trc
ORA11GR2_dm00_2870.trm   ORA11GR2_mmon_16259.trm  ORA11GR2_ora_32492.trm
ORA11GR2_dm00_3052.trc   ORA11GR2_mmon_24952.trc  ORA11GR2_ora_3736.trc
ORA11GR2_dm00_3052.trm   ORA11GR2_mmon_24952.trm  ORA11GR2_ora_3736.trm
ORA11GR2_dm00_32341.trc  ORA11GR2_mmon_25194.trc  ORA11GR2_ora_387.trc
ORA11GR2_dm00_32341.trm  ORA11GR2_mmon_25194.trm  ORA11GR2_ora_387.trm
ORA11GR2_dm00_32444.trc  ORA11GR2_mmon_25372.trc  ORA11GR2_ora_4345.trc
ORA11GR2_dm00_32444.trm  ORA11GR2_mmon_25372.trm  ORA11GR2_ora_4345.trm
ORA11GR2_dm00_8022.trc   ORA11GR2_ora_12233.trc   ORA11GR2_ora_5438.trc
ORA11GR2_dm00_8022.trm   ORA11GR2_ora_12233.trm   ORA11GR2_ora_5438.trm
ORA11GR2_dm00_8284.trc   ORA11GR2_ora_12356.trc   ORA11GR2_ora_5454.trc
ORA11GR2_dm00_8284.trm   ORA11GR2_ora_12356.trm   ORA11GR2_ora_5454.trm
ORA11GR2_dm00_8766.trc   ORA11GR2_ora_12457.trc   ORA11GR2_ora_6534.trc
ORA11GR2_dm00_8766.trm   ORA11GR2_ora_12457.trm   ORA11GR2_ora_6534.trm
ORA11GR2_dw00_1397.trc   ORA11GR2_ora_1381.trc    ORA11GR2_ora_8003.trc
ORA11GR2_dw00_1397.trm   ORA11GR2_ora_1381.trm    ORA11GR2_ora_8003.trm
ORA11GR2_dw00_25066.trc  ORA11GR2_ora_16196.trc   ORA11GR2_ora_8279.trc
ORA11GR2_dw00_25066.trm  ORA11GR2_ora_16196.trm   ORA11GR2_ora_8279.trm
ORA11GR2_dw00_3056.trc   ORA11GR2_ora_16286.trc   ORA11GR2_ora_8761.trc
ORA11GR2_dw00_3056.trm   ORA11GR2_ora_16286.trm   ORA11GR2_ora_8761.trm
ORA11GR2_dw00_32346.trc  ORA11GR2_ora_2147.trc    ORA11GR2_ora_985.trc
ORA11GR2_dw00_32346.trm  ORA11GR2_ora_2147.trm    ORA11GR2_ora_985.trm
ORA11GR2_dw00_32448.trc  ORA11GR2_ora_2387.trc    ORA11GR2_q000_25516.trc
ORA11GR2_dw00_32448.trm  ORA11GR2_ora_2387.trm    ORA11GR2_q000_25516.trm
ORA11GR2_dw00_8288.trc   ORA11GR2_ora_24101.trc   ORA11GR2_vkrm_19382.trc
ORA11GR2_dw00_8288.trm   ORA11GR2_ora_24101.trm   ORA11GR2_vkrm_19382.trm
ORA11GR2_dw00_8782.trc   ORA11GR2_ora_24766.trc   ORA11GR2_vkrm_24101.trc
ORA11GR2_dw00_8782.trm   ORA11GR2_ora_24766.trm   ORA11GR2_vkrm_24101.trm
ORA11GR2_j000_2285.trc   ORA11GR2_ora_24843.trc   ORA11GR2_vkrm_2842.trc
ORA11GR2_j000_2285.trm   ORA11GR2_ora_24843.trm   ORA11GR2_vkrm_2842.trm
ORA11GR2_j000_2863.trc   ORA11GR2_ora_24844.trc   ORA11GR2_vktm_12381.trc
ORA11GR2_j000_2863.trm   ORA11GR2_ora_24844.trm   ORA11GR2_vktm_12381.trm
ORA11GR2_j000_31100.trc  ORA11GR2_ora_24870.trc   ORA11GR2_vktm_16212.trc
ORA11GR2_j000_31100.trm  ORA11GR2_ora_24870.trm   ORA11GR2_vktm_16212.trm
ORA11GR2_j000_7153.trc   ORA11GR2_ora_24873.trc   ORA11GR2_vktm_24782.trc
ORA11GR2_j000_7153.trm   ORA11GR2_ora_24873.trm   ORA11GR2_vktm_24782.trm
ORA11GR2_j000_8787.trc   ORA11GR2_ora_24948.trc   ORA11GR2_vktm_24887.trc
ORA11GR2_j000_8787.trm   ORA11GR2_ora_24948.trm   ORA11GR2_vktm_24887.trm
ORA11GR2_j001_19359.trc  ORA11GR2_ora_24978.trc   ORA11GR2_vktm_25148.trc
ORA11GR2_j001_19359.trm  ORA11GR2_ora_24978.trm   ORA11GR2_vktm_25148.trm
ORA11GR2_j001_23981.trc  ORA11GR2_ora_2497.trc    ORA11GR2_vktm_25326.trc
ORA11GR2_j001_23981.trm  ORA11GR2_ora_2497.trm    ORA11GR2_vktm_25326.trm
ORA11GR2_j001_24082.trc  ORA11GR2_ora_25054.trc   ORA11GR2_w000_23854.trc
ORA11GR2_j001_24082.trm  ORA11GR2_ora_25054.trm   ORA11GR2_w000_23854.trm
ORA11GR2_j001_3832.trc   ORA11GR2_ora_25104.trc   ORA11GR2_w000_30218.trc
ORA11GR2_j001_3832.trm   ORA11GR2_ora_25104.trm   ORA11GR2_w000_30218.trm
ORA11GR2_j003_2942.trc   ORA11GR2_ora_25128.trc   ORA11GR2_w000_31935.trc
ORA11GR2_j003_2942.trm   ORA11GR2_ora_25128.trm   ORA11GR2_w000_31935.trm
ORA11GR2_j004_25002.trc  ORA11GR2_ora_25131.trc   ORA11GR2_w001_8853.trc
ORA11GR2_j004_25002.trm  ORA11GR2_ora_25131.trm   ORA11GR2_w001_8853.trm
ORA11GR2_lgwr_12413.trc  ORA11GR2_ora_25134.trc
[oracle@host trace]$ 
[oracle@host trace]$ tail -100f|tail alert_ORA11GR2.log 
Completed: alter database add standby logfile group 6('/u01/app/oracle/oradata/ORA11GR2/redo06.log') size 50m
Mon Mar 27 17:25:23 2017
alter database add standby logfile group 7('/u01/app/oracle/oradata/ORA11GR2/redo07.log') size 50m
Completed: alter database add standby logfile group 7('/u01/app/oracle/oradata/ORA11GR2/redo07.log') size 50m
Mon Mar 27 17:35:53 2017
Warning: VKTM detected a time drift.
Time drifts can result in an unexpected behavior such as time-outs. Please check trace file for more details.
Mon Mar 27 20:03:13 2017
Warning: VKTM detected a time drift.
Time drifts can result in an unexpected behavior such as time-outs. Please check trace file for more details.
tail: warning: following standard input indefinitely is ineffective

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31399171/viewspace-2136145/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31399171/viewspace-2136145/