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

MOSC Banner

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);

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