Oracle
1Z0-063 · Question #178
You are administering a database that supports a data warehousing workload and is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 incremental backups on…
The correct answer is B. Restore the control file and all the data files, recover them by using the recover database noredo. See the full explanation below for the reasoning.
Question
You are administering a database that supports a data warehousing workload and is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 incremental backups on all the other days of the week. One of the data files is corrupted and the current online redo log file is lost because of a media failure. Which action must you take for recovery?
Options
- ARestore the data file, recover it by using the recover datafile noredo command, and use the
- BRestore the control file and all the data files, recover them by using the recover database noredo
- CRestore all the data files, recover them by using the recover database command, and open the
- DRestore all the data files, recover them by using the recover database noredo command, and use
How the community answered
(30 responses)- A7% (2)
- B80% (24)
- C3% (1)
- D10% (3)
Community Discussion
No community discussion yet for this question.