How many database instances are used during a database-duplication process?

A.
One

B.
Two

C.
Three

D.
Four

E.
Five

Show Hint

← Previous question

Next question →

Leave a Reply 6

ola

I think the correct answer is B. You use auxiliary database instance and source database instance

Reply

noe

Tricky question, it depends on the method used:
$ ORACLE_SID=DB11G; export ORACLE_SID

# No target or catalog. Metadata comes from backups.
$ rman AUXILIARY /

# Target, but no catalog. Metadata comes from target database controlfile.
$ rman TARGET sys/password@DB11G-SOURCE AUXILIARY /

# Catalog, but no target. Metadata comes from the RMAN catalog.
$ rman CATALOG rman/password@rman-catalog AUXILIARY /

# Target and catalog. Metadata can come from the target controlfile or the catalog.
$ rman TARGET sys/password@DB11G-SOURCE CATALOG rman/password@rman-catalog AUXILIARY /
https://oracle-base.com/articles/11g/duplicate-database-using-rman-11gr2#active_database_duplication

Reply

Eamon

@noa, you get my vote.
The answer could be 1 or 2 or 3 depending on the technique used and what you have available.

Reply

Eamon

An RC is not used for the actual duplication of a database because of issues with the DBID being the same on the source and the target etc. However duplicating a database does change the DBID so the duplicated database can be connected to the RC afterwards.