dump index:

alter session set events 'immediate trace name treedump level ';

dump control file:

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

dump data file header

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

dump log file header

alter session set event 'immediate trace name redohdr level 10';

dump logfile

alter system dump logfile 'logfilename';

dump data block

alter system dump datafile file# block block#;

trace file will be in user_dump_dest directory, name as _ora_.trc

SELECT p.spid

FROM v$session s, v$process p

WHERE s.paddr = p.addr AND s.SID IN (SELECT DISTINCT SID

FROM v$mystat);

ITPub博客

dump file (index, block, control file, log ,date file)