🎴 Flashcard Mode
Oracle Database Administration: Storage, Backups and Recovery
Card1 / 20
Mastered0
Review0
QuestionClick to flip
When performing an incomplete recovery of the whole database, what must be true about the data files that are restored ?
AnswerClick to flip back
A
All of the data files must be from a backup taken prior to the point in time to which you want to recover.
💡 Explanation:
For incomplete recovery, the entire database must be restored to a consistent state prior to the target time. Thus, all restored data files must originate from backups taken before the point-in-time target. Restoring only SYSTEM or a subset of files prevents full consistency.