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

MOSC Banner

standby out of sync.

 Hi,

    The current primary archive log is 624. The standby database is showing following data since yesterday. Should I still wait?

SQL> select group#,sequence#,bytes,used,archived,status from v$standby_log;

    GROUP#  SEQUENCE#      BYTES       USED ARC STATUS
---------- ---------- ---------- ---------- --- ----------
         4          0   52428800        512 NO  UNASSIGNED
         5          0   52428800        512 NO  UNASSIGNED
         6          0   52428800        512 NO  UNASSIGNED
         7        623   52428800   45533696 YES ACTIVE

SQL> select group#,thread#,sequence#,bytes,archived,status from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES ARC STATUS
---------- ---------- ---------- ---------- --- ----------------
         1          1        622   52428800 YES CLEARING
         3          1        621   52428800 YES CLEARING
         2          1        623   52428800 YES CLEARING_CURRENT


SQL> select process,status,client_process,sequence#,block#,active_agents,known_agents
  2  from v$managed_standby;

PROCESS STATUS       CLIENT_P  SEQUENCE#     BLOCK# ACTIVE_AGENTS KNOWN_AGENTS

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