nerdexam
Oracle

1Z0-062 · Question #173

View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation: RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8; BACKUP DATABASE…

The correct answer is A. 4. The RMAN multiplexing level in this backup is 4 because FILESPERSET is the binding constraint, being lower than MAXOPENFILES.

Performing Backup and Recovery

Question

View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation:

RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8; BACKUP DATABASE FILESPERSET 4; } What is the multiplexing level in the preceding backup process?

Options

  • A4
  • B8
  • C7
  • D0

How the community answered

(43 responses)
  • A
    88% (38)
  • B
    2% (1)
  • C
    7% (3)
  • D
    2% (1)

Why each option

The RMAN multiplexing level in this backup is 4 because FILESPERSET is the binding constraint, being lower than MAXOPENFILES.

A4Correct

Multiplexing level is the number of input datafiles written simultaneously into a single backup piece, determined by the lesser of FILESPERSET and MAXOPENFILES. Here FILESPERSET is 4 and MAXOPENFILES is 8, so the effective multiplexing level is min(4, 8) = 4.

B8

MAXOPENFILES 8 sets an upper ceiling on simultaneously open input files per channel but does not define the multiplexing level when FILESPERSET 4 is the more restrictive constraint.

C7

The value 7 is not derivable from any parameter in this command; the multiplexing level is strictly the minimum of FILESPERSET and MAXOPENFILES, yielding 4.

D0

A multiplexing level of 0 would indicate no multiplexing, which contradicts the explicit FILESPERSET 4 parameter that directs RMAN to read 4 files concurrently into each backup set.

Concept tested: RMAN backup multiplexing with FILESPERSET and MAXOPENFILES

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

Topics

#RMAN backup#Multiplexing#FILESPERSET#Channels

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice