| Indoubt Transaction [message #123127] |
Fri, 10 June 2005 00:07  |
mrinal.c
Messages: 2
Registered: June 2005
|
Junior Member |
|
|
Hi Gurus,
We have seen an indoubt transaction using the command.
SQL> select * from dba_2pc_pending;
we got the the transaction id as '3.60.797'
then we rolled back the transaction using the command
SQL>rollback force '3.60.797'
Again when we did SQL> select * from dba_2pc_pending;
we get the output as
LOCAL_TRAN_ID GLOBAL_TRAN_ID STATE MIXED ADVICE TRAN_COMMENT FAIL_TIME FORCE_TIME RETRY_TIME OS_USER OS_TERMINAL HOST DB_USER COMMIT#
---------------------- -------------------------------------------------------------------------------- ---------------- ----- ------ -------------------------------------------------------------------------------- ----------- ----------- ----------- ---------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ------------------------------ ----------------
3.60.797 113577.000400B1011753434D4230353036303431333136320000000000000065 forced rollback no 6/4/05 2:45 6/7/05 10:1 6/8/05 11:3 cics amu1 2509852
We tried to force it again.But we are getting the error as ::
ORA-02058 no transaction id found with 3.60.797
We don't use data replication and our database is in non archive mode.
Still after the machine reboot the transaction is in pending state .
Now it is showing error like...
SQL> select * from dba_2pc_pending;
LOCAL_TRAN_ID GLOBAL_TRAN_ID STATE MIXED ADVICE TRAN_COMMENT FAIL_TIME FORCE_TIME RETRY_TIME OS_USER OS_TERMINAL HOST DB_USER COMMIT#
---------------------- -------------------------------------------------------------------------------- ---------------- ----- ------ -------------------------------------------------------------------------------- ----------- ----------- ----------- ---------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ------------------------------ ----------------
3.60.797 113577.000400B1011753434D4230353036303431333136320000000000000065 forced rollback no 6/4/05 2:45 6/7/05 10:1 6/8/05 1:10 cics amu1 2509852
Please suggest how to go further.
Thanks in advance
Best Regards,
Mrinal
|
|
|
|
| Re: Indoubt Transaction [message #123136 is a reply to message #123127] |
Fri, 10 June 2005 01:26  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
Do you have a RECO process running for your DB? If not, enable it with ALTER SYSTEM ENABLE DISTRIBUTED RECOVERY;
Also, check your ALERT.LOG file for any additional info.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
