- Media Failure
- Human Error
of tables that are likely targets of human errors is a good way to handle accidental table drops. Flashback Query, a new feature introduced in Oracle9i, is very good at recovering from accidental deletes or inserts. As a final resort, the entire tablespace containing the object affected by the human error may have to be
restored from backup and recovered. These are various recovery methods for human errors that should all be tested
- Data Block Corruption
recovered. This lowers the Mean Time to Recovery (MTTR) because only blocks needing recovery are restored and recovered while the effected datafiles remain online.
can survive such disasters without compromising their service level agreements. By thoroughly testing and documenting the recovery plan database administrators can substantially limit unexpected outages and enhance their database system's availability.