oracle通过dump转储控制文件，日志文件等

转储控制文件内容

alter session set events 'immediate trace name controlf level 8';

转储数据文件

alter session set events 'immediate trace name file_hdrs level 8';

转储日志文件

SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/oracle/oradata/orcldb/redo03.log
/oracle/oradata/orcldb/redo02.log
/oracle/oradata/orcldb/redo01.log

SQL>alter system dump logfile '/oracle/oradata/orcldb/redo03.log';

查看产生的trace文件

SELECT DISTINCT S.SID,S.SERIAL#,P.TRACEFILE FROM V$SESSION S ,V$PROCESS P ,V$MYSTAT M WHERE P.ADDR=S.PADDR AND S.SID=M.SID;

或者

select value from v$diag_info where name='Default Trace File';