Which two statements are true about the execution of the duplicate command?

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 Hint

← Previous question

Next question →

Leave a Reply 24

Siegfried

E,F

Zani

Hi Siegfried, what about the B?
think in NOFILENAMECHECK.

For me, this question has 3 answers.

Bye

Anthony

Zani,

I not agree with B, because in duplicate, we have different struture, we can use DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT or set new name.

Steve

Horrible question. Is it supposed to be which two statements are false?

http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmdupdb.htm

ABEF:

“Example 23-3 Duplicating to a Host with the Same Directory Structure (Active)

DUPLICATE TARGET DATABASE
TO dupdb
FROM ACTIVE DATABASE
SPFILE
NOFILENAMECHECK;

RMAN automatically copies the server parameter file to the destination host, starts the auxiliary instance with the server parameter file, copies all necessary database files and archived redo logs over the network to the destination host, and recovers the database. Finally, RMAN opens the database with the RESETLOGS option to create the online redo logs.”

Vonpire

Well…

Lets see
A – says all archived logs not necessary so we can presume its wrong.
B – like Anthony said in previous post we can use what he described so directory structure can be different. So we can assume it could also be not completely true…

C and D are same question and its obviously wrong.

So it all comes to E and F.

But I can be wrong also…

Vonpire

Thinking better B is true also in that specific rman command.

Steve

Good point on A, but I’m still confused.

I think E and F are likely the best answers. If the question really asks for 3, then add in B.

Vonpire

I think it’s B , (MERGE CD) and E

Oracle 12c new duplication from active database uses backupsets instead of image copies (11G) to perform active database duplication when the following conditions are met :

The number of AUXILIARY channels should be equal or greater than TARGET channels – TRUE

The DUPLICATION …FROM ACTIVE DATABASE should contain either USING BACKUPSET, USING COMPRESSED BACKUPSET or SECTION SIZE clause

http://allthingsoracle.com/oracle-database-12c-rman-new-features-part-2/

So A is not correct because only needed archives are transfered, not all and F is not correct because RMAN will use the backup automatically created when command is executed.

ACTIVE DUPLICATE DATABASE additions and improvements

The ACTIVE DUPLICATE DATABASE option in 11g clone the source database by coping the full image of the data files to the auxiliary instance location through the network. This procedure doesn’t not required any pre backup existence to clone the database.

“However, in Oracle 12c, when ACTIVE DUPLICATE DATABASE is initiated, instead of sending the full image copy of the data files, RMAN first takes the backup of data files into backupsets, and these backups are transmit to the auxiliary location and will be restored/recovered subsequently. This functionality will surely reduce the overall impact on the source instance and also help fastening the cloning procedure. You have the flexibility to use backup compression, encryption option with this feature.”

Vonpire

Just to correct firs paragraph

“Oracle 12c new duplication from active database uses backupsets instead of image copies (11G) to perform active database duplication when ONE OF the following conditions are met :

– The number of AUXILIARY channels should be equal or greater than TARGET channels – TRUE

– The DUPLICATION …FROM ACTIVE DATABASE should contain either USING BACKUPSET, USING COMPRESSED BACKUPSET or SECTION SIZE clause”

Vonpire

So B and (merge CD).

E is wrong.

Sorry for my typos.

Vonpire

Correct asnwer is C and E.

Tri

Thanks Vonpire!

Tri

B.Confirm.
Example 25-1 Duplicating to a Different Host with the Same Directory Structure (Active)
https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV435

D. also correct.

The PASSWORD FILE option specifies that RMAN copies the password file to the destination host.

RMAN automatically copies the server parameter file to the destination host, restarts the auxiliary instance with the server parameter file,

KRA

A,B and D are wrong

https://docs.oracle.com/database/121/BRADV/glossary.htm#CHDJIFJB

active database duplication is A duplicate database that is created over a network without restoring backups of the target database.

Factors That Determine Whether Backup Sets or Image Copies Are Used for Active Database Duplication

RMAN only uses image copies to perform active database duplication when no auxiliary channels are allocated or when the number of auxiliary channels allocated is less than the number of target channels.

RMAN uses backup sets to perform active database duplication when the connection to the target database is established using a net service name and any one of the following conditions is satisfied:

