设置 _LOG_ARCHIVE_CALLOUT='LOCAL_FIRST=TRUE' 后是传输归档 ？

netstring

By default, redo transport services use ARCn processes to archive the online redo log files on the primary database. ARCn archival processing supports only the maximum performance level of data protection in Data Guard configurations.


You can optionally enable redo transport services to use the LGWR process to transmit redo data to remote destinations.

Using the LGWR process differs from ARCn processing (described in Section 5.3.1), because instead of waiting for the online redo log to switch at the primary database and then writing the entire archived redo log at the remote destination all at once, the LGWR process selects a standby redo log file at the standby site that reflects the log sequence number (and size) of the current online redo log file of the primary database. Then, as redo is generated at the primary database, it is also transmitted to the remote destination. The transmission to the remote destination will either be synchronous or asynchronous, based on whether the SYNC or the ASYNC attribute is set on the LOG_ARCHIVE_DEST_n parameter. Synchronous LGWR processing is required for the maximum protection and maximum availability modes of data protection in Data Guard configurations.

[ 本帖最后由 netstring 于 2009-3-5 16:17 编辑 ]

netstring

Once the redo log has been completely and successfully archived to at least one local destination, it will then be transmitted to the remote destination.

When a user sets up a data guard configuration with primary database using ARCH mode to ship log to the standby database, the ARCH processes ships online redo logs to the standby at the same time archives them locally.

这两个文档怎么说的意思不一样.
第一个文档说: 一旦online redo logs成功归档后, 它就会被传送到remote destination.
第二个文档说: 在本地归档的同时, ARCH processes会传送online redo logs到standby database.

tolywang

原帖由 netstring 于 2009-3-5 16:23 发表
Once the redo log has been completely and successfully archived to at least one local destination, it will then be transmitted to the remote destination.

When a user sets up a data guard configuration with primary database using ARCH mode to ship log to the standby database, the ARCH processes ships online redo logs to the standby at the same time archives them locally.

这两个文档怎么说的意思不一样.
第一个文档说: 一旦online redo logs成功归档后, 它就会被传送到remote destination.
第二个文档说: 在本地归档的同时, ARCH processes会传送online redo logs到standby database.

第一个文档是在加入 _LOG_ARCHIVE_CALLOUT='LOCAL_FIRST=TRUE' 之后 oracle9i 的动作 。

第二个文档是还没有加入 _LOG_ARCHIVE_CALLOUT='LOCAL_FIRST=TRUE'  之前 oracle9i 的动作。


Bug文档的最后一句不知道如何翻译  

The default behaviour is unchanged with this fix in 9.2 but the above hidden parameter can be set to change that behaviour.  

在9.2 中修复(fix)的话默认的动作不会改变， 但是如果设置上面的哪个隐含参数，将会改变行为  。

[ 本帖最后由 tolywang 于 2009-3-5 17:07 编辑 ]

jieyancai

“第一个文档是在加入 _LOG_ARCHIVE_CALLOUT='LOCAL_FIRST=TRUE' 之后 oracle9i 的动作 。

第二个文档是还没有加入 _LOG_ARCHIVE_CALLOUT='LOCAL_FIRST=TRUE'  之前 oracle9i 的动作。 ”

没错。

但是在9206，9207中，本地归档和远程归档用的是同一个归档进程，而在9208后，是用不同的归档进程传输归档。
仔细的话，可以从ALERT日志中看得出来。