1Z0-931-25 practice question 18 of 25

Data Guard is enabled for your Autonomous Database and the Lifecycle State field for the primary database indicates that it is Stopped. Which statement is true?

Full set: 149 questions
Answer options
A: Switchover is automatically initiated.
B: Standby database is terminated.
C: Standby database is also stopped. Correct answer
D: Failover is automatically initiated.
Correct Answer:
C. Standby database is also stopped.
Explanation

In an Oracle Autonomous Database environment with Autonomous Data Guard enabled, the primary and standby databases are managed as a synchronized pair. When a user performs a planned administrative action like stopping the primary database, the system automatically stops the associated standby database as well. This ensures that both databases in the Data Guard configuration maintain a consistent lifecycle state. This behavior is by design to prevent unintended role transitions and to manage the pair as a single logical unit for administrative purposes.

Why Incorrect

A. Switchover is automatically initiated. A switchover is a planned role reversal that requires both databases to be active. Stopping the primary is an administrative shutdown, not a trigger for a role change.
B. Standby database is terminated. Stopping a database is a temporary, reversible action. Terminating a database is a permanent, destructive action that deletes the database and its resources.
D. Failover is automatically initiated. A failover is an unplanned event triggered by the failure of the primary database. A user-initiated stop is a planned, controlled action and does not trigger a failover.

References

1. Oracle Cloud Infrastructure Documentation - Use Autonomous Data Guard:

In the section "Stop and Start an Autonomous Database with a Standby Database

" the documentation states: "When you stop the primary database

the standby database is also stopped. When you restart the primary database

the standby database is also restarted." This directly confirms that stopping the primary also stops the standby.

2. Oracle Cloud Infrastructure Documentation - Managing an Autonomous Database:

The section "Stopping and Starting an Autonomous Database" describes the Stopped lifecycle state as a user-initiated action for purposes like reducing CPU usage. It distinguishes this from a failure

clarifying why a failover (Option D) would not occur. The documentation for Data Guard-enabled instances specifies the linked behavior of the standby.

Scroll to Top