ORA-02050 transaction processing xxx has been rolled back, some remote databases may have problems

Source: Internet
Author: User

ORA-02050 transaction processing xxx has been rolled back, some remote databases may have problems

-- Database check found a database today reported a ORA-02050 error:
ORA-02050: transactions 35.28.256948 have been rolled back and some remote databases may have problems
ORA-01013: user request to cancel current action
ORA-01013: user request to cancel current action

According to the error message, it may be caused by a remote database operation failure. View the above explanation of metalink:
Error: ORA 2050
Text: transaction <num> rolled back, some remote DBs may be in-doubt
-------------------------------------------------------------------------------
Cause: There was a network failure or a remote failure during the two-phase commit.
Action: policy the database administrator.
The remote databases will automatically resynchronize when the failure is retried red.

The remote database is automatically synchronized.
Query the two dictionaries dba_2pc_pending and dba_2pc_neighbors.
If no data is found, the data is automatically restored.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.