How To Find All Standby Databases for a Primary Database in Data Guard

Onur ARDAHANLI

4 years ago

You can find all standby databases for a primary database in data guard by using one of the queries below.

SQL> show parameter log_archive_config

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_config                   string      DG_CONFIG=(primary,standby)

SQL> show parameter log_archive_config

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

log_archive_config string DG_CONFIG=(primary,standby)

SQL> select * from v$dataguard_config;

DB_UNIQUE_NAME
------------------------------
standby
Primary

SQL> select * from v$dataguard_config;

DB_UNIQUE_NAME

------------------------------

standby

Primary

Standby -> Returns the unique name of the current database.

Primary -> Returns the unique name of the other database in the Environment.