| Standard |
Fast recovery is successful. All committed log
records are rolled forward, and all incomplete transactions are
rolled back. |
| Temp or Scratch |
Temp and scratch tables are not recoverable because
they are dropped when the database server restarts. All changes
made to these tables are lost, and the space can be reused. |
| Raw |
If a checkpoint completed since the raw table
was modified last, all the data is recoverable. Updates and deletions
that occurred after the last checkpoint are lost. The raw table
looks as it did at the last checkpoint. If a light append was in
progress at the time of the failure, all appended records are lost
on reboot. |
| Static |
If you alter a raw table to static, you can recover
it only if it was not updated since the previous checkpoint. If
you alter an operational table to static, you can recover it only
if light appends did not occur. If light appends occurred, they
are lost on reboot. If you alter a standard table to static, you
can recover it successfully. |
| Operational |
All inserts, deletions, and updates are successfully
recovered. All committed log records are rolled forward and incomplete transactions
are rolled back. If a light append was in progress at the time of
the failure, all appended records are lost on reboot. |