Monday, January 11, 2016

3 Phases Restore process: copy, redo, undo

A restore is a multiphase process. The possible phases of a restore include the data copy, redo (roll forward), and undo (roll back) phases:
  • The data copy phase involves copying all the data, log, and index pages from the backup media of a database to the database files.
  • The redo phase applies the logged transactions to the data copied from
    the backup to roll forward that data
    to the recovery point. At this point, a database typically has uncommitted
    transactions and is in an unusable
    state. In that case, an undo phase is required as part of recovering the
    database.
  • The undo phase, which is the first part of recovery, rolls back any
    uncommitted transactions and makes
    the database available to users.
    After the roll back phase, subsequent backups cannot be restored.

A restore is a multiphase process. The possible phases of a restore include the data copy, redo (roll forward), and undo (roll back) phases:
  • The data copy phase involves copying all the data, log, and index pages from the backup media of a database to the database files.
  • The redo phase applies the logged transactions to the data copied from
    the backup to roll forward that data
    to the recovery point. At this point, a database typically has uncommitted
    transactions and is in an unusable
    state. In that case, an undo phase is required as part of recovering the
    database.
  • The undo phase, which is the first part of recovery, rolls back any
    uncommitted transactions and makes
    the database available to users.
    After the roll back phase, subsequent backups cannot be restored.

No comments:

Post a Comment