TRANSACTION_RECOVERY
TRANSACTION_RECOVERY specifies whether transaction recovery is enabled or disabled for a PDB.
Transaction recovery refers to the series of steps that the database performs in the event of a crash (either an instance crash or a transaction crash) to roll back uncommitted transactions.
| Property | Description |
|---|---|
| Parameter type | String |
| Syntax | TRANSACTION_RECOVERY = { ENABLED | DISABLED } |
| Default value | ENABLED |
| Modifiable | ALTER SYSTEM |
| Modifiable in a PDB | Yes |
| Basic | No |
| Oracle RAC | Multiple instances must use the same value. |
Values:
-
ENABLED- Transaction recovery is enabled for a PDB. -
DISABLED- Transaction recovery is disabled for a PDB.
During normal operation, the value of this parameter is set to ENABLED by the database and this setting should not be modified by a DBA. However, there are two circumstances under which it is permissible for a DBA to modify the value of this parameter:
-
A quarantined transaction is a transaction that is isolated and for which transaction recovery will not be attempted while the quarantine on it remains. It requires intervention by the DBA to first resolve the issue that caused the transaction to be quarantined, and then to drop the transaction quarantine so that transaction recovery is attempted again. If transaction recovery becomes disabled on a PDB due to an excessive number of quarantined transactions (a process known as “transaction quarantine escalation”), then the database automatically sets the value of this parameter to
DISABLED. When this happens, the DBA should take corrective action for the quarantined transactions, then restart transaction recovery for the PDB by setting the value of this parameter toENABLED. Refer to Oracle AI Database Administrator’s Guide to learn about this entire process before you set this parameter. -
While working to resolve an issue, Oracle Support may instruct a DBA to temporarily disable transaction recovery by setting this parameter to
DISABLED. After the issue has been resolved, this parameter should ultimately be set back toENABLEDso that normal database operation can resume.
Caution: You should never set this parameter to DISABLED unless specifically directed to do so by Oracle Support. Setting this parameter to DISABLED could lead to severe problems
Note: The TRANSACTION_RECOVERY initialization parameter is deprecated.