Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Capture Process Stuck: state= WAITING FOR REDO

519674Jun 21 2007 — edited Aug 27 2007

Hi,
Any ideas on how to dig deeper in to cause of this hang?

I have tried stop/start, reboot machine.

10.2.0.3 on Windows with bi-directional streams schema replication.

last few lines of the capture process trace file (trace level 7)

knlcLoop: logminer returned 0 lcrs, lowscn =0x0000.08859d23,return val = 204
knlcLoop: logminer returned 0 lcrs, lowscn =0x0000.08859d23,return val = 204
knlcLoop: logminer returned 0 lcrs, lowscn =0x0000.08859d23,return val = 204
knlcLoop: logminer returned 0 lcrs, lowscn =0x0000.08859d23,return val = 204
knlcLoop: logminer returned 0 lcrs, lowscn =0x0000.08859d23,return val = 204
knlcLoop: logminer returned 0 lcrs, lowscn =0x0000.08859d23,return val = 204
knlcLoop: logminer returned 0 lcrs, lowscn =0x0000.08859d23,return val = 204
knlcLoop: logminer returned 0 lcrs, lowscn =0x0000.08859d23,return val = 204
knlcLoop: logminer returned 0 lcrs, lowscn =0x0000.08859d23,return val = 204
knlcLoop: logminer returned 0 lcrs, lowscn =0x0000.08859d23,return val = 204
knlcLoop: logminer returned 0 lcrs, lowscn =0x0000.08859d23,return val = 204
knlcLoop: logminer returned 0 lcrs, lowscn =0x0000.08859d23,return val = 204
knlcLoop: logminer returned 0 lcrs, lowscn =0x0000.08859d23,return val = 204
knlcLoop: logminer returned 0 lcrs, lowscn =0x0000.08859d23,return val = 204
knlcLoop: logminer returned 0 lcrs, lowscn =0x0000.08859d23,return val = 204
knlcLoop: logminer returned 0 lcrs, lowscn =0x0000.08859d23,return val = 204
knlcLoop: logminer returned 0 lcrs, lowscn =0x0000.08859d23,return val = 204
knlcLoop: logminer returned 0 lcrs, lowscn =0x0000.08859d23,return val = 204
knlcLoop: logminer returned 0 lcrs, lowscn =0x0000.08859d23,return val = 204
knlcLoop: logminer returned 0 lcrs, lowscn =0x0000.08859d23,return val = 204

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 24 2007

Added on Jun 21 2007

#performance-availability, #streams

14 comments

3,549 views