Which command terminates with an error if the backup is not complete at the end of th 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 th 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 th specified duration?

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

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

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

D.
RMAN> BACKUP AS COPY DURATION 2:00PARTIAL 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 DURATION 4:00 PARTIAL TABLESPACE user FILESPERSET1;

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 the least recently backed up files are backed up first. Thus, if you retry a job that was interrupted when the available duration expired, each successive attempt covers more of the files needing backup.

REF: Oracle(r) Backup and Recovery Advanced User’s Guide, 2-41



Leave a Reply 1

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


mr_tienvu

mr_tienvu

I choose