Thursday 29 March 2012

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 is not using standby redo logs, and the redo transport service to the standby database is set with a nonzero value of ReopenSecs and a zero value of MaxFailure. In this case, the redo transport service will retry the standby destination indefinitely and never switch to the alternate destination.

Action: Any one of the following actions will solve the problem: (1) add standby redo logs to the standby database; (2) set ReopenSecs property to zero; (3) set MaxFailure property to a nonzero value. After executing one of the above actions, reset the AlternateLocation property.

No comments:

Post a Comment