Oracle数据库恢复：归档日志损坏案例一则(2)

　　KCRP: blocks claimed = 84, eliminated = 0

　　----- Recovery Hash Table Statistics ---------

　　Hash table buckets = 32768

　　Longest hash chain = 1

　　Average hash chain = 84/84 = 1.0

　　Max compares per lookup = 0

　　Avg compares per lookup = 0/84 = 0.0

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

　　----- Recovery Hash Table Statistics ---------

　　Hash table buckets = 32768

　　Longest hash chain = 1

　　Average hash chain = 84/84 = 1.0

　　Max compares per lookup = 1

　　Avg compares per lookup = 880/880 = 1.0

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

　　^A&A

　　^1b#

　　^1b!

　　^1b"

　　^0e\'

　　^Mj8

　　^;&3

　　2010PS_Legal Entity

　　^6&L

　　Eoi_VND

　　Quick Payment: ID=47708

　　Cn/a

　　UNSENT

　　^9&1

　　\\HPAYMENT

　　CREATEDNAP_CHECKS

　　^0e)

　　\\Hxn

　　Dump file /ADMIN/bdump/erp_p001_19204.trc

　　Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production

　　With the Partitioning, OLAP and Data Mining options

　　ORACLE_HOME = /DBMS/erp/erpdb/10g

　　Linux

　　eygle.com

　　2.6.9-34.ELhugemem

　　#1 SMP Fri Feb 24 17:04:34 EST 2006

　　i686

　　Instance name: erp

　　Redo thread mounted by this instance: 1

　　Oracle process number: 16

　　Unix process pid: 19204, image: oracle@eygle.com (P001)

　　*** SERVICE NAME:() 2010-11-10 10:37:26.372

　　*** SESSION ID:(2189.1) 2010-11-10 10:37:26.372

　　*** 2010-11-10 10:37:26.372

　　KCRP: blocks claimed = 132, eliminated = 0

　　----- Recovery Hash Table Statistics ---------

　　Hash table buckets = 32768

　　Longest hash chain = 1

　　Average hash chain = 132/132 = 1.0

　　Max compares per lookup = 0

　　Avg compares per lookup = 0/132 = 0.0

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

　　----- Recovery Hash Table Statistics ---------

　　Hash table buckets = 32768

　　Longest hash chain = 1

　　Average hash chain = 132/132 = 1.0

　　Max compares per lookup = 1

　　Avg compares per lookup = 3219/3219 = 1.0

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

　　^ij!

　　^ij$

　　^ij!

　　@e>df

　　>df^>df

　　Userxn

　　Chen Restaurant

　　300190143

　　CASH CLEARING

　　AP_CHECKS

　　CREATED

　　ACCOUNTED

　　^ij!

　　CHECK

　　en/a

　　Quick Payment: ID=47708

　　n/a^n/a

　　CHECK

　　Chen Restaurant

　　210301

　　5&1`

　　54^`

　　^1b$

　　^1b&

　　^1b6

　　^1b,

　　^1b-

　　^1b4

　　^1b5

　　^1b0

　　^1b2

　　Dump file /ADMIN/bdump/erp_p000_19202.trc

　　Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production

　　With the Partitioning, OLAP and Data Mining options

　　ORACLE_HOME = /DBMS/erp/erpdb/10g

　　Linux

　　eygle.com

　　2.6.9-34.ELhugemem

　　#1 SMP Fri Feb 24 17:04:34 EST 2006

　　i686

　　Instance name: erp

　　Redo thread mounted by this instance: 1

　　Oracle process number: 15

　　Unix process pid: 19202, image: oracle@eygle.com (P000)

　　*** SERVICE NAME:() 2010-11-10 10:37:26.386

　　*** SESSION ID:(2190.1) 2010-11-10 10:37:26.386

　　*** 2010-11-10 10:37:26.386

　　KCRP: blocks claimed = 181, eliminated = 0

　　----- Recovery Hash Table Statistics ---------

　　Hash table buckets = 32768

　　Longest hash chain = 1

　　Average hash chain = 181/181 = 1.0

　　Max compares per lookup = 0

　　Avg compares per lookup = 0/181 = 0.0

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

　　----- Recovery Hash Table Statistics ---------

　　Hash table buckets = 32768

　　Longest hash chain = 1

　　Average hash chain = 181/181 = 1.0

　　Max compares per lookup = 1

　　Avg compares per lookup = 8629/8629 = 1.0

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

　　^ij0

　　AGENT_STATUS_MARKER

　　^AGENTS_MARKED

　　R0:b

　　^E!

原文转自：http://blogread.cn/it/article/3277