Changing the size and number of the online redo log files is sometimes done to tune the database.
改变在线重做日志文件大小和数量有时是优化数据库。
Redo Logfile Sizing Advisor - This feature recommends the optimal size of redo log files in order to avoid excessive disk I/Os due to frequent checkpointing.
Redo Logfile SizingAdvisor ——此特性推荐重做日志文件的最佳大小,从而避免因频繁出现的检查点而导致过多的磁盘I/O。
Whenever you add an online redo log file to the primary database, you should add corresponding online and standby redo log files to the standby database.
无论何时,你在主库添加在线重做日志文件,你应该在备库添加相应的在线重做日志和备用重做日志文件。
The maximum protection and maximum availability modes require that standby redo log files are configured on at least one standby database in the configuration.
最大保护和最大可用性模式需要备重做日志文件配置在配置中的至少一个备数据库上。
At some point, you need to resume redo apply on the standby database, and apply the archived redo log files to resynchronize the standby database with the primary database.
在有点伤,你需要在备库上重新应用重做数据,应用归档日志来同步备库和主库之间的数据。
Checkpoint (CKPt) - Synchronizes the headers of data files and control files with the current redo log and checkpoint Numbers.
检查点(CKPt)——将数据文件头和控制文件头与当前重做日志和检查点数同步。
If Redo Apply is running, you must cancel Redo Apply before you can change the log files.
如果重做应用正在运行,你必须在你改变日志文件钱取消重做应用。
Log Writer (LGWr) - Writes entries from log buffer to redo the log files.
日志读写器(LGWr)——从日志缓冲区写入项目,以便重做日志文件。
When a physical standby database is open, redo data from the primary database is received by the standby database, but the log files are not applied.
当物理备库是打开时,来自主库的重做数据被备库接收,但是不会被应用。
The on-disk RBA is the point up to which LGWR has flushed the redo thread to the online log files.
磁碟央行是这点已刷新LGWR的重做线程的在线日志文件。
The on-disk RBA is the point up to which LGWR has flushed the redo thread to the online log files.
磁碟央行是这点已刷新LGWR的重做线程的在线日志文件。
应用推荐