ora-01591 : Lock held by in doubt transaction [message #75512] |
Wed, 23 June 2004 04:21 |
S Varshney
Messages: 1 Registered: June 2004
|
Junior Member |
|
|
Hi.
We are using oracle 8.0 replication features. It is multi master based replication
with two sites(L1 and L2) . One of the site(L2) was having network connectivity
issue for two days. After two days when we started the site database, we found
transaction are not getting replicated to the sites…
On replication manager when I go and click it shows me error – Ora-01591 lock
held by in-doubt transaction 9.2.118602.
At site L2 I found the state of pending transaction is committed but at L1 the state
of pending transaction is prepared. I tried to manually commit the transaction
using following command
force commit ‘9.2.118602’ at site L1
but still the state of pending transaction is ‘prepared’. Please suggest how to
start replication and resolve the error..
thanks in advance
SV
|
|
|