RE: RAC CR REQUEST RETRY - Which node is holding the data block?
From: <Christopher.Taylor2_at_parallon.net>
Date: Tue, 13 Nov 2012 10:28:29 -0600
Message-ID: <F05D8DF1FB25F44085DB74CB916678E8856500F647_at_NADCWPMSGCMS10.hca.corpad.net>
I should mention I did capture the block_id that is being requested: Wait Class <http://nagrdp01.unix.medcity.net:4889/em/console/database/instance/sessionDetails?event=doLoad&targetÌMNASP1_CCMNASP1N1&type=oracle_database&SIDS66&serialNumR506&source=topSessions&pageNum=6&refreshChoice=RT_15>
Date: Tue, 13 Nov 2012 10:28:29 -0600
Message-ID: <F05D8DF1FB25F44085DB74CB916678E8856500F647_at_NADCWPMSGCMS10.hca.corpad.net>
I should mention I did capture the block_id that is being requested: Wait Class <http://nagrdp01.unix.medcity.net:4889/em/console/database/instance/sessionDetails?event=doLoad&targetÌMNASP1_CCMNASP1N1&type=oracle_database&SIDS66&serialNumR506&source=topSessions&pageNum=6&refreshChoice=RT_15>
Other
cr request retry
file#
29
block#
242369
0
0
Cluster
gc cr failure
29
242369
1
0
From: Taylor Christopher - Nashville
Sent: Tuesday, November 13, 2012 10:26 AM
To: oracle-l_at_freelists.org
Subject: RAC CR REQUEST RETRY - Which node is holding the data block?
Setup:
10.2.0.4 64-bit
RHEL 3 node RAC
node1 is requesting blocks for a transaction - either node2 or node3 is holding the block(s) that are being requested.
How can I determine which node(s) of the cluster are holding the requested block(s)?
Regards,
Chris Taylor
Oracle DBA
Parallon IT&S
christopher.taylor2_at_parallon.net<mailto:christopher.taylor2_at_parallon.net>
www.parallon.net
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 13 2012 - 17:28:29 CET