Oracle----Dump 

  1 create tablespace test_block
  2 datafile '/test/app/oracle/oradata/ykyk/test_block.dbf'
  3 size 10m;
  4 
  5 
  6 create user ykyk identified by ykyk default tablespace test_block;
  7 grant dba to ykyk;
  8 
  9 
 10 conn ykyk/ykyk
 11 
 12 create table t1(id int,name varchar2(100));
 13 
 14 insert into t1 values (1,'AAAA');
 15 
 16 commit;
 17 
 18 alter system checkpoint;
 19 
 20 col name for a10
 21 
 22 查这行数据所在的文件号和块号
 23 
 24 select id,name,dbms_rowid.rowid_relative_fno(rowid)
 25 file#,dbms_rowid.rowid_block_number(rowid) block#
 26 from t1;
 27 	ID NAME 	   FILE#     BLOCK#
 28 ---------- ---------- ---------- ----------
 29 	 1 AAAA 	       8	134
 30 
 31 conn / as sysdba

 

 

转储文件

  1 alter system dump datafile 8  block 134;

找到转储的文件

  1 show parameter dump;
  2 
  3 NAME				     TYPE	 VALUE
  4 ------------------------------------ ----------- ------------------------------
  5 background_core_dump		     string	 partial
  6 background_dump_dest		     string	 /test/app/oracle/diag/rdbms/yk
  7 						 yk/ykyk/trace
  8 core_dump_dest			     string	 /test/app/oracle/diag/rdbms/yk
  9 						 yk/ykyk/cdump
 10 max_dump_file_size		     string	 unlimited
 11 shadow_core_dump		     string	 partial
 12 user_dump_dest			     string	 /test/app/oracle/diag/rdbms/yk
 13 						 yk/ykyk/trace
 14 
 15 
 16 
 17 cd 	 /test/app/oracle/diag/rdbms/ykyk/ykyk/trace
 18 
 19 [oracle@Ora trace]$ ls -lFtr
 20 
 21 -rw-r----- 1 oracle oinstall  3393 Apr 20 21:30 ykyk_ora_4293.trc

