What are the prerequisites for performing the active database duplication?

You are managing an Oracle Database 11g instance. You want to create a duplicate
database for testing purpose.
What are the prerequisites for performing the active database duplication? (Choose all that
apply.)

You are managing an Oracle Database 11g instance. You want to create a duplicate
database for testing purpose.
What are the prerequisites for performing the active database duplication? (Choose all that
apply.)

A.
The source database backup must be copied over the net for test database.

B.
The source database must be run in ARCHIVELOG mode if the database is open.

C.
The source database must be shut down cleanly if the database is in mounted state.

D.
A net service name should be set up and a listener configured with the target as well as
the source database.

Explanation:
To ensure that the source database is in the proper state:
1. If the source database instance is not mounted or open, then mount or open it.
2. If you are performing active database duplication, then ensure that the following additional
requirements are met:
If the source database is open, then archiving must be enabled.
If the source database is not open, then the database does not require instance recovery.
(Tips: does not require instance recovery, means you cannot shutdown the source database
with abort option, you need to shutdown it cleanly.)
Starting RMAN and Connecting to Databases:
In this task, you must start the RMAN client and connect to the database instances required
by the duplication technique chosen in “Step 1: Choosing a Duplication Technique”. The
RMAN client can be located on any host so long as it can connect to the necessary
databases over the network.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Eamon

Eamon

RMAN should be connected to both the source (TARGET) and target (DUPLICATE) instances as SYSDBA. (Yes I know this si a little confusing)

Hence a net service name should be set up and a listener configured with the target as well as the source database.