Try OpenEdge Now
skip to main content
Database Administration
Protecting Your Data : Recovering a Database : Recovering from media failures : Loss of transaction log file
 
Loss of transaction log file
If you cannot access the database because of a lost or corrupt transaction log file, you must end and then enable two-phase commit.
To recover from the loss of a transaction log file:
1. If two-phase commit is enabled for the database, end two-phase commit using the PROUTIL 2PHASE END utility.
Note: If you end two-phase commit and a coordinator recorded any distributed transaction commits in this database, the user cannot resolve any limbo transactions for that distributed transaction unless after-imaging is also enabled for the database.
2. Enable two-phase commit using the PROUTIL 2PHASE BEGIN utility.
3. Put the database back online.