Performing Oracle Advanced Recovery - OCP: Oracle Database 12c Administrator Certified Professional - page 315

TABle 7.3 Recovery timelines when using incrementally updated backups data-pump
should be Data Pump

Mirror Backup
Taken

Incremental
Merged

Incremental
Created

Incremental
Deleted

Farthest day you can
recover to Day #

1 Y N N N 1

2 N N Y N 1

3 N N Y N 1

4 N N Y N 1

5 N N Y N 1

6 N N Y N 1

7 N N Y N 1

8 N Y (day #2) Y Y (day #2) 2

9 N Y (day #3) Y Y (day #3) 3

Obviously, as your retention requirement increases, your storage space requirements will
increase (since you are storing more incremental backups). However, since these backups
can be compressed, you might be able to mitigate the space usage.

Restoring from Incrementally Updated Backups

There is nothing special about restoring from incrementally updated backups. RMAN will
detect which recovery strategy will be the most efficient and act accordingly. If it finds that
there is an incrementally updated backup, then it will use that backup for restore and recovery
automatically.

Performing Table and Partition
Recovery from Backups

Until Oracle Database 12 c , there were limited options available for the restore of individ-
ual tables and partitions or a set of tables and partitions. In the past, restores like these
were problematic and time consuming. Often the restore would require that you restore