Oracle Database 12c: RAC and Grid Infrastructure Administration — Question 38

Which three steps are prerequisites for the creation of a physical standby database on a separate server using the RMAN active database duplication method?

Answer options

• A. Set the DB_UNIQUE_NAME parameter on the primary database to a different value than that of the DB_NAME parameter.
• B. Put the primary database into archivelog mode.
• C. Startup nomount the standby database instance.
• D. Configure Oracle Net connectivity on the primary host to the standby database instance.
• E. Establish user equivalence for the database software owner between the primary host and standby host.

Correct answer: C, D, E

Explanation

The correct answer includes options C, D, and E, which are essential steps for establishing a physical standby database. Starting the standby instance in nomount mode is necessary for the setup, configuring Oracle Net ensures connectivity between the primary and standby databases, and establishing user equivalence allows for proper permissions. Options A and B, while important for other configurations, are not prerequisites for this specific process.