• Recovering from the loss of an inactive redo log group.

    从不活动重做日志丢失中恢复

    youdao

  • Recovering from the loss of the current redo log group.

    当前重做日志丢失中恢复

    youdao

  • Recovering from the loss of an only active redo log group

    惟一活动重做日志丢失中恢复

    youdao

  • Recovering from the loss of one member of an online redo log group.

    丢失联机重做日志成员中进行恢复

    youdao

  • Creates the online redo log files if they do not currently exist.

    联机日志损坏,不能做完整修复时,用的。

    youdao

  • It is defined as "distance" between is and the end of the redo log.

    定义位置到日志文件结束距离

    youdao

  • The redo log buffer is one-third full or contains 1 MB of buffered data.

    重做日志记录达到缓冲区三分之一

    youdao

  • If the size of your redo log is 20m, you are taking 4 checkpoints for each log.

    如果日志文件大小20m每个日志文件发生4检查点

    youdao

  • It also contains the location in the redo log where the data block was last changed.

    检查点队列包含日志文件数据最后一次被修改位置

    youdao

  • Changing the size and number of the online redo log files is sometimes done to tune the database.

    改变在线重做日志文件大小数量有时优化数据库

    youdao

  • Normally, a switch occurs when the current online redo log file is full and writing must continue.

    一般来说当前在线日志文件已经满了并且必须继续的是偶,日志切换就会发生

    youdao

  • Maintaining multiple members of an online redo log group protects against the loss of the redo log.

    保存在线日志文件多个成员来保证重做日志不丢失

    youdao

  • The position in the redo log where recovery is to start is referred to as the checkpoint position.

    日志文件数据库恢复开始位置称作检查点位置。

    youdao

  • Redo records can also be written to a redo log file before the corresponding transaction is committed.

    基本意思如下对于记录,在相应事务提交之前写入重做日志文件

    youdao

  • This necessitates well-sized redo logs to avoid unnecessary checkpoints as a result of frequent log switches.

    这个需求精心设计日志文件大小从而不会由于频繁日志切换避免不必要的检查点

    youdao

  • Now that you are confirmed that the lost redo file is an ACTIVE redo log, shutdown the database - shutdown immediate.

    既然确认丢失文件active重做日志,那么现在就可以关闭数据库——shutdownimmediate

    youdao

  • Now that you are confirmed that the lost redo file is a CURRENT redo log, shutdown the database - shutdown immediate.

    既然确认丢失文件current重做日志,那么现在就可以关闭数据库——shutdownimmediate

    youdao

  • To investigate what status is the missing redo log is - Select * from v$logfile shows which group and member is INVALID

    检查丢失日志处于什么状态 ——Select *fromv$logifle显示哪个哪个成员无效的。

    youdao

  • Now that you are confirmed that the lost redo file is an INACTIVE redo log, shutdown the database - shutdown immediate.

    既然已经确认丢失文件inactive重做日志,那么现在可以关闭数据库——shutdown immediate。

    youdao

  • Checkpoint (CKPt) - Synchronizes the headers of data files and control files with the current redo log and checkpoint Numbers.

    检查点(CKPt)——数据文件控制文件头当前重做日志和检查点数同步。

    youdao

  • You can add or drop online redo log file groups or members to the primary database without affecting the standby database.

    可以添加删除在线重做日志或者日志成员而不影响库。

    youdao

  • Ideally, the locations of the members should be on separate disks so that the failure of one disk does not cause the loss of the entire online redo log.

    理论上说,日志文件组成员的存放位置应该放在磁盘不同位置,这样即使一个磁盘损坏不会导致整个在线做日志文件丢失

    youdao

  • 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

    youdao

  • 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.

    无论何时添加在线日志文件,你应该库添加相应的在线重做日志备用重做日志文件

    youdao

  • Since the redo log group is inactive and is archived, just clear the redo log - alter database clear logfile group N (where N is the group # of the lost redo log)

    由于日志不活动归档所以只需清除重做日志即可 ——alterdatabaseclear logfilegroupN其中 N 是丢失的重做日志组 #)。

    youdao

  • On the other hand, a larger number of changed objects per transaction means you lock changes for a longer time and your database also needs a bigger redo log.

    一方面,每次事务修改对象数量越多就意味着锁定变更时间越长同时数据库需要更大redo log

    youdao

  • The maximum protection and maximum availability modes require that standby redo log files are configured on at least one standby database in the configuration.

    最大保护最大可用性模式需要重做日志文件配置配置中的至少一个数据库

    youdao

  • 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.

    有点伤,需要上重新应用重做数据,应用归档日志同步库之间的数据。

    youdao

  • When the CPU load goes up, the time taken for a log file sync round trip can increase even when the number of log file syncs and the volume of redo log generated doesn't change.

    CPU负荷增长尽管(写)事务没有变写日志个数没有变日志文件同步往返信号传输时间就会延长。

    youdao

  • Unless the redo log buffer is particularly full, only one synchronous writes is required per transaction. if piggybacking occurs, there can be less than one synchronous write per transaction.

    除非日志缓冲区特别否则每个事务处理需要一个同步写入

    youdao

$firstVoiceSent
- 来自原声例句
小调查
请问您想要如何调整此模块?

感谢您的反馈,我们会尽快进行适当修改!
进来说说原因吧 确定
小调查
请问您想要如何调整此模块?

感谢您的反馈,我们会尽快进行适当修改!
进来说说原因吧 确定