首页 > Linux操作系统 > Linux操作系统 > dump 的几种方法
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;
alter session set events 'immediate trace name SYSTEMSTATE level 10';
Oradebug setospid
Oradebug unlimit
Oradebug dump systemstate 10
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
alter session set events 'immediate trace name redohdr level 10';
alter system dump tempfile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\CHENY\TEMP01.DBF' block 1
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30821/viewspace-541530/,如需转载,请注明出处,否则将追究法律责任。