High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Question for Real Time apply

set up standby database with real time apply, can see on standby redo log file size continue increase, but current_scn in v$database does not change. Is this nromal?

select SEQUENCE#, STATUS, BYTES, USED from v$standby_log order by 1;

 SEQUENCE# STATUS          BYTES       USED
---------- ---------- ---------- ----------
         0 UNASSIGNED  105906176          0
         0 UNASSIGNED  104857600          0
         0 UNASSIGNED  104857600          0
      9265 ACTIVE      105906176    1216512

select CURRENT_SCN  from v$database
    CURRENT_SCN
---------------
 10209405856785

Source

SQL>  select DEST_NAME, STATUS,RECOVERY_MODE from v$archive_dest_status
DEST_NAME                      STATUS    RECOVERY_MODE
------------------------------ --------- -----------------------
LOG_ARCHIVE_DEST_1             VALID     IDLE
LOG_ARCHIVE_DEST_2             VALID     MANAGED REAL TIME APPLY
LOG_ARCHIVE_DEST_3             INACTIVE  IDLE

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