1z0-063 Free Dumps Study Materials
Question 1: 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. Flashback must be enabled for the PROD database.
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. The target database must be in MOUNT state.
Correct Answer: B
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
