Tuesday, January 6, 2026

ora 16778 redo transport error

 ORA-16778: redo transport error means the Data Guard broker can't send redo logs to standby(s), usually due to network issues, incorrect TNS/listener settings, missing executables, or parameter conflicts, requiring checks in the Alert Log, Broker Log, v$archive_dest_status, and confirming TNS entries on both primary/standby, often resolved by fixing TNS connectivity or restarting processes. 

Common Causes & Solutions:
  1. Network Connectivity/TNS Issues:
    • Check: tnsping from primary to standby and vice-versa; check tnsnames.ora and listener.ora for correct hostnames/IPs/ports.
    • Fix: Ensure hostnames resolve, TNS entries match, and listeners are running on both sides.
  2. Data Guard Broker Configuration Errors:
    • Check: Use DGMGRL > SHOW CONFIGURATION and SHOW DATABASE for detailed status, check broker log (location varies by Oracle version).
    • Fix: Sometimes a simple restart or re-adding the standby via DGMGRL (after cleaning up duplicates) can resolve broker state issues.
  3. Missing or Incorrect Executables/Parameters:
    • Check: Verify necessary Oracle executables (like arcn/arcf for LGWR/ARCn processes) exist and permissions are correct on the standby.
    • Fix: Ensure LOG_ARCHIVE_DEST_n parameters are correctly set on the primary to point to the standby, and FAL_SERVER/FAL_CLIENT are set on both.
  4. Primary/Standby State Mismatch:
    • Check: In DGMGRL, see if the standby is disconnected (ORA-16857).
    • Fix: Try ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; and then restart recovery, or even SHUTDOWN and STARTUP the standby. 
Diagnostic Steps:
  1. Check Alert Logs: Look for related errors like ORA-12541 (no listener) or network errors in both primary and standby alert_<sid>.log files.
  2. Query V$ARCHIVE_DEST_STATUS: On the primary, check this view for specific errors on the standby destination.
  3. Use DGMGRL: SHOW CONFIGURATIONSHOW DATABASESHOW LOGFILE for status.
  4. Verify TNS: Ensure connectivity is solid with tnsping. 

No comments:

Post a Comment