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 using
RMAN connected to a recovery catalog.
You create an auxiliary instance and want to execute the command:
What is a prerequisite for the successful execution of this command?
A.
The target database must be in MOUNT state.
B.
RMAN must be connected to the target database instance and the auxiliary instance.
C.
A most recent backup set of the PROD database must exist.
D.
Flashback must be enabled for the PROD database.
Explanation:
Assume that the source database prod is on host1 and stores its data files in a non-ASM file system. The control files for prod are located in /oracle/oradata/prod/.
You want to duplicate the source database to database dupdb on remote host host2.
You want to store the duplicate database files in ASM disk group +DISK1.
After connecting RMAN to the target, duplicate, and recovery catalog databases, run the following RMAN script to duplicate the database.
DUPLICATE TARGET DATABASE TO dupdb
FROM ACTIVE DATABASE
SPFILE
PARAMETER_VALUE_CONVERT ‘/oracle/oradata/prod/’, ‘+DISK1’
SET DB_CREATE_FILE_DEST +DISK1;
When the DUPLICATE command completes, the duplicate database is created, with data files, online redo log files, and control files in ASM disk group +DISK1.
References: Oracle Database, Backup and Recovery User’s Guide, 12 Release 2 (January 2017), page 26-7
B