nerdexam
Oracle

1Z0-062 · Question #105

The persistent configuration settings for RMAN have default for all parameters. Identify four RMAN commands that produce a multi-section backup.

The correct answer is A. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M; B. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M; E. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M; G. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;. RMAN multi-section backup splits large datafiles into independently processable sections using the SECTION SIZE clause, improving backup parallelism and manageability. The feature is supported for datafile backup sets and image copies but not for archive logs or the SPFILE.

Performing Backup and Recovery

Question

The persistent configuration settings for RMAN have default for all parameters. Identify four RMAN commands that produce a multi-section backup.

Options

  • ABACKUP TABLESPACE SYSTEM SECTION SIZE 100M;
  • BBACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;
  • CBACKUP ARCHIVELOG ALL SECTION SIZE 25M;
  • DBACKUP TABLESPACE "TEMP" SECTION SIZE 10M;
  • EBACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;
  • FBACKUP SPFILE SECTION SIZE 1M;
  • GBACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

How the community answered

(42 responses)
  • A
    93% (39)
  • C
    2% (1)
  • F
    5% (2)

Why each option

RMAN multi-section backup splits large datafiles into independently processable sections using the SECTION SIZE clause, improving backup parallelism and manageability. The feature is supported for datafile backup sets and image copies but not for archive logs or the SPFILE.

ABACKUP TABLESPACE SYSTEM SECTION SIZE 100M;Correct

BACKUP TABLESPACE SYSTEM SECTION SIZE 100M divides the SYSTEM tablespace datafile(s) into 100MB sections, each backed up as a separate piece within the backup set. This is the standard syntax for producing a multi-section backup of a regular tablespace.

BBACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;Correct

BACKUP AS COPY with SECTION SIZE creates multi-section image copies by splitting the copy operation into independently processed 100MB sections. Oracle supports the SECTION SIZE clause for both backup sets and image copies of datafiles.

CBACKUP ARCHIVELOG ALL SECTION SIZE 25M;

RMAN does not support multi-section backup for archive log files - the SECTION SIZE clause is valid only for datafile backup operations, and archive logs are always backed up as complete, unsplit units.

DBACKUP TABLESPACE "TEMP" SECTION SIZE 10M;

RMAN cannot back up temporary tablespaces because they contain no persistent data - temporary segments are recreated at instance startup and are explicitly excluded from all RMAN backup and recovery operations.

EBACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;Correct

BACKUP TABLESPACE UNDO INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M creates a valid multi-section backup because the SECTION SIZE clause applies to the undo tablespace datafile sections. The INCLUDE CURRENT CONTROLFILE option appends the control file to the same backup job without affecting the section-based processing of the datafiles.

FBACKUP SPFILE SECTION SIZE 1M;

The SPFILE is a small server parameter file for which the SECTION SIZE clause is not supported - multi-section backup applies exclusively to datafiles and does not extend to SPFILE backups.

GBACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;Correct

BACKUP INCREMENTAL LEVEL 0 with SECTION SIZE is a supported multi-section incremental backup - Oracle allows multi-section processing for both full and incremental level 0 datafile backups, enabling the same parallelism benefits for incremental backup strategies.

Concept tested: RMAN multi-section backup SECTION SIZE supported object types

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/BACKUP.html

Topics

#RMAN backup#Multi-section backup#SECTION SIZE clause#Tablespace backup

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice