v$dataguard_config has different result in both (Primary and STDBY) databases
Hi ,
could you explain the following result, for DG (REWE,EWER):
why the current_scnfor PHYSICAL STANDBY Database is different when I query v$dataguard_config in both DBs ?
why the current_scn is not reported for Primary DB, when I query the v$dataguard_config in Standby DB ?
Primary Database :
SQL> select name , database_role,open_mode,protection_mode , switchover_status from v$database ; NAME DATABASE_ROLE OPEN_MODE PROTECTION_MODE SWITCHOVER_STATUS --------- ---------------- -------------------- -------------------- -------------------- REWE PRIMARY READ WRITE MAXIMUM PROTECTION TO STANDBY SQL> select * from v$dataguard_config ; DB_UNIQUE_NAME PARENT_DBUN DEST_ROLE CURRENT_SCN CON_ID ------------------------------ ------------------------------ ----------------- ----------- ---------- REWE NONE PRIMARY DATABASE 2357803 0 EWER REWE PHYSICAL STANDBY 2357889 0