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, ...
Get OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
