RMAN深入解析之--BlockRecover恢复坏块(二)

2014-11-24 17:17:49 · 作者: · 浏览: 1
1:34 prod_ora_2883.trc


-rw-r----- 1 oracle oinstall 69 Jul 15 11:34 prod_ora_2883.trm


-rw-r----- 1 oracle oinstall 557756 Jul 15 10:17 alert_prod.log


-rw-r----- 1 oracle oinstall 947 Jul 15 10:17 prod_ckpt_2541.trc


-rw-r----- 1 oracle oinstall 59 Jul 15 10:17 prod_ckpt_2541.trm


-rw-r----- 1 oracle oinstall 1783 Jul 15 10:12 prod_j000_2588.trc


-rw-r----- 1 oracle oinstall 80 Jul 15 10:12 prod_j000_2588.trm



查看转储文件:


[oracle@rh6 ~]$ cat /u01/app/oracle/diag/rdbms/prod/prod/trace/prod_ora_2883.trc|more


Trace file /u01/app/oracle/diag/rdbms/prod/prod/trace/prod_ora_2883.trc


Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production


With the Partitioning, OLAP, Data Mining and Real Application Testing options


ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1


System name: Linux


Node name: rh6


Release: 2.6.32-358.el6.x86_64


Version: #1 SMP Tue Jan 29 11:47:41 EST 2013


Machine: x86_64


Instance name: prod


Redo thread mounted by this instance: 1


Oracle process number: 26


Unix process pid: 2883, image: oracle@rh6 (TNS V1-V3)


*** 2014-07-15 11:34:50.092


*** SESSION ID:(37.32) 2014-07-15 11:34:50.092


*** CLIENT ID:() 2014-07-15 11:34:50.092


*** SERVICE NAME:(SYS$USERS) 2014-07-15 11:34:50.092


*** MODULE NAME:(sqlplus@rh6 (TNS V1-V3)) 2014-07-15 11:34:50.092


*** ACTION NAME:() 2014-07-15 11:34:50.092



Start dump data blocks tsn: 4 file#:4 minblk 170 maxblk 170


Block dump from cache:


Dump of buffer cache at level 4 for tsn=4, rdba=16777386


Block dump from disk:


buffer tsn: 4 rdba: 0x010000aa (4/170)


scn: 0x0000.001f891c seq: 0x02 flg: 0x04 tail: 0x891c2302


frmt: 0x02 chkval: 0x8eee type: 0x23=PAGETABLE SEGMENT HEADER


Hex dump of block: st=0, typ_found=1


Dump of memory from 0x00007F7DFC5C7A00 to 0x00007F7DFC5C9A00



7F7DFC5C7A00 0000A223 010000AA 001F891C 04020000 [#...............]


---此行内容与Uedit32打开内容一致


7F7DFC5C7A10 00008EEE 00000000 00000000 00000000 [................]


7F7DFC5C7A20 00000000 00000001 00000008 00000A9C [................]


7F7DFC5C7A30 00000000 00000008 00000008 010000B0 [................]


7F7DFC5C7A40 00000000 00000000 00000000 00000008 [................]


7F7DFC5C7A50 00000000 00000000 00000000 00000000 [................]


7F7DFC5C7A60 00000008 00000008 010000B0 00000000 [................]


7F7DFC5C7A70 00000000 00000000 00000008 010000A8 [................]


7F7DFC5C7A80 010000A8 00000000 00000000 00000000 [................]


7F7DFC5C7A90 00000000 00000000 00000000 00000000 [................]


Repeat 3 times


7F7DFC5C7AD0 00000001 00002000 00000000 00001434 [..... ......4...]


7F7DFC5C7AE0 00000000 010000A9 00000001 010000A8 [................]


7F7DFC5C7AF0 010000A9 00000000 00000000 00000000 [................]


7F7DFC5C7B00 00000000 00000000 00000001 00000000 [................]


7F7DFC5C7B10 0001257B 10000000 010000A8 00000008 [{%..............]


7F7DFC5C7B20 00000000 00000000 00000000 00000000 [................]


Repeat 152 times


7F7DFC5C84B0 010000A8 010000AB 00000000 00000000 [................]


7F7DFC5C84C0 00000000 00000000 00000000 00000000 [................]


Repeat 151 times


7F7DFC5C8E40 00000000 00000000 010000A9 00000000 [................]


7F7DFC5C8E50 00000000 00000000 00000000 00000000 [................]


Repeat 185 times


7F7DFC5C99F0 00000000 00000000 00000000 891C2302 [.............#..]


Extent Control Header


-------------