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

Examine this query and its output:
SQL> select fs_failover_status, fs_failover_current_target,
2 fs_failover_observer_present, fs_failover_oserver_host
3 from v$database:
FS_FAILOVER_STATUS FS_FAILOVER_CURRENT_TARGET
FS_FAILOVER_OBSERVER_PRESENT FS_FAILOVER_OBSERVER_HOST
--------------- ----------------------- ---------------- ------------------
BYSTANDER cats NO

O17.example.com -
Which are true?

Answer options

• A. The observer is not connected to the database on which the query was executed.
• B. Cats is a bystander database.
• C. The observer is connected to the database on which the query was executed.
• D. The observer is currently running on o17.example.com.
• E. The observer is not running, but should run on o17.example.com.

Correct answer: A

Explanation

The correct answer is A because the output indicates that the fs_failover_observer_present status is 'NO', meaning the observer is not connected. Option B is incorrect as it misinterprets the context; 'cats' does not refer to the database status. Options C, D, and E are also false based on the provided output, which confirms that the observer is not present.