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 SYSTEM tablespace from last Sunday’s backup,
and then perform a complete recovery.