Multiple choice technology databases

When performing an incomplete recovery of the whole database, what must be true about the data files that are restored ?

  1. All of the data files must be from a backup taken prior to the point in time to which you want to recover.

  2. Only the data files belonging from the SYSTEM tablespace must be from a backup taken prior to the point in time to which you want to recover.

  3. Only the data files that need recovery must be from a backup taken prior to the point in time which you want to recover.

  4. Only the data files belonging to the SYSTEM tablespace and the data files that need recovery must be from a backup taken prior to the point in time to which you want to recover.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Incomplete database recovery requires ALL data files to be from a consistent point in time - a backup taken prior to the target recovery time. If some files are from newer backups, the database won't be consistent at the recovery point. Oracle applies redo logs to bring all files forward to the same point-in-time, but they must all start from before that point.

Keep practicing — related questions