1Z0-067 · Question #77
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. https://docs.oracle.com/database/121/RCMRF/rcmsynta2001.htm#RCMRF140 See Example 3-6 Recovering a NOARCHIVELOG Database STARTUP FORCE NOMOUNT; RESTORE CONTROLFILE; # restore control file from consistent backup ALTER DATABASE MOUNT; RESTORE DATABASE; # restore data files from…
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 datafilenoredo 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
(15 responses)- A7% (1)
- B87% (13)
- C7% (1)
Explanation
https://docs.oracle.com/database/121/RCMRF/rcmsynta2001.htm#RCMRF140 See Example 3-6 Recovering a NOARCHIVELOG Database STARTUP FORCE NOMOUNT; RESTORE CONTROLFILE; # restore control file from consistent backup ALTER DATABASE MOUNT; RESTORE DATABASE; # restore data files from consistent backup RECOVER DATABASE NOREDO; # specify NOREDO because online redo logs are lost ALTER DATABASE OPEN RESETLOGS;
Topics
Community Discussion
No community discussion yet for this question.