Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
You can find all standby databases for a primary database in data guard by using one of the queries below.
1 2 3 4 5 | SQL> show parameter log_archive_config NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_config string DG_CONFIG=(primary,standby) |
or
1 2 3 4 5 6 | 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.
You are a life saver, thanks a lot