ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-063 All Questions

View all questions & answers for the 1z0-063 exam
Go to Exam

Exam 1z0-063 topic 1 question 121 discussion

Actual exam question from Oracle's 1z0-063
Question #: 121
Topic #: 1
[All 1z0-063 Questions]

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 Hide Answer
Suggested Answer: AF 🗳️
by Sherry at Aug. 31, 2019, 9:34 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
HakuPudding
3 years, 5 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, 5 months ago
After studying more, B, F. Sorry for the confusion T_T
upvoted 3 times
...
...
Hacova
3 years, 6 months ago
E is not correct because you can use pfile intead of spfile. BF must be correct.
upvoted 2 times
...
charan94
3 years, 6 months ago
Answer is BF
upvoted 2 times
...
Simon22
3 years, 11 months 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 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
3 years, 11 months 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
...
...
sergezaza83
4 years, 5 months ago
BF is correct
upvoted 2 times
...
Sugar
4 years, 10 months ago
my answer here is B E
upvoted 1 times
...
NorthKorean
5 years ago
B E in my opinion
upvoted 1 times
...
sherifelia
5 years, 3 months ago
Answer BF
upvoted 2 times
...
gracee
5 years, 3 months ago
Correct Ans: BF
upvoted 2 times
...
Sherry
5 years, 8 months ago
The correct answer is BE, NOFILENAMECHECK has the same dir
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago