Oracle
1Z0-043 · Question #121
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…
The correct answer is B. Restore all the data files from last Sunday's backup, and then perform a cancel-based recovery. See the full explanation below for the reasoning.
Question
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?
Options
- ARestore all the data files from last Sunday's backup, and then perform a time-based recovery.
- BRestore all the data files from last Sunday's backup, and then perform a cancel-based recovery.
- CRestore all the data files from last Sunday's backup, and then perform a change-based recovery.
- DRestore only data files that belong to the SYSTEM tablespace from last Sunday's backup, and then
How the community answered
(26 responses)- A4% (1)
- B77% (20)
- C8% (2)
- D12% (3)
Community Discussion
No community discussion yet for this question.