文件内容

  1 Trace file /test/app/oracle/diag/rdbms/ykyk/ykyk/trace/ykyk_ora_4293.trc
  2 Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
  3 With the Partitioning, OLAP, Data Mining and Real Application Testing options
  4 ORACLE_HOME = /test/app/oracle/product/11.2.0/db_home1
  5 System name:    Linux
  6 Node name:      Ora.ykyk.com
  7 Release:        2.6.32-358.el6.x86_64
  8 Version:        #1 SMP Tue Jan 29 11:47:41 EST 2013
  9 Machine:        x86_64
 10 VM name:        VMWare Version: 6
 11 Instance name: ykyk
 12 Redo thread mounted by this instance: 1
 13 Oracle process number: 28
 14 Unix process pid: 4293, image: oracle@Ora.ykyk.com (TNS V1-V3)
 15 
 16 
 17 *** 2018-04-20 21:30:02.416
 18 *** SESSION ID:(37.61) 2018-04-20 21:30:02.416
 19 *** CLIENT ID:() 2018-04-20 21:30:02.416
 20 *** SERVICE NAME:(SYS$USERS) 2018-04-20 21:30:02.416
 21 *** MODULE NAME:(sqlplus@Ora.ykyk.com (TNS V1-V3)) 2018-04-20 21:30:02.416
 22 *** ACTION NAME:() 2018-04-20 21:30:02.416
 23 
 24 Start dump data blocks tsn: 9 file#:8 minblk 134 maxblk 134
 25 Block dump from cache:
 26 Dump of buffer cache at level 4 for tsn=9 rdba=33554566
 27 BH (0x71fe2788) file#: 8 rdba: 0x02000086 (8/134) class: 1 ba: 0x71d1c000
 28   set: 3 pool: 3 bsz: 8192 bsi: 0 sflg: 1 pwc: 303,28
 29   dbwrid: 0 obj: 14187 objn: 14187 tsn: 9 afn: 8 hint: f
 30   hash: [0x7d0de860,0x7d0de860] lru: [0x71fe2740,0x71fe29a0]
 31   ckptq: [NULL] fileq: [NULL] objq: [0x71fe2768,0x71fe29c8] objaq: [0x71fe2778,0x71fe29d8]
 32   st: XCURRENT md: NULL fpin: 'ktspbwh2: ktspfmdb' tch: 2
 33   flags: block_written_once redo_since_read
 34   LRBA: [0x0.0.0] LSCN: [0x0.0] HSCN: [0xffff.ffffffff] HSUB: [1]
 35 
 36 
 37 数据块头部分
 38 
 39 
 40 Block dump from disk:
 41 buffer tsn: 9 rdba: 0x02000086 (8/134)
 42 scn: 0x0000.0005e12f seq: 0x01 flg: 0x06 tail: 0xe12f0601
 43 
 44 flg：0x06 (新建块)0x2(数据块延迟清洗推进scn和seq) 0X04(设置校验和) 0x08(临时块)
 45 type：0x06(表/索引块)
 46 frmt: 0x01(v7) 0x02(v8)
 47 
 48 
 49 frmt: 0x02 chkval: 0x5fe3 type: 0x06=trans data
 50 Hex dump of block: st=0, typ_found=1
 51 Dump of memory from 0x00007F00A6951A00 to 0x00007F00A6953A00
 52 7F00A6951A00 0000A206 02000086 0005E12F 06010000  [......../.......]
 53 7F00A6951A10 00005FE3 00000001 0000376B 0005E12D  [._......k7..-...]
 54 7F00A6951A20 00000000 0032F802 02000080 00120003  [......2.........]
 55 7F00A6951A30 00000135 00C006F6 00110056 00002001  [5.......V.... ..]
 56 7F00A6951A40 0005E12F 00000000 00000000 00000000  [/...............]
 57 7F00A6951A50 00000000 00000000 00000000 00000000  [................]
 58 7F00A6951A60 00000000 00010100 0014FFFF 1F791F8D  [..............y.]
 59 7F00A6951A70 00001F79 1F8D0001 00000000 00000000  [y...............]
 60 7F00A6951A80 00000000 00000000 00000000 00000000  [................]
 61         Repeat 502 times
 62 7F00A69539F0 02012C00 0402C102 41414141 E12F0601  [.,......AAAA../.]
 63 
 64 
 65 
 66 
 67 Block header dump:  0x02000086
 68  Object id on Block? Y
 69  seg/obj: 0x376b  csc: 0x00.5e12d  itc: 2  flg: E  typ: 1 - DATA
 70      brn: 0  bdba: 0x2000080 ver: 0x01 opc: 0
 71      inc: 0  exflg: 0
 72 
 73 
 74 
 75 
 76 
 77  Itl           Xid                  Uba         Flag  Lck        Scn/Fsc
 78 0x01   0x0003.012.00000135  0x00c006f6.0056.11  --U-    1  fsc 0x0000.0005e12f
 79 0x02   0x0000.000.00000000  0x00000000.0000.00  ----    0  fsc 0x0000.00000000
 80 bdba: 0x02000086
 81 data_block_dump,data header at 0x7f00a6951a64
 82 ===============
 83 tsiz: 0x1f98
 84 hsiz: 0x14
 85 pbl: 0x7f00a6951a64
 86      76543210
 87 flag=--------
 88 ntab=1
 89 nrow=1
 90 frre=-1
 91 fsbo=0x14
 92 fseo=0x1f8d
 93 avsp=0x1f79
 94 tosp=0x1f79
 95 0xe:pti[0]      nrow=1  offs=0
 96 0x12:pri[0]     offs=0x1f8d
 97 block_row_dump:
 98 tab 0, row 0, @0x1f8d
 99 tl: 11 fb: --H-FL-- lb: 0x1  cc: 2
100 col  0: [ 2]  c1 02
101 col  1: [ 4]  41 41 41 41
102 end_of_block_dump
103 End dump data blocks tsn: 9 file#: 8 minblk 134 maxblk 134

posted on 2018-04-23 10:10  ykyk_dba  阅读(246)  评论(0)  编辑  收藏  举报

导航