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.
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)- A88% (38)
- B2% (1)
- C7% (3)
- D2% (1)
Why each option
The RMAN multiplexing level in this backup is 4 because FILESPERSET is the binding constraint, being lower than MAXOPENFILES.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.