LOG_ARCHIVE_DEST_n参数属性——DATA GUARD概念和管理

AFFIRM和NOAFFIRM设置是否确认将归档信息写入到磁盘中；

ALTERNATE和NOALTERNATE设置是否在归档目录无法写入时，将归档写入到另外的地方；

ARCH和LGWR设置是ARCn进程写归档还是LGWR进程写归档；

DELAY和NODELAY设置STANDBY数据库是否延迟应用归档日志；

DEPENDENCY和NODEPENDENCY参数在归档文件可以直接被其他STANDBY数据库访问时，其他的STANDBY在归档文件可用时是否还需要传输归档；

LOCATION和SERVICE设置本地归档或归档到STANDBY数据库；

MANDATORY和OPTIONAL设置归档路径是强制的还是可选的；

MAX_FAILURE和NOMAX_FAILURE参数设置归档失败后，连接重试的最大次数；

NET_TIMEOUT和NONET_TIMEOUT设置LGWR进程写归档信息时等待的秒数；

--------------------------------------------------------------------

The log writer process waits for the specified amount of time to receive status
about the network I/O. If there is a possible network disconnection, even one that
was terminated due to a network timeout, the log writer process automatically
tries to reconnect to the standby database to resolve network brownouts and false
network terminations. Typically, except when the network is physically broken,
the log writer process can successfully reconnect to the network. The reconnection
attempts continue for a period of time that depends on the following factors:
■ The value of the NET_TIMEOUT attribute on the primary database.
■ The protection mode of the primary database, which determines the
maximum amount of time that the reconnection will take. Use the following
time estimates as a guideline for how long the log writer process will try toreconnect to the standby database:
– In maximum protection mode, the log writer process tries to reconnect forapproximately 5 minutes.
– In maximum availability mode, the log writer process tries to reconnectwithin the NET_TIMEOUT value.
    ---------------------------------------------------------------------

QUOTA_SIZE和NOQUOTA_SIZE设置归档目录可以使用的空间大小；

QUOTA_USED和NOQUOTA_USED显示归档目录以及使用的空间大小；

REGISTER和NOREGISTER设置是否在目标站点记录归档日志的位置；

REOPEN和NOREOPEN设置在归档失败后是否进行重试；

SYNC和ASYNC设置LGWR进程写IO操作是否同步进行；

TEMPLATE和NOTEMPLATE设置归档路径和格式的模板信息。

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/81912/viewspace-1341/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/81912/viewspace-1341/