What is the impact of the following backup if it exceeds the duration allowance?
backup as compressed backupset duration 2:00 partial minimize load database ;
A.
The entire backup will fail. It will not be usable for recovery.
B.
The entire backup will fail, but any datafile successfully backed up will be usable for
recovery.
C.
If this backup fails, subsequent backups will prioritize datafiles not backed up.
D.
If this backup fails, an error will be raised and any other commands will not be executed.
E.
If this backup fails, no error will be raised and any other commands will be executed.
Correct answer: B,C,E
http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta007.htm#RCMRF107 look at duration :
“Without the PARTIAL option, the backup command is considered to have failed if it does not complete in the specified duration, and RMAN reports an error. If the backup command is part of a RUN block, then subsequent commands in the RUN block do not execute.”
The question ask only one response and only”B” is the correct answer
Answer is C, explaination below.
Nanyick says “Without the PARTIAL option …”
wait a moment, “PARTIAL” in fact IS used as an option in the question. I suggest reading the question.
Answer B cannot be correct as it says that the backup “will fail” which not necessarily true.
Also it says that “but any datafile successfully backed up will be usable for recovery”.
This is a contradiction because if the backup fails then the backup set is not complete, hence (according to the notes below) these incomplete backup sets are discarded hence the datafiles in them are not usable.
I suggest reading
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmbckad.htm#BRADV301
pay attention to these paragraphs
1
By default, if the backup is not complete within the DURATION time, then RMAN interrupts the backup and reports an error. If the BACKUP command is in a RUN command, then the RUN command terminates. Any completed backup sets are retained and can be used in restore operations, even if the entire backup is not complete. Thus, if you retry a job that was interrupted when the available duration expired, each successive attempt covers more of the files needing backup. Any incomplete backup sets are discarded.
2
When you specify PARTIAL, RMAN does not report an error when a backup is interrupted because of the end of the backup window. Instead, RMAN displays a message showing which files are not backed up. If the BACKUP command is part of a RUN block, then the remaining commands in the RUN block continue to execute.
Also note …
Answer E could be correct if he is talking about commands in a RUN block.
If I were running the backup I would pay attention to the text (also at the link I mentioned above) …
If you specify FILESPERSET 1, then RMAN puts each file into its own backup set. When a backup is interrupted at the end of the backup window, only the backup of the file currently being backed up is lost. All backup sets completed during the window are saved, minimizing the lost work caused by the end of the backup window.
Please ignore my comment on …
Answer B cannot be correct as it says that the backup “will fail” which not necessarily true.
however the 2nd reason I give is still valid.
To recap on this question.
I suggest reading
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmbckad.htm#BRADV301
When you specify PARTIAL, RMAN does not report an error (the command completes correctly even though the full backup has not completed) when a backup is interrupted because of the end of the backup window. Instead, RMAN displays a message showing which files are not backed up. If the BACKUP command is part of a RUN block, then the remaining commands in the RUN block continue to execute.
So Answer E could be correct if he is talking about commands in a RUN block.
A wrong
B could be correct, but this depends on whether he is refering to the BACKUP itself or its command.
C could be correct, but again this depends on whether he is refering to the BACKUP itself or its command.
D wrong
E correct
A and B are wrong becauce the ENTIRE backup fails. As we have PARTIAL as keyword, this is not true.
D is wrong as well, about C I am not sure.
E is the correct answer.
Correct answer is B C E