Oracle by Example - Oracle Database 10g on a Single Instance

Availability

Human errors are generally considered the biggest single cause of downtime, and Oracle Database 10g is a breakthrough release for human error correction by means of its greatly enhanced flashback capabilities. Flashback is a capability that lets an administrator “rewind” activity on the database. Flashback can be performed at the row, transaction, table or even database level. Point-in-time recovery of an error performed a few minutes ago can be performed in a few minutes; no restore of a backup and roll forward is required, thereby resulting in faster up-time.

Automatic backup and recovery can maintain a recovery area on disk that is incrementally "rolled forward" by updating on disk only those blocks changed since the last backup. The recovery area provides much faster and more reliable backup and restore compared to traditional tape based mechanisms. This ability to very quickly recover a system after a media failure results in much higher availability.

Click any of the tutorials below to display the instructions.