Multiple choice technology databases

Which scenario below truly achieves “Parallel Backups” using RMAN in Oracle 11g?

  1. Scenario 1: Backup 2 datafiles each of 20 GB datafile using 4 RMAN channels. Use the default setting for all RMAN channels

  2. Scenario 2: Backup 2 datafiles each of 20 GB datafile using 4 RMAN channels. Each channel backs up 2 datafiles at the same time with “parallel=2”

  3. Scenario 3: Backup 2 datafiles each of 20 GB size using 4 RMAN channels. Each channel backs up data with “section size=5GB"

  4. Scenario 4: Backup 2 datafiles each of 20 GB datafile using 4 RMAN channels. Each channel backs up 2 datafiles at the same time with “parallel backups=2”
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

True parallel backup in RMAN occurs when multiple channels work on different sections of the same datafile simultaneously. Section size parameter divides datafiles into chunks that channels can backup in parallel. Options with parallel=2 or parallel backups=2 refer to channel parallelism, not section-based backup parallelism.

Keep practicing — related questions