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?
A.
recovery cannot be performed because a backup was not performed after the last
incomplete recovery
B.
restore all the files from Sunday’s backup, and then recover up to the point in time when
the RESETLOGS operation was performed on Tuesday
C.
restore all the files from Sunday’s backup, and open the database to reset the database
to the point in time when the backup was performed on Sunday
D.
restore all the files from Sunday’s backup, and then perform an incomplete recovery up to
the point in time when the user error occurred on
E.
Thursday