DataGuard - Sequence No is not available in Standby site
Hi
I have just configured DataGuard (Oracle 12c TNS for Linux: Version 12.2.0.1.0 - Production).
Problem is that sequence No. Is not showing in standby server.
Primary server
----------------------------
SQL> select SEQUENCE#,APPLIED from v$archived_log where SEQUENCE#=(select max(SEQUENCE#) from v$archived_log);
SEQUENCE# APPLIED
---------- ---------
27 NO
Standby Server
-----------------------
SQL> SELECT dest_id,status,database_mode,recovery_mode FROM v$archive_dest_status WHERE status <> 'INACTIVE';
DEST_ID STATUS DATABASE_MODE RECOVERY_MODE
---------- --------- --------------- -----------------------
1 VALID MOUNTED-STANDBY MANAGED REAL TIME APPLY
32 VALID UNKNOWN IDLE
SQL> select SEQUENCE#,APPLIED from v$archived_log where SEQUENCE#=(select max(SEQUENCE#) from v$archived_log);