Oracle
1Z0-043 · Question #181
Every Sunday, consistent backups are performed on your database. Because of a user error, you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user…
The correct answer is D. restore all the files from Sunday's backup, and then perform an incomplete recovery up to the. See the full explanation below for the reasoning.
Question
Every Sunday, consistent backups are performed on your database. Because of a user error, you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday, which necessitates an incomplete recovery. Sunday's backup is the most recent backup available. What would you do in this scenario?
Options
- Arecovery cannot be performed because a backup was not performed after the last incomplete recovery
- Brestore all the files from Sunday's backup, and then recover up to the point in time when the
- Crestore all the files from Sunday's backup, and open the database to reset the database to the
- Drestore all the files from Sunday's backup, and then perform an incomplete recovery up to the
How the community answered
(33 responses)- A3% (1)
- B12% (4)
- C9% (3)
- D76% (25)
Community Discussion
No community discussion yet for this question.