A power outage has occurred and you have to restart the database. During the restart, the database system restores the database starting from the time of the last savepoint.
Status of the Transactions at the Time of System Failure
Transaction |
What Does the Database System Do? |
---|---|
T1 |
None The changes by transaction T1 were completely written to the data area by the last savepoint before the system failure. |
T2, T3 |
The database system rolls back the changes made before the savepoint. To do this, it evaluates the corresponding undo log files. |
T5 |
None The database system had already rolled back the changes by T5 before the system failure (ROLLBACK). These changes were never written to the data area through a savepoint. |
T4, T6 |
The database system imports the required redo log entries for these transactions and repeats the transactions (ROLL FORWARD). |