Oracle Database 12c: Installation and Administration — Question 40

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

Answer options

• A. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;
• B. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;
• C. BACKUP ARCHIVELOG ALL SECTION SIZE 25M;
• D. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;
• E. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;
• F. BACKUP SPFILE SECTION SIZE 1M;
• G. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

Correct answer: A, B, E, G

Explanation

The commands A, B, E, and G are designed to create multi-section backups by specifying the SECTION SIZE parameter, which allows for the partitioning of the backup into manageable segments. Options C and F do not produce multi-section backups as they either do not specify a TABLESPACE or deal with different types of backups that do not support this feature. Option D is also not applicable for multi-section backups as it uses a different TABLESPACE with a smaller section size.