Hello
Im new to data guard, im trying to setup oracle 12c data guard
Redo transport problem detected: redo transport to database chicago_stby has the following error:
ORA-16086: Redo data cannot be written to the standby redo log
Data Guard Broker Status Summary:
Type Name Severity Status
Configuration my_dg_config Warning ORA-16607
Primary Database chicago Error ORA-16778
Physical Standby Database chicago_stby Warning ORA-16809
DGMGRL> show configuration;
Configuration - my_dg_config
Protection Mode: MaxPerformance
Members:
chicago - Primary database
Error: ORA-16778: redo transport error for one or more members
chicago_stby - Physical standby database
Warning: ORA-16809: multiple warnings detected for the member
Fast-Start Failover: DISABLED
Configuration Status:
ERROR (status updated 39 seconds ago)
DGMGRL> show configuration
Configuration - my_dg_config
Protection Mode: MaxPerformance
Members:
chicago - Primary database
Error: ORA-16778: redo transport error for one or more members
chicago_stby - Physical standby database
Warning: ORA-16809: multiple warnings detected for the member
Fast-Start Failover: DISABLED
Configuration Status:
ERROR (status updated 45 seconds ago)
DGMGRL> show database chicago
Database - chicago
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
chicago
Error: ORA-16737: the redo transport service for member "chicago_stby" has an error
Database Status:
ERROR
DGMGRL> show database chicago_stby;
Database - chicago_stby
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 2 seconds (computed 3507 seconds ago)
Apply Lag: 2 seconds (computed 3507 seconds ago)
Average Apply Rate: 9.00 KByte/s
Real Time Query: ON
Instance(s):
chicago
Database Warning(s):
ORA-16857: member disconnected from redo source for longer than specified threshold
ORA-16826: apply service state is inconsistent with the DelayMins property
ORA-16789: standby redo logs configured incorrectly
Database Status:
WARNING
DGMGRL>