Oracle Exam 1Z0-076 Topic 12 Question 25 Discussion

Actual exam question for Oracle's 1Z0-076 exam

Question #: 25
Topic #: 12

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

AConfigure Oracle Net connectivity on the primary host to the standby database instance.

BEstablish user equivalence for the database software owner between the primary host and standby host.

Cstartup nomount the standby database instance.

DSet the DB_UNIQUE_NAME parameter on the primary database to a different value than that of the DB_NAME name parameter.

EPut the primary database into archivelog mode.

Show Suggested Answer

Suggested Answer: A, B, C

Creating a physical standby database using RMAN active database duplication requires certain prerequisites to ensure a successful and seamless operation:

Configure Oracle Net connectivity on the primary host to the standby database instance (A): Proper Oracle Net connectivity between the primary and standby servers is essential for communication and data transfer during the duplication process. Oracle Net services provide the network foundation for Oracle Database, Oracle Net Listener, and Oracle applications.

Establish user equivalence for the database software owner between the primary host and standby host (B): User equivalence ensures that the user who owns the Oracle Database software on the primary server has the same privileges on the standby server. This is crucial for RMAN to perform operations on both servers without encountering permission issues.

Startup nomount the standby database instance (C): The standby database instance needs to be started in the NOMOUNT stage before the duplication can begin. This prepares the environment for creating the control file and restoring the database without mounting it, which is a necessary step in the RMAN duplication process. Reference:

Oracle Database Backup and Recovery User's Guide

Oracle Data Guard Concepts and Administration

by Chandra at Nov 14, 2024, 10:09 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-076 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Alyce

4 months ago

I'm pretty sure the answer is B, D, and E. Configuring the network and the database parameters is key for successful duplication.

upvoted 0 times

...

Ivan

4 months ago

Don't forget to startup nomount the standby database instance as well.

upvoted 0 times

...

4 months ago

Definitely B, D, and E. The standby database needs to be properly configured to match the primary, and archivelog mode is essential for the redo log transfer.

upvoted 0 times

Roxane

3 months ago

E) Put the primary database into archivelog mode.

upvoted 0 times

...

Allene

4 months ago

D) Set the DB_UNIQUE_NAME parameter on the primary database to a different value than that of the DB_NAME name parameter.

upvoted 0 times

...

Kattie

4 months ago

B) Establish user equivalence for the database software owner between the primary host and standby host.

upvoted 0 times

...

Deandrea

5 months ago

I think the first step is to configure Oracle Net connectivity.

upvoted 0 times

...

4 months ago

Agreed, establishing user equivalence is important for the duplication process.

upvoted 0 times

...