Recovering table spaces in recoverable databases

When crash recovery is necessary, the damaged table space is taken offline and is not accessible. It is placed in roll-forward pending state. If there are no additional problems, a restart operation succeeds in bringing the database online even with the damaged table space. Once online, the damaged table space is unusable, but the rest of the database is usable. To fix the damaged table space and make it usable, use the following procedure.

Procedure

To make the damaged table space usable, use one of the procedures that follow:

  • Method 1
    1. Fix the damaged containers without losing the original data.
    2. Complete a table space rollforward operation to the end of the logs.
      Note: The rollforward operation first attempts to bring the table space from offline to normal state.
  • Method 2
    1. Fix the damaged containers with or without losing the original data.
    2. Perform a table space restore operation.
    3. Complete a table space rollforward operation to the end of the logs or to a point-in-time.