You want to create a duplicate database DUP_DB from your production database PROD on the same host. The PROD database uses Automatic Storage Management (ASM) for storage. Regular backups are taken…

Question

Options

• ARMAN must be connected to the target database instance and the auxiliary instance.
• BA most recent backup set of the PROD database must exist.
• CFlashback must be enabled for the PROD database.
• DThe target database must be in MOUNT state.

• A
  91% (30)
• B
  3% (1)
• D
  6% (2)

Explanation

Option A is correct because DUPLICATE ... FROM ACTIVE DATABASE works by streaming datafiles directly from the target instance to the auxiliary instance over an Oracle Net connection - RMAN must simultaneously hold a channel to the target (PROD) to read data and a channel to the auxiliary (DUP_DB) to write it, making both connections a hard requirement.

B is wrong because FROM ACTIVE DATABASE bypasses backup sets entirely; it copies live datafiles directly over the network, so no prior RMAN backup needs to exist.

C is wrong because Flashback Database is not a prerequisite for active database duplication; it's an optional feature for point-in-time recovery and has no role in this operation.

D is wrong because the target must be OPEN (not MOUNT) for active duplication - RMAN needs to read live datafiles, which requires the database to be accessible and running.

Memory tip: Think of FROM ACTIVE DATABASE as a live "clone over the wire" - since data flows directly between two running instances, both ends of the wire must be connected (target + auxiliary), and the source must be on, not just mounted.

No community discussion yet for this question.