1Z0-083 Question #257: Real Exam Question with Answer & Explanation

Question

Options

• Awhen the duplicate ... from active database command contains the section size clause
• Bwhen you perform active database duplication on a database with flashback disabled
• Cwhen you specify set encryption before the duplicate ... from active database command
• Dwhen the number of auxiliary channels allocated is equal to or greater than the number of
• Ewhen you perform active database duplication on a database that has readonly tablespaces

Explanation

RMAN defaults to image copies for active database duplication, but switches to backup sets under three specific technical conditions. Option A is correct because the SECTION SIZE clause enables multisection backups, a feature exclusive to backup sets. Option C is correct because RMAN encryption is only supported with backup sets, not image copies, so setting encryption forces the backup set method. Option D is correct because when auxiliary channels are equal to or outnumber target channels, RMAN leverages backup sets to better exploit that parallelism - the auxiliary instance pulls data rather than the target pushing it.

Option B is wrong because flashback logging status on the source database has no bearing on the duplication transfer method. Option E is wrong because read-only tablespaces do not trigger backup set usage - RMAN handles them the same way regardless of the copy method chosen.

Memory tip: Think "SEA" - Section size, Encryption, Auxiliary channels ≥ target channels. These are the three technical constraints that force RMAN away from the default image-copy method into backup sets.

No community discussion yet for this question.