Examine the command:
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
In which two scenarios is this command required?
A.
The current online redo log file is missing.
B.
A data file belonging to a noncritical tablespace is missing.
C.
All the control files are missing.
D.
The database backup is older than the control file backup.
E.
All the data files are missing.
I think only c is correct. Any idea?
http://searchoracle.techtarget.com/answer/Recover-database-using-backup-controlfile-until-cancel
A and C
I think AC too.
I think D may br a option here. Not sure though…
C and D
C, D thanks OCP_L
C here
If you are using a backup control file with this incomplete recovery, then specify the USING BACKUP CONTROLFILE option in the RECOVER command.
RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE
https://docs.oracle.com/cd/B10501_01/server.920/a96572/performingreco.htm
No reference for D :((
Cna you explain why D ? I also think it’s right but couldn’t find it nowhere…
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/osadvsce.htm#BRADV90043
CD
AC is correct
A C are correct.
Why A:
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/osadvsce.htm#BRADV90043
Begin recovery by executing the RECOVER command with the USING BACKUP CONTROLFILE clause. Specify UNTIL CANCEL if you are performing incomplete recovery. For example, enter:
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
Apply the prompted archived logs. If you then receive another message saying that the required archived log is missing, then it probably means that a ******necessary redo record is located in the online redo logs. This situation can occur when unarchived changes were located in the online logs when the instance failed.*****
B & C:
https://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:1143434607537
Sorry, NOT B & C
It is:
A & C:
A:
http://docs.oracle.com/cd/B19306_01/backup.102/b14191/recoscen.htm#BRADV229
“(…)
Recovering After the Loss of All Members of an Online Redo Log Group
(…)
If the group is current, then it is the log that the database is currently writing to and you should attempt to clear the log; if impossible, then you must restore a backup and perform incomplete recovery up to the most recent available redo log.”
C: https://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:1143434607537
It’s A&C
D is not correct as the question says recover database from backup controlfile UNTIL CANCEL.
UNTIL CANCEL is not suitable answer for D
AC
for C: it’s evidently
for A: http://docs.oracle.com/database/121/BRADV/osadvsce.htm#BRADV90049
Table 31-4 Recovering After the Loss of an Online Redo Log Group
If the Group Is…
Current
And You Can…
Attempt to clear the log; if impossible, then you must either use Flashback Database or restore a backup and perform incomplete recovery up to the most recent available redo log.
a & c
A C
D- this point does not describe the problem
What we should restore (whole database, some datafiles ??) and why.
This point ONLY inform that after database backup – controlfile backup was taken (which is
good practise imho).
question is written wrong in number D in the exam question is
D) The control file backup is older than the database backup.
Answer should be
C, D
M. Amin
[email protected]
AC