nerdexam
Oracle

1Z0-067 · Question #52

While performing database backup to tape via the media manager interface, you notice that tape streaming is not happening because RMAN is not sending data blocks fast enough to the tape drive. Which…

The correct answer is B. Configure the channel to increase maxopenfiles. E. Configure the channel to adjust the tape buffer size by using the 3LKSIZE option. Allocation of Tape Buffers If you back up to or restore from an SBT device, then by default the database allocates four buffers for each channel for the tape writers. The size of the tape I/O buffers is platform- dependent. You can change this value with the PARMS and BLKSIZE…

New Features for Availability

Question

While performing database backup to tape via the media manager interface, you notice that tape streaming is not happening because RMAN is not sending data blocks fast enough to the tape drive. Which two actions would you take for tape streaming to happen during the backup?

Options

  • AConfigure backup optimization.
  • BConfigure the channel to increase maxopenfiles.
  • CConfigure a backup policy by using incremental backups.
  • DConfigure the channel to increase capacity with the rate parameter.
  • EConfigure the channel to adjust the tape buffer size by using the 3LKSIZE option.
  • FConfigure large_pool, if not done already. Alternatively, you can increase the size of
  • GLARGE_POOL.

How the community answered

(16 responses)
  • A
    6% (1)
  • B
    75% (12)
  • F
    6% (1)
  • G
    13% (2)

Explanation

Allocation of Tape Buffers If you back up to or restore from an SBT device, then by default the database allocates four buffers for each channel for the tape writers. The size of the tape I/O buffers is platform- dependent. You can change this value with the PARMS and BLKSIZE parameters of the ALLOCATE CHANNEL or CONFIGURE CHANNEL command. You can improve backup performance by adjusting the level of multiplexing, which is number of input files simultaneously read and then written into the same RMAN backup piece. The level of multiplexing is the minimum of the MAXOPENFILES setting on the channel and the number of input files placed in each backup set. The following table makes recommendations for adjusting the level of multiplexing.

Topics

#RMAN tape backup#tape streaming#channel configuration#BLKSIZE option

Community Discussion

No community discussion yet for this question.

Full 1Z0-067 Practice