Oracle & MySQL Support

InfraStack-Labs Oracle & MySQL DBA Services help you manage, maintain, and optimize your critical Oracle systems. We deliver 24/7, year-round support with flexible monthly contracts that don’t lock you in.

Please contact me :- ajith.narayanan@infrastack-labs.in

Friday, October 21, 2011

Rollback Of Single Transaction

SQL> select local_tran_id from dba_2pc_pending; 
LOCAL_TRAN_ID
----------------------
10.1.1306666
11.29.1398766
12.21.996344
17.27.1267023
26.30.1222781
3.4.1280743
31.13.928667
38.1.469932
40.33.554319
42.2.502494
52.8.263605

LOCAL_TRAN_ID
----------------------
56.19.234600
58.12.278189
66.9.233351
7.32.277783

15 rows selected.


SQL> Rollback Force '26.30.1222781';
Rollback complete.


SQL> select local_tran_id from dba_2pc_pending where local_tran_id='26.30.1222781';
LOCAL_TRAN_ID
----------------------
26.30.1222781


SQL> execute dbms_transaction.purge_lost_db_entry('26.30.1222781');
PL/SQL procedure successfully completed.


SQL> select local_tran_id from dba_2pc_pending where local_tran_id='26.30.1222781';
no rows selected


SQL> select name from v$database;
NAME
---------
AJITHDB

No comments:

Post a Comment

Thanks for you valuable comments !