Database Administration (MOSC)

MOSC Banner

v$dataguard_config has different result in both (Primary and STDBY) databases

edited Aug 27, 2015 2:12AM in Database Administration (MOSC) 2 commentsAnswered

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




Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center