Oracle Exam 1Z0-063 Topic 7 Question 23 Discussion

Actual exam question for Oracle's 1Z0-063 exam

Question #: 23
Topic #: 7

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?

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.

Show Suggested Answer

Suggested Answer: B

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

by Jennifer at May 05, 2022, 07:22 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-063 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!