【正文】
elp show alert,可以看到show alert的詳細(xì)用法??赐阛lert的日志后輸入 :q退出,操作方法跟vi命令類似。oracle日志文件:select * from v$log。:alter system switch logfile。:select dbid,name,created,log_mode from v$database。/home1/oracle/oradata/ora8i/39。/home2/oracle/oradata/ora8i/39。alter database drop logfile group 1。/home1/oracle/oradata/ora8i/39。/home1/oracle/oradata/ora8i/39。alter database drop logfile member 39。 。/home1/oracle/oradata/ora8i/39。/home2/oracle/oradata/ora8i/39。/home1/oracle/oradata/ora8i/39。 原因分析: oracle11g修改了日志系統(tǒng),不在使用oracle9的alert_$,修改為Diag Alert 和Diag Trace兩個(gè)目錄保存xml格式和文本格式的日志,這個(gè)兩個(gè)目錄分別放置于/oracle/oracle/diag/rdbms/rac/rac1/trace和/oracle/oracle/diag/rdbms/rac/rac