1.    找出数据块的编号,

alter system dump datafile 8 block 7411;

2.      dump多个数据块

  ALTER SYSTEM DUMP DATAFILE 5

BLOCK MIN 84

BLOCK MAX 91

3.      如果是rollback segment还可用以下方法

alter system dump undo header RBS01;

event dump systemstate

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

ORADEBUG

 Oradebug setospid

 Oradebug unlimit

 Oradebug dump systemstate 10

dump redo log (包括online redo log , archive log

ALTER SYSTEM DUMP LOGFILE 'D:\oracle\product\10.2.0\oradata\cheny\REDO01.LOG'
DBA MIN 4 459 DBA MAX 4  467;

Note1031381.6 How to Dump Redo Log File Information

dump redo log.doc

dump redo log header

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

DUMP locally managed temporary tablespace

alter system dump tempfile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\CHENY\TEMP01.DBF' block 1

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