Identify three scenarios in which RMAN will use backup sets to perform active database duplication.

Identify three scenarios in which RMAN will use backup sets to perform active database
duplication.

A.
when the duplicate … from active database command contains the section size clause

B.
when you perform active database duplication on a database with flashback disabled

C.
when you specify set encryption before the duplicate … from active database command

D.
when the number of auxiliary channels allocated is equal to or greater than the number of
target channels

E.
when you perform active database duplication on a database that has readonlytablespaces

Explanation:
Reference:
http://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV298

Show Hint

← Previous question

Next question →

Siegfried

A,C,D
Starting with Oracle Database 12c Release 1 (12.1), RMAN can use backup sets to transfer the source database files that need to be duplicated. The backup sets are transferred over the network to the auxiliary database. Backup sets can be encrypted for additional security. Specify the encryption algorithm by using the SET ENCRYPTION ALGORITHM command before the DUPLICATE command.
RMAN uses backup sets to perform active database duplication when the connection to the target database is established using a net service name and any one of the following conditions is satisfied:
The DUPLICATE … FROM ACTIVE DATABASE command contains either the USING BACKUPSET, USING COMPRESSED BACKUPSET, or SECTION SIZE clause.
The number of auxiliary channels allocated is equal to or greater than the number of target channels allocated.

Tri

Thanks Siegfried!

Tri

D.for sure
If you omit the USING BACKUPSET clause from the DUPLICATE command and the number of allocated auxiliary channels is greater than or equal to the number of target channels, then RMAN still uses active database duplication with backup sets.
https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV431

A. for sure

Use the SECTION SIZE clause in the DUPLICATE command to create multisection backup sets that can be used for active database duplication. The following command creates multisection backup sets, with the size of each backup piece being 400MB. Assume that the connection to the target database and auxiliary instance has been made using net service names.

DUPLICATE TARGET DATABASE TO dup_db
FROM ACTIVE DATABASE
PASSWORD FILE
SECTION SIZE 400M;
https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV431

C. correct too (when set encrypted duplicate will use backupsets)

For active database duplication, decide if you want to encrypt or compress the backup sets that are used to transfer files from the source database to the duplicate database. Additionally, decide if you want to create backup sets on the source database in parallel by using multisection backups.
See “Specifying Encryption for Active Database Duplication”, “Compressing Backup Sets Used to Perform Active Database Duplication”, and “Creating Backup Sets in Parallel During Active Database Duplication”.