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

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 );

 

http://space.itpub.net/758322/viewspace-683573

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22936840/viewspace-749431/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22936840/viewspace-749431/