Where do you find information about a missing redo log file?
A. trace file
B. audit trail
C. control file
D. alert log file
E. event viewer
Answer: D
ALERT.LOG
记录系统日志，比如日志切换的记录，修改系统参数等系统事件。
位置在参数background_dump_dest指定的路径下
----------------------
show parameter background_dump_dest; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ background_dump_dest string /home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace
建立表查看alter.log http://www.jb51.net/article/34590.htm
--创建目录 create or replace directory alert as ‘/home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace‘; --创建表 create table alert (log varchar2(1000)) organization external (type oracle_loader default directory alert access parameters (records delimited by newline) location (‘alert_orcl.log‘)) reject limit unlimited; --查看alter.llog一般是alter+sid.log select * from alert where upper(log) like ‘%REDO%‘; 这里就可以查看redolog相关的信息了