nerdexam
Oracle

1Z0-060 · Question #112

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 backups split datafiles into parallel sections using the SECTION SIZE clause, but this feature applies only to datafile-based backup sets and image copies - not archive logs, temporary tablespaces, or SPFILE.

New Features for Availability

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

(28 responses)
  • A
    82% (23)
  • C
    4% (1)
  • D
    4% (1)
  • F
    11% (3)

Why each option

RMAN multi-section backups split datafiles into parallel sections using the SECTION SIZE clause, but this feature applies only to datafile-based backup sets and image copies - not archive logs, temporary tablespaces, or SPFILE.

ABACKUP TABLESPACE SYSTEM SECTION SIZE 100M;Correct

The SYSTEM tablespace contains regular datafiles, so specifying SECTION SIZE 100M causes RMAN to divide each datafile into 100MB sections backed up in parallel across channels, producing a genuine multi-section backup set.

BBACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;Correct

Image copy backups (AS COPY) in Oracle 12c fully support the SECTION SIZE parameter, allowing RMAN to produce multi-section image copies of the SYSTEM tablespace datafiles backed up in parallel.

CBACKUP ARCHIVELOG ALL SECTION SIZE 25M;

Archive log files are discrete, immutable log files that RMAN backs up as complete units; the SECTION SIZE clause does not apply to archive log backups and the command does not produce a multi-section backup.

DBACKUP TABLESPACE "TEMP" SECTION SIZE 10M;

Temporary tablespace datafiles hold only transient sort and hash data that is never recovered, so RMAN explicitly disallows backing up temporary tablespaces and the command returns an error rather than producing any backup.

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

The UNDO tablespace consists of standard datafiles that support multi-section backup; the INCLUDE CURRENT CONTROLFILE clause appends the controlfile as a separate backup piece but does not disable multi-section behavior for the undo datafiles, so sections are still produced.

FBACKUP SPFILE SECTION SIZE 1M;

The SPFILE is a small single binary file that RMAN backs up as one indivisible piece; the SECTION SIZE parameter is not honored for SPFILE backups and the result is a single-section backup regardless of the size specified.

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

An incremental level 0 backup is a full datafile image that supports SECTION SIZE just like a non-incremental backup, so BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M correctly generates multiple sections per datafile.

Concept tested: RMAN multi-section backup eligibility and SECTION SIZE clause

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/making-database-backups.html

Topics

#RMAN multi-section backup#SECTION SIZE#backup as copy#incremental backup

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice