Which command meets these two criteria?

Which command meets these two criteria?
1 Runs the backup at full speed
2 Either finishes the task in the allotted time, or terminates Recovery Manager (RMAN) with an error if it fails to finish the task in the allotted time.

Which command meets these two criteria?
1/ Runs the backup at full speed
2/ Either finishes the task in the allotted time, or terminates Recovery Manager (RMAN) with an error if it fails to finish the task in the allotted time.

A.
RMAN> BACKUP AS COPY DURATION 3:00 MINIMIZE LOAD DATABASE;

B.
RMAN> BACKUP AS COPY DURATION 3:00 MINIMIZE TIME DATABASE;

C.
RMAN> BACKUP AS COPY DURATION 3:00 PARTIAL MINIMIZE LOAD DATABASE;

D.
RMAN> BACKUP AS COPY DURATION 3:00 PARTIAL MINIMIZE TIME DATABASE;

Explanation:
By default, when a BACKUP… DURATION command runs out of time before the backup completes, RMAN reports an error. (The effect of this is that if the command is running in a RUN block, the RUN block terminates.) You can control this behavior by adding the PARTIAL option to the BACKUP… DURATION command, as in this example:

BACKUP DURATION 4:00 PARTIAL TABLESPACE users FILESPERSET 1;

When PARTIAL is used, no error is reported when a backup command is interrupted due to the end of the backup window. Instead, a message showing which files could not be backed will be displayed. If the BACKUP command is part of a RUN block, then the remaining commands in the RUN block will continue to execute. When using DURATION you can run the backup with the maximum possible performance, or run as slowly as possible while still finishing within the allotted time, to minimize the performance impact of backup tasks. To extend the backup to use the full time available, use the MINIMIZE LOAD option,

REF: Oracle(r) 10g Backup and Recovery Guide, 2-40 and 2-41



Leave a Reply 0

Your email address will not be published. Required fields are marked *