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

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