i have a simple Question i think:
I connect to a Database, which uses Dataguard, with the following command:
sqlplus 'user/password@(DESCRIPTION = (ADDRESS_LIST = (FAILOVER=ON)(LOAD_BALANCE=OFF)(ADDRESS =(PROTOCOL = TCP) (HOST = primaryhost) (PORT = 1521)) (ADDRESS =(PROTOCOL = TCP) (HOST = backuphost) (PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = PRODDB_PRIMARY.world)))'
This works fine.
My question now:
After the successfull login, how can i see on which host i am ? On the primary or on the backuphost ?