Prev Question
Next Question

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?

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.

Explanation:
Viewing Information About the Observer
You can find information about the observer by querying the following columns in the V$DATABASE view:
* FS_FAILOVER_OBSERVER_HOST shows the name of the computer on which the observer is running. Here
it is cats.
* FS_FAILOVER_OBSERVER_PRESENT shows whether or not the observer is connected to the local
database. Here the value is NO.
https://docs.oracle.com/cd/B19306_01/server.102/b14230/sofo.htm

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *