标题: ORA-16814: incorrect redo transport setting for AlternateLocation for [打印本页] 作者: admin 时间: 2016-8-30 09:39 标题: ORA-16814: incorrect redo transport setting for AlternateLocation for ORA-16814: incorrectredo transport setting for AlternateLocation for standby database Cause: The Data Guard broker detected an incorrect redotransport setting for a
standby database AlternateLocation property. The incorrect setting could be oneof
the following:
- The AlternateLocation property was empty, but the redo transport to thestandby
database had an ALTERNATE setting.
ORA-12700to ORA-19400 13-237
- The AlternateLocation property was not empty and theredo transport to the
standby database had no ALTERNATE setting.
- The AlternateLocation property did not match the ALTERNATE setting in the
redo transport. The mismatch may include service string, directoryspecification of
the alternate location, or the DB_UNIQUE_NAME attribute.
- The LOG_ARCHIVE_DEST_STATE_n parameter corresponding to the alternate
location was not set to ALTERNATE.
- The flash recovery area was being used by the standby database for archived
logs, but the redo transport to the standby database still had an ALTERNATE
setting for the AlternateLocation property. Data Guard broker logs provide more
details on which of the above cases caused the error. Action: Reenablethe primary database to clear the error.