ORA-16815: incorrect log transport setting for AlternateLocation of standby &qu

ORA-16815: incorrect log transport setting for
AlternateLocation of standby "string"

Question Posted / guest

1 Answers
2996 Views
I also Faced
E-Mail Answers

ORA-16815: incorrect log transport setting for AlternateLocation of standby "string"..

Answer / guest

Cause: The Data Guard broker detected that the log transport
setting for the standby database regarding its
AlternateLocation property value is incorrect. The incorrect
setting could be one of the following: (1) the
AlternateLocation property is empty but the log transport to
the standby has an ALTERNATE setting; (2) the
AlternateLocation property is not empty but the log
transport to the standby has no ALTERNATE setting; (3) the
AlternateLocation property does not match the ALTERNATE
setting in the log transport. The mismatch may includes
service string, directory specification of the alternate
location, or SP_NAME attribute. (4) the
log_archive_dest_state_n parameter corresponding to the
alternate location is not set to ALTERNATE. (5) the flash
recovery area is being used by the standby for archived
logs, but the log transport to the standby still has an
ALTERNATE setting for the AlternateLocation. Data Guard
broker logs provide further details on which of the above
cases causes the error.

Action: Re-enable the primary database to clear the error.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

Post New Answer