Disabling recovery - Alter system disable distributed recovery - Oracle Transaction

Q.  Select the correct SQL statement for disabling recovery.
- Published on 12 Aug 15

a. alter system disable distributed recovery;
b. update system disable distributed recovery;
c. select system disable distributed recovery;
d. delete system disable distributed recovery;

ANSWER: alter system disable distributed recovery;
 

    Discussion

  • Nirja Shah   -Posted on 22 Sep 15
    - The RECO background process of an Oracle Database instance automatically resolves failures involving distributed transactions.

    - At exponentially growing time intervals, the RECO background process of a node attempts to recover the local portion of an in-doubt distributed transaction.

    - RECO can use an existing connection or establish a new connection to other nodes involved in the failed transaction.

    - When a connection is established, RECO automatically resolves all in-doubt transactions.

    - Rows corresponding to any resolved in-doubt transactions are automatically removed from the pending transaction table of each database.

    - You can enable and disable RECO using the ALTER SYSTEM statement with the ENABLE/DISABLE DISTRIBUTED RECOVERY options.

    - For example, you can temporarily disable RECO to force the failure of a two-phase commit and manually resolve the in-doubt transaction.

    - The following statement disables RECO:

    ALTER SYSTEM DISABLE DISTRIBUTED RECOVERY;

    - Alternatively, the following statement enables RECO so that in-doubt transactions are automatically resolved:

    ALTER SYSTEM ENABLE DISTRIBUTED RECOVERY;

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)