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: