You database operates in ARCHIVELOG mode and user-managed consistent backups are
performed every Sunday night. On Tuesday, at 9:00 A.m. the current log sequence number was
369. Also, on Tuesday you lost the data file belonging to the SYSTEM tablespace and an
achivelog file (sequence number 356) that contained redo entries between 8:00 A.m. and 8.30
A.m. With reference to this scenario, what would you do to recover the database?
A.
Restore all the data files from last Sunday’s backup, and then perform a time-based recovery.
B.
Restore all the data files from last Sunday’s backup, and then perform a cancel-based recovery.
C.
Restore all the data files from last Sunday’s backup, and then perform a change-based
recovery.
D.
Restore only data files that belong to the SYSTEMtablespace from last Sunday’s backup, and
then perform a complete recovery.