1Z0-076 practice question 5 of 25

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: Configure Oracle Net connectivity on the primary host to the standby database instance. Correct answer

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

C: startup nomount the standby database instance. Correct answer

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

E: Put the primary database into archivelog mode. Correct answer

Correct Answer:

A. Configure Oracle Net connectivity on the primary host to the standby database instance.; C. startup nomount the standby database instance.; E. Put the primary database into archivelog mode.

Explanation

For RMAN active duplication to a separate host, the primary database must already archive redo (ARCHIVELOG), the standby instance must be started NOMOUNT so that RMAN can create the control file, and Oracle Net connectivity between primary and standby must exist for RMAN’s network-based copy. No user-equivalence is required, and DBUNIQUENAME on the primary can remain the same as DBNAME.

Why Incorrect

B. RMAN active duplication uses Oracle Net, not OS-level file copying; no operating-system user equivalence is mandated.
D. Only the DBUNIQUENAMEs of the two databases must differ; the primary’s DBUNIQUENAME may equal its DBNAME.

References

1. Oracle Database Backup and Recovery User’s Guide 19c, §26.3.3 “Using RMAN to Duplicate from an Active Database” (p. 26-23).

2. Oracle Data Guard Concepts & Administration 19c, §3.1 “Configuring Standby Databases” (p. 3-4).

3. Oracle Net Services Administrator’s Guide 19c, §4 “Configuring Connectivity” (p. 4-1).

Keep practicing

Take the free 1Z0-076 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

Start the free practice test