Database Tuning (MOSC)

MOSC Banner

Dataguard synchronization

Hi Oracle gurus,

While verifying the data guard on the primary and standby database, I found the primary database is not synchronized with the standby database.

Kindly find the details below and request to suggest on how to synchronize both the databases.

On Primary database

SQL> select sysdate,protection_mode, synchronized, synchronization_status from v$archive_dest_status where type='PHYSICAL' and synchronization_status !='OK';

SYSDATE    PROTECTION_MODE                   SYNCHRONIZED          SYNCHRONIZATION_STATUS

---------- ----------------------      ------------------------- --------------------------------------

17-JUL-21   MAXIMUM PERFORMANCE                     NO                    CHECK CONFIGURATION


On Standby database

SQL> select sysdate,protection_mode, synchronized, synchronization_status from v$archive_dest_status where type='PHYSICAL' and synchronization_status !='OK';

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