Oracle:Where is Alert log?
Alert日志的位置通过数据库的初始化参数:“background_dump_dest”指定。
可以通过下列的SQL或者SQL*Plus的环境命令,获得关于该参数的具体值:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
SQL> select num,name,type,value,display_value,description from v$parameter where name='background_dump_dest'; NUM NAME TYPE VALUE DISPLAY_VALUE DESCRIPTION ---------- ---------------------------- ---------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- 1829 background_dump_dest 2 /u01/app/oracle/diag/rdbms/orcl11g/orcl11g/trace /u01/app/oracle/diag/rdbms/orcl11g/orcl11g/trace Detached process dump directory SQL> SQL> show parameter background_dump_dest; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ background_dump_dest string /u01/app/oracle/diag/rdbms/orc l11g/orcl11g/trace SQL> |
然后,进入文件系统查看:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 |
[ora11g@rhel5u10 ~]$ cd /u01/app/oracle/diag/rdbms/orcl11g/orcl11g/trace [ora11g@rhel5u10 trace]$ ll | wc -l 122 [ora11g@rhel5u10 trace]$ ls alert_orcl11g.log orcl11g_dbrm_406.trm orcl11g_j004_6966.trm orcl11g_mman_410.trm orcl11g_mmon_6895.trm orcl11g_ora_32568.trm orcl11g_ora_361.trm orcl11g_ora_6825.trm orcl11g_vktm_32603.trm orcl11g_arc0_6922.trc orcl11g_dbrm_666.trc orcl11g_j007_32710.trc orcl11g_mman_670.trc orcl11g_mmon_793.trc orcl11g_ora_32573.trc orcl11g_ora_365.trc orcl11g_ora_6920.trc orcl11g_vktm_398.trc orcl11g_arc0_6922.trm orcl11g_dbrm_666.trm orcl11g_j007_32710.trm orcl11g_mman_670.trm orcl11g_mmon_793.trm orcl11g_ora_32573.trm orcl11g_ora_365.trm orcl11g_ora_6920.trm orcl11g_vktm_398.trm orcl11g_arc0_842.trc orcl11g_dbrm_6879.trc orcl11g_lgwr_785.trc orcl11g_mman_6883.trc orcl11g_ora_11934.trc orcl11g_ora_32634.trc orcl11g_ora_368.trc orcl11g_ora_726.trc orcl11g_vktm_658.trc orcl11g_arc0_842.trm orcl11g_dbrm_6879.trm orcl11g_lgwr_785.trm orcl11g_mman_6883.trm orcl11g_ora_11934.trm orcl11g_ora_32634.trm orcl11g_ora_368.trm orcl11g_ora_726.trm orcl11g_vktm_658.trm orcl11g_cjq0_32690.trc orcl11g_dbrm_777.trc orcl11g_m000_32679.trc orcl11g_mman_781.trc orcl11g_ora_18259.trc orcl11g_ora_32694.trc orcl11g_ora_429.trc orcl11g_ora_737.trc orcl11g_vktm_6871.trc orcl11g_cjq0_32690.trm orcl11g_dbrm_777.trm orcl11g_m000_32679.trm orcl11g_mman_781.trm orcl11g_ora_18259.trm orcl11g_ora_32694.trm orcl11g_ora_429.trm orcl11g_ora_737.trm orcl11g_vktm_6871.trm orcl11g_ckpt_32621.trc orcl11g_dm00_32761.trc orcl11g_m000_588.trc orcl11g_mmon_32675.trc orcl11g_ora_2907.trc orcl11g_ora_32752.trc orcl11g_ora_467.trc orcl11g_ora_739.trc orcl11g_vktm_769.trc orcl11g_ckpt_32621.trm orcl11g_dm00_32761.trm orcl11g_m000_588.trm orcl11g_mmon_32675.trm orcl11g_ora_2907.trm orcl11g_ora_32752.trm orcl11g_ora_467.trm orcl11g_ora_739.trm orcl11g_vktm_769.trm orcl11g_ckpt_787.trc orcl11g_dw00_32765.trc orcl11g_mman_32460.trc orcl11g_mmon_422.trc orcl11g_ora_32416.trc orcl11g_ora_3325.trc orcl11g_ora_545.trc orcl11g_ora_840.trc orcl11g_ckpt_787.trm orcl11g_dw00_32765.trm orcl11g_mman_32460.trm orcl11g_mmon_422.trm orcl11g_ora_32416.trm orcl11g_ora_3325.trm orcl11g_ora_545.trm orcl11g_ora_840.trm orcl11g_dbrm_32611.trc orcl11g_j000_9626.trc orcl11g_mman_32615.trc orcl11g_mmon_682.trc orcl11g_ora_32480.trc orcl11g_ora_333.trc orcl11g_ora_628.trc orcl11g_vktm_32448.trc orcl11g_dbrm_32611.trm orcl11g_j000_9626.trm orcl11g_mman_32615.trm orcl11g_mmon_682.trm orcl11g_ora_32480.trm orcl11g_ora_333.trm orcl11g_ora_628.trm orcl11g_vktm_32448.trm orcl11g_dbrm_406.trc orcl11g_j004_6966.trc orcl11g_mman_410.trc orcl11g_mmon_6895.trc orcl11g_ora_32568.trc orcl11g_ora_361.trc orcl11g_ora_6825.trc orcl11g_vktm_32603.trc [ora11g@rhel5u10 trace]$ [ora11g@rhel5u10 trace]$ ll | grep --color alert -rw-r----- 1 ora11g oinstall 44481 Oct 7 20:06 alert_orcl11g.log [ora11g@rhel5u10 trace]$ [ora11g@rhel5u10 trace]$ cat alert_orcl11g.log | wc -l 1096 [ora11g@rhel5u10 trace]$ [ora11g@rhel5u10 trace]$ tail -n 18 alert_orcl11g.log Tue Oct 07 20:01:00 2014 Starting background process QMNC Tue Oct 07 20:01:00 2014 QMNC started with pid=24, OS id=6931 Completed: ALTER DATABASE OPEN Tue Oct 07 20:01:07 2014 Starting background process CJQ0 Tue Oct 07 20:01:07 2014 CJQ0 started with pid=30, OS id=6952 Tue Oct 07 20:01:07 2014 db_recovery_file_dest_size of 4122 MB is 1.59% used. This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup. Tue Oct 07 20:06:01 2014 Starting background process SMCO Tue Oct 07 20:06:01 2014 SMCO started with pid=27, OS id=7000 [ora11g@rhel5u10 trace]$ |
——————————————————————————
Ending。