重做文件:这相当于DB2中的事务日志。
当你需要重做文件,修理电器,或重新审视已有想法,打起精神去做吧。
When you discover you have to redo a document, repair an appliance, or re-examine an assumption, do so with a good spirit.
既然您确认丢失的重做文件是active重做日志,那么现在就可以关闭数据库——shutdownimmediate。
Now that you are confirmed that the lost redo file is an ACTIVE redo log, shutdown the database - shutdown immediate.
既然您确认丢失的重做文件是current重做日志,那么现在就可以关闭数据库——shutdownimmediate。
Now that you are confirmed that the lost redo file is a CURRENT redo log, shutdown the database - shutdown immediate.
既然您已经确认丢失的重做文件是inactive重做日志,那么现在可以关闭数据库——shutdownimmediate。
Now that you are confirmed that the lost redo file is an INACTIVE redo log, shutdown the database - shutdown immediate.
例如如果重做日志缓冲满了,或者有其它的事务提交了。LGWR进程会把所有在重做日志缓冲中的重做日志事项写入重做文件,即使是一些重做记录可能还没有提交。
If the redo log buffer fills, or another transaction commits, LGWR flushes all of the redo log entries in the redo log buffer to a redo log file, even though some redo records may not be committed.
对于联机备份数据文件,这将导致生成大量的重做日志。
This will result in enormous redo logs to be generated for online backup data files.
重做日志——包含更改数据的前后映像的文件。
Redo logs - Files that contain the before and after images of changed data.
RedoLogfile SizingAdvisor ——此特性推荐重做日志文件的最佳大小,从而避免因频繁出现的检查点而导致过多的磁盘I/O。
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.
日志读写器(LGWr)——从日志缓冲区写入项目,以便重做日志文件。
Log Writer (LGWr) - Writes entries from log buffer to redo the log files.
像通过多路复用(放在不同的位置)控制文件使数据库免疫、使用联机重做日志和归档重做日志这样的步骤,都是避免单点故障所必需的。
Steps such as immunizing ther database by multiplexing (putting in different locations) control files, using online redo logs and archiving redo logs are necessary to avoid a single point of failure.
将所有数据文件、控制文件和联机重做日志文件复制到备份媒介。
Copy all data files, control files and online redo logs file to backup media.
检查点(CKPt)——将数据文件头和控制文件头与当前重做日志和检查点数同步。
Checkpoint (CKPt) - Synchronizes the headers of data files and control files with the current redo log and checkpoint Numbers.
如果重做应用正在运行,你必须在你改变日志文件钱取消重做应用。
If Redo Apply is running, you must cancel Redo Apply before you can change the log files.
理论上说,日志文件组的成员的存放位置应该放在磁盘上的不同位置,这样即使一个磁盘损坏也不会导致整个在线重做日志文件丢失。
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.
改变在线重做日志文件大小和数量有时是优化数据库。
Changing the size and number of the online redo log files is sometimes done to tune the database.
保存在线重做日志文件组的多个成员来保证重做日志不丢失。
Maintaining multiple members of an online redo log group protects against the loss of the redo log.
在这一点,重做应用使用新的裸设备上的数据文件并继续恢复。
At this point Redo Apply USES the new raw device data file and recovery continues.
最大保护和最大可用性模式需要备重做日志文件配置在配置中的至少一个备数据库上。
The maximum protection and maximum availability modes require that standby redo log files are configured on at least one standby database in the configuration.
一般来说,当当前的在线重做日志文件已经满了并且还必须继续写的是偶,日志切换就会发生。
Normally, a switch occurs when the current online redo log file is full and writing must continue.
无论何时,你在主库添加在线重做日志文件,你应该在备库添加相应的在线重做日志和备用重做日志文件。
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.
在装入文件夹期间无法复原或重做一个文件夹操作。
You cannot undo or redo a folder action while the folder is loading.
磁碟央行是这点已刷新LGWR的重做线程的在线日志文件。
The on-disk RBA is the point up to which LGWR has flushed the redo thread to the online log files.
基本意思如下对于重做记录,在相应的事务被提交之前,也能被写入重做日志文件。
Redo records can also be written to a redo log file before the corresponding transaction is committed.
基本意思如下对于重做记录,在相应的事务被提交之前,也能被写入重做日志文件。
Redo records can also be written to a redo log file before the corresponding transaction is committed.
应用推荐