Hi guys,
I am using Oracle Dataguard on Oracle Database 11gR2 with broker configuration:
DGMGRL> SHOW CONFIGURATION;
Configuration - NAME_DG
Protection Mode: MaxPerformance
Databases:
nameprod - Primary database
namedg - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
This is my Apply Lag time:
DGMGRL> SHOW DATABASE NAMEDG
Database - namedg
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 26 minutes 53 seconds
Real Time Query: ON
Instance(s):
NAMEDG
Database Status:
SUCCESS
I would like to reduce the "Apply Lag" time, it is possible? Do you know any way?
Thanks in advanced.