The DUPLICATE … FROM ACTIVE DATABASE command contains either the USING BACKUPSET, USING COMPRESSED BACKUPSET, or SECTION SIZE clause.

The number of auxiliary channels allocated is equal to or greater than the number of target channels allocated.

C is also wrong : No backup is created because USING BACKUPSET, USING COMPRESSED BACKUPSET or SECTION SIZE clause” is not used.

So for me answer is E and F

christ

Example 25-1 Duplicating to a Different Host with the Same Directory Structure (Active)

This example illustrates how to perform active duplication. RMAN uses the pull method (using backup sets) by default.DUPLICATE requires theNOFILENAMECHECK option because the source database files have the same names as the duplicate database files.

The PASSWORD FILE option specifies that RMAN copies the password file to the destination host.

RMAN automatically copies the server parameter file to the destination host, restarts the auxiliary instance with the server parameter file, copies all necessary database files and archived redo logs over the network to the destination host, and recovers the database. Finally, RMAN opens the database with theRESETLOGS option to create the online redo log.dupdb is theDB_NAME of the duplicate database

DUPLICATE TARGET DATABASE TO dupdb
FROM ACTIVE DATABASE
PASSWORD FILE
SPFILE
NOFILENAMECHECK;

RNW

Bad Question – there are 3 answers here B C E

https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV435

Example 25-1 Duplicating to a Different Host with the –>Same Directory Structurepull method (using backup sets) by defaultsource database files have the same names as the duplicate database filescopies all necessary database files and archived redo logs<– [NOT A] over the network to the destination host, and recovers the database. Finally, RMAN opens the database with the RESETLOGS option to create the online redo log. dupdb is the DB_NAME of the duplicate database

DUPLICATE TARGET DATABASE TO dupdb
FROM ACTIVE DATABASE
PASSWORD FILE
SPFILE
NOFILENAMECHECK;

RNW

If B is wrong – E cant be correct – as the SPFILE will be copied over – and any file convert parameters will be gone.

So I think I i had to answer 2 option – it’s B and E

Big-G

I prefer:

B
–> https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmdupdb.htm#i1006629
Example 23-3
“Duplicating to a Host with the Same Directory Structure (Active)
DUPLICATE TARGET DATABASE
TO dupdb
FROM ACTIVE DATABASE
SPFILE
NOFILENAMECHECK;
”
Also B für 12c:
–> https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#GUID-F32840E6-F8C5-43D6-9B65-A3DF71665B06
Example 25-1
“Duplicating to a Different Host with the Same Directory Structure (Active)
DUPLICATE TARGET DATABASE TO dupdb
FROM ACTIVE DATABASE
PASSWORD FILE
SPFILE
NOFILENAMECHECK;
”

And then F.
During DUPLUCATE FROM ACTTIVE DATABASE the source database is still mopen and accessible

Big-G

Addition:

Hm.. it also could be E – ….. 🙁
But sure it is B

DBA_Contributer

It’s B & F. When asked why, it’s as below,

https://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta020.htm

A (Incorrect): If it’s required then only it will create. In case consitent or Target(not auxiliary) database in mount stat, archivelogs not copied to Auxiliary.

B (Correct): In this example log_file_name_convert, db_file_name_convert, parameter_convert and control_file_name not specified, hence it will consider all locations as per Target database.

C and D (Incorrect): Since they do not stand as questions itsef.

E (Incorrect): Since PASSWORD FILE and SPFILE are specified, they will be copied from Target to Auxiliary database. They will not be created.

F (Correct): DUPLICATE database can be created by two methods by RMAN,
1) RMAN backup based.
2) Active Database based.
This is Active Database based, which does not use RMAN existing backups, but uses COPY command.

pokemongo

E
http://docs.oracle.com/cd/E49329_01/backup.121/b71298/rcmsynta020.htm#CHDIJJHJ
Password file →　Copied by default for standby databases; for nonstandby databases, copied only if PASSWORD FILE option is specified
SPFILE →　Copied by default
F（2-84）

pokemongo

2-84→　2-82

Harry

I agreed with DBA_Contributer
Answer is B & F

B (Correct): In this example log_file_name_convert, db_file_name_convert, parameter_convert and control_file_name not specified, hence it will consider all locations as per Target database.

amsunhasav