建好RAC+standy DB了，往里面导数据的大疑问？

blue_prince

我是在4年前9201的时候设置为MANDATORY时发生过一次问题，把MANDATORY去掉以后就行了，因此我认为没影响

battleman

Archiving happens when a log switch occurs on the primary database. After the ARC0 process successfully archives the local online redo log to the local destination (LOG_ARCHIVE_DEST_1), the ARC1 process transmits redo from the local archived redo log files (instead of the online redo log files) to the remote standby destination (LOG_ARCHIVE_DEST_2). On the remote destination, the remote file server process (RFS) will, in turn, write the redo data to an archived redo log file from a standby redo log file. (Section 5.6.2 describes how to configure standby redo log files.) Log apply services use Redo Apply (MRP processFoot 2) or SQL Apply (LSP processFoot 3) to apply the redo to the standby database. Because the online redo log files are archived locally first, the LGWR process reuses the online redo log files much earlier than would be possible if the ARCn processes archived to the standby database concurrently with the local destination. This behavior is useful when archiving to remote destinations that use a slow network connection, such as a long-distance wide area network (WAN). A benefit of the default ARCn archival behavior is that local archiving, and hence, processing on the primary database, is not affected by archiving to non-mandatory, remote destinations. It may be necessary to create more online redo log files, because it may take more time to recycle the online redo log files for reuse by the log writer process.

owlstudio

为什么不先导好数据，再建STANDBY DB ?