Recovery Hash Table Statistics与thread 2 seq 374

oracle dba培训http://www.cuug.com/*** 2011-06-27 22:19:28.279

2011-06-27 22:19:28.279849 : Start recovery for domain=0, valid=0, flags=0x0

Successfully allocated 2 recovery slaves

Using 67 overflow buffers per recovery slave

Thread 2 checkpoint: logseq 374, block 2, scn 54624376

  cache-low rba: logseq 374, block 2

    on-disk rba: logseq 374, block 178, scn 54626382

  start recovery at logseq 374, block 2, scn 54624376

Instance recovery not required for thread 1

 

*** 2011-06-27 22:19:28.487

Started writing zeroblks thread 2 seq 374 blocks 178-185

 

*** 2011-06-27 22:19:28.487

Completed writing zeroblks thread 2 seq 374

==== Redo read statistics for thread 2 ====

Total physical reads (from disk and memory): 4096Kb

-- Redo read_disk statistics --

Read rate (ASYNC): 88Kb in 0.18s => 0.48 Mb/sec

Longest record: 8Kb, moves: 0/186 (0%)

Longest LWN: 33Kb, moves: 0/47 (0%), moved: 0Mb

Last redo scn: 0x0000.0341884d (54626381)

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

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

Hash table buckets = 262144

Longest hash chain = 1

Average hash chain = 82/82 = 1.0

Max compares per lookup = 1

Avg compares per lookup = 248/330 = 0.8

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

 

*** 2011-06-27 22:19:28.489

KCRA: start recovery claims for 82 data blocks

 

*** 2011-06-27 22:19:28.526

KCRA: blocks processed = 82/82, claimed = 81, eliminated = 1

2011-06-27 22:19:28.526088 : Validate domain 0

 **************** BEGIN RECOVERY HA STATS  ****************

 

 I'm the recovery instance

 

 smon posted (1278500359646), recovery started 0.027 secs,(1278500359673)

 domain validated 0.242 secs (1278500359888)

 claims opened 70, claims converted 11, claims preread 0

 

 ****************  END RECOVERY HA STATS  *****************

2011-06-27 22:19:28.526668 : Validated domain 0, flags = 0x0

 

*** 2011-06-27 22:19:28.556

Recovery of Online Redo Log: Thread 2 Group 4 Seq 374 Reading mem 0

 

*** 2011-06-27 22:19:28.560

Completed redo application of 0.07MB

 

*** 2011-06-27 22:19:28.569

Completed recovery checkpoint

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

Hash table buckets = 262144

Longest hash chain = 1

Average hash chain = 82/82 = 1.0

Max compares per lookup = 1

Avg compares per lookup = 330/330 = 1.0

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

*** 2011-06-27 22:19:28.572 5401 krsg.c

Acquiring RECOVERY INFO PING latch from [krsg.c:5401] IX0

*** 2011-06-27 22:19:28.572 5401 krsg.c

Successfully acquired RECOVERY INFO PING latch IX+

*** 2011-06-27 22:19:28.572 5406 krsg.c

Freeing RECOVERY INFO PING latch from [krsg.c:5406] IX0

*** 2011-06-27 22:19:28.572 5406 krsg.c

Successfully freed RECOVERY INFO PING latch IX-

krss_sched_work: Prod archiver request from process SMON (function:0x2000)

krss_find_arc: Evaluating ARC3 to receive message (flags 0x0)

krss_find_arc: Evaluating ARC0 to receive message (flags 0x0)

krss_find_arc: Evaluating ARC1 to receive message (flags 0xc)

krss_find_arc: Evaluating ARC2 to receive message (flags 0x2)

krss_find_arc: Selecting ARC2 to receive REC PING message

*** 2011-06-27 22:19:28.572 3093 krsv.c

krsv_send_msg: Sending message to process ARC2

*** 2011-06-27 22:19:28.572 1819 krss.c

krss_send_arc: Sent message to ARC2 (message:0x2000)

Recovery sets nab of thread 2 seq 374 to 178 with 8 zeroblks

Retrieving log 4

pre-aal: xlno:4 flno:0 arf:0 arb:2 arh:2 art:4

Updating log 3 thread 2 sequence 375

Previous log 3 thread 2 sequence 0

Updating log 4 thread 2 sequence 374

Previous log 4 thread 2 sequence 374

post-aal: xlno:4 flno:0 arf:3 arb:2 arh:2 art:3

krss_sched_work: Prod archiver request from process SMON (function:0x1)

krss_find_arc: Evaluating ARC3 to receive message (flags 0x0)

krss_find_arc: Selecting ARC3 to receive message

*** 2011-06-27 22:19:28.589 3093 krsv.c

krsv_send_msg: Sending message to process ARC3

*** 2011-06-27 22:19:28.589 1819 krss.c

krss_send_arc: Sent message to ARC3 (message:0x1)

Retrieving log 2

Kicking thread 1 to switch logfile

Retrieving log 4

Retrieving log 3

krss_sched_work: Prod archiver request from process SMON (function:0x1)

krss_find_arc: Evaluating ARC0 to receive message (flags 0x0)

krss_find_arc: Selecting ARC0 to receive message

*** 2011-06-27 22:19:28.599 3093 krsv.c

krsv_send_msg: Sending message to process ARC0

*** 2011-06-27 22:19:28.599 1819 krss.c

krss_send_arc: Sent message to ARC0 (message:0x1)

*** 2011-06-27 22:19:28.599 838 krsv.c

krsv_dpga: Waiting for pending I/O to complete