You are here: Home // Oracle 11g // ORA-16723: setting AlternateLocation property conflicts with the redo transport setting

ORA-16723: setting AlternateLocation property conflicts with the redo transport setting

Cause: The standby database was not using standby redo logs, and the redo transport service to the standby database is set to a nonzero value for the ReopenSecs property and a value of zero for the MaxFailure property. In this case, the redo transport service will attempt to send redo data to the standby database indefinitely and never switch to the alternate destination. See the solution below.

Error solution: Any one of the following actions will solve the problem:
  • add standby redo logs to the standby database.
  • set ReopenSecs property to zero.
  • set MaxFailure property to a nonzero value. After performing one of the above actions, reset the standby database AlternateLocation property.

Database version: Oracle 11g Release 2 (11.2)

Tags: ,

Leave a Reply

Copyright © 2009 Oracle Error Codes Database. All rights reserved.
Powered by WordPress.
Promotes: Katalog stron - Randki Leksykon Vat 2011 akcesoria do łazienek Wyroby z gumy i silikonu Przyczyny chrapania