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.
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, if the sequence number of our current redo log is 435, we might only recover our database up to the archivelog with the sequence number 429.
Time-based recovery: In this method, we define a time up to which changes will be applied. If we need...