1Z0-063 · Question #202
1Z0-063 Question #202: Real Exam Question with Answer & Explanation
The correct answer is B. RMAN must be connected to the target database instance and the auxiliary instance.. 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
Question
Options
- AThe target database must be in MOUNT state.
- BRMAN must be connected to the target database instance and the auxiliary instance.
- CA most recent backup set of the PROD database must exist.
- DFlashback 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 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. 2017), page 26-7
Community Discussion
No community discussion yet for this question.