ORA-16739: redo transport service for member “PRODDR” is running

You get ORA-16739 when you check your Primary Database in dgmgrl.



Note: On this system, PROD is the Primary Database. And PRODDR is the Standby Database.


DGMGRL> show database 'PROD';

Database - PROD

  Role:               PRIMARY
  Intended State:     TRANSPORT-OFF
  Instance(s):
    PROD
      Error: ORA-16739: redo transport service for member "PRODDR" is running

Database Status:
ERROR


The ORA-16739 is telling us that log shipping is enabled on Standby. Since log shipping in a DG environment goes from the Primary to one or more Standby Databases, it should be enabled only on the Primary. To correct this error, disable the log shipping on the Standby.


Check the current setting.


DGMGRL> show database 'PRODDR' LogShipping;
  LogShipping = 'ON'


Disable the log shipping.


DGMGRL> edit database 'PRODDR' set property LogShipping='OFF';
Property "logshipping" updated


Verify the log shipping if on the Standby.


DGMGRL> show database 'PRODDR' LogShipping;
  LogShipping = 'OFF'


Verify the problem is fixed.


DGMGRL> show database 'PROD';

Database - PROD

  Role:               PRIMARY
  Intended State:     TRANSPORT-OFF
  Instance(s):
    PROD

Database Status:
SUCCESS


Leave a Reply