You execute the command to recover your database:
RMAN> RUN
(
SET UNTIL TIME ‘2015-02-28:16:45:00’;
RESTORE DATABASE;
RECOVER DATABASE;
)
Which statement is true?
A.
It restores all data files from the specified time, and then applies the redo logs.
B.
It restores all data files, redo log files, and control files, and then applies the redo logs up to the specified time.
C.
It restores all data files and control files from the most recent backup taken before the “until time”, and then recovers up to the “until time” using any restored archive logs that are needed to complete the task.
D.
It restores the control file and all data files from the most recent backup, and then applies the redo logs up to the “until time”.
C
“A” is the correct, because the command “restore database” do not restore control file.
C is correct
A is correct,we can run restore command only after restoration of control file.
Thank you for your suggestion!!! I think you are right!!!!
SET UNTIL RESTORE POINT can only be used when the database is mounted, because the defined restore points are recorded in the control file. For example, you cannot use SET UNTIL RESTORE POINT to specify the target point in time for a RESTORE CONTROLFILE operation.
Correct answer is A
C