Hi,
Just completed DataGuard configuration between 2 11gR2 RAC primary/standby databases.
I made a few tests (created a table as select * from dba_directories to get a few rows on the
primary), my data is not replicated to the standby (opened in 'READ ONLY WITH APPLY' mode)...
From within DGMGRL utility I get the following error, on a regular basis:
DGMGRL> show configuration
Configuration - dgtestfo
Protection Mode: MaxPerformance
Databases:
testfo - Primary database
testfos - Physical standby database
Warning: ORA-16857: standby disconnected from redo source for longer than specified threshold
Fast-Start Failover: DISABLED
Configuration Status:
WARNING
and then the next second I run this command:
DGMGRL> show configuration
Configuration - dgtestfo
Protection Mode: MaxPerformance
Databases:
testfo - Primary database
testfos - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
this error disappears for a few seconds; then if I retype 'show configuration' it pops up again, and so on...
Where would you go to investigate this ? I made all checks possible, without success.
Thanks a lot.
Regards,
Seb