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.