standby out of sync.
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