Hi All,
OS:- RHEL5
DB:-11GR2
Primary DB Name:- abc
Standby DB Name:- xyz
While trying to configure the dgmgrl
DGMGRL> connect sys/oracle
Connected.
DGMGRL> show configuration
Configuration - DGConfig1
Protection Mode: Max Performance
Database:
abc - Primary database
xyz - Physical standby database
Fast -Start Failover: DISABLED
Configuration Status:
DISABLED
DGMGRL> enable configuration
Enabled
DGMGRL> show configuration
Configuration - DGConfig1
Protection Mode: MaxPerformance
Databases:
abc - Primary database
Error: ORA-16724: cannot resolve gap for one or more standby databases
xyz - Phsyical standby database
Error: ORA-16700:the standby database has diverged from the primary database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR
On primary site:
SQL> SELECT CURRENT_SCN FROM V$DATABASE;
CURRENT_SCN
______________
1447457
On standby site:-
SQL> SELECT CURRENT_SCN FROM V$DATABASE;
CURRENT_SCN
______________
1395640
Can anyone of you help me to troubleshoot this problem and tell me the concept behind this why this error occurs.