Which command terminates with an error if the backup is not complete at the end of the specified duration?

You want to perform the database backup when user activity on your system is low, such as between 12:00 a.m. and 2:00 a.m.
Which command terminates with an error if the backup is not complete at the end of the specified duration?

You want to perform the database backup when user activity on your system is low, such as between 12:00 a.m. and 2:00 a.m.
Which command terminates with an error if the backup is not complete at the end of the specified duration?

A.
RMAN> BACKUP DURATION 2:00 MINIMIZE LOAD DATABASE ;

B.
RMAN> BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASE ;

C.
RMAN> BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE ;

D.
RMAN> BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD 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 DURACTION 4:00 PARTIAL TABLESPACE user FILE ESPERSET1;

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 1

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


seenagape

seenagape

Correct answer is