O'Reilly logo

OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide by Steve Ries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Performing incomplete recoveries

As we mentioned previously, an incomplete recovery occurs when the backup is restored and some, but not all, of the changes are applied. However, we need to set a condition, such as a time, in order to establish the point at which recovery will be stopped. In this section, we'll perform an incomplete recovery using one of these conditions as an example.

Understanding incomplete recovery

Incomplete recovery can be performed using three different methods. The method chosen depends on the granularity of the data that needs to be restored. Each method has certain advantages and disadvantages.

  • Sequence-based recovery: In this method, we use a log sequence number to establish the stopping point of the recovery. For example, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required