Exam 1z0-063 topic 1 question 121 discussion

Actual exam question from Oracle's 1z0-063

Question #: 121
Topic #: 1

RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. Examine the command to create a duplicate database:
RMAN> DUPLICATE TARGET DATABASE TO dup1

FROM ACTIVE DATABASE -

NOFILENAMECHECK -

PASSWORD FILE -
SPFILE;
Which two statements are true about the execution of the duplicate command?

A. All archive redo log files are automatically copied to the duplicate database.
B. The duplicate database has the same directory structure as the source database.
C. The duplicate database is created by using the backups created during the execution of
D. The duplicate command.
E. The password file and SPFILE for the duplicate database dup1 are created in their respective default locations.
F. The duplicate database is created without using RMAN backups and prod: is allowed to remain open during duplication.

Show Suggested Answer

Suggested Answer: AF 🗳️

by Sherry at Aug. 31, 2019, 9:34 a.m.

Comments

Submit Cancel

HakuPudding

3 years, 6 months ago

After research, I think the answer is A, F. This question is asking about Active Database Duplication with RMAN, and according to the reference, what Simon22 is saying is right. Also in my opinion, option B is quite confusing. NOFILENAMECHECK does duplicate the filenames, but structure? I don't think so. REF: https://oracle-base.com/articles/11g/duplicate-database-using-rman-11gr2#active_database_duplication

upvoted 1 times

HakuPudding

3 years, 6 months ago

After studying more, B, F. Sorry for the confusion T_T

upvoted 3 times

...

Hacova

3 years, 7 months ago

E is not correct because you can use pfile intead of spfile. BF must be correct.

upvoted 2 times

...

charan94

3 years, 8 months ago

Answer is BF

upvoted 2 times

...

Simon22

4 years ago

A: f this is an active duplicate, all necessary logs should be shipped automatically from the target to the auxiliary instance. F: Oracle 11g introduced the ability to create duplicate databases directly without the need for a backup. This is known as active database duplication.

upvoted 2 times

...

ErikJanssen

4 years, 2 months ago

I think answer A,B,C/D,. F is not correct because backup(sets) are being automatically generated during execution of the duplicate command. Doc: https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV89931.

upvoted 1 times

nabilou

4 years, 1 month ago

About Active Database Duplication with RMAN In active database duplication, RMAN connects as TARGET to the source database instance and as AUXILIARY to the auxiliary instance. RMAN then manages the copying of the database to the auxiliary instance over the network. No backups of the source database are required.

upvoted 1 times

...