发现告警信息
Wed Nov 19 07:16:18 2014
Dumping diagnostic data in directory=[cdmp_20141119071618], requested by (instance=1, osid=125680 (J000)), summary=[abnormal process termination].
Non critical error ORA-48913 caught while writing to trace file "/u01/app/oracle/diag/rdbms/edw/edw1/trace/edw1_j000_125680.trc"
Error message: ORA-48913: 写入跟踪文件失败, 达到了文件大小限制 [1000000]
Writing to the above trace file is disabled for now on...
导致该问题是由于数据库参数max_dump_file_size设置太小导致
SYS@edw1> show parameter max_dump_file_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_dump_file_size string 1M
设置max_dump_file_size 可以有效的控制trace 文件过大导致的问题,但是由于trace文件写入失败,也会影响到对故障出现时的定位。