存档日志模式支持在线备份和恢复。
OFF——默认设置,表示使用循环日志模式。
OFF - The default setting to indicate circular logging to be used.
在循环日志模式中,事务以循环方式写到日志中。
In circular log mode, transactions will write to the log in a circular manner.
循环日志:循环日志是DB2的默认日志模式。
Circular logging: Circular logging is the default logging mode for DB2.
如果要进行在线备份,那么需要将日志模式改为存档日志。
Should you desire to do an online backup (which you will explore later), log mode needs to be modified to archived logging.
这些参数的默认值是OFF,这表示使用循环日志模式。
The default values for these parameters are OFF, which indicates circular logging mode to be used. There are five values you can set for these two parameters
采用这种方法时,使用循环日志模式,可以以循环方式重写日志。
With this method, circular logging is used and logs can be overwritten in a round robin manner.
可用性——在使用循环日志模式时,只能进行离线全备份。
Availability - With circular logging mode, only offline full backup is possible.
对于DB 2LUW,您可以备份的内容取决于数据库的日志模式。
For DB2 LUW, what you can backup depends on the logging mode of the database.
DB 2 Express- C提供两种日志模式,循环和存档日志模式。
DB2 Express-C comes with two logging modes, circular and archive log modes.
例如,日志缓冲区将每个事务写到日志,可以使用不同的日志模式来实现不同的备份和恢复模式。
For example, the log buffer writes each transaction to logs and how different log mode can be used to accomplished different modes of backup and recovery.
DCS配置文件为更改dcs配置提供了支持,例如设置日志模式、转换超时、日志文件位置和远程dcs地址。
The DCS configuration file provides support for changing the DCS configuration such as setting the log modes, conversion timeout, log file location and Remote DCS address.
我们在日志模式下运行PerformanceMonitor,每隔15 分钟收集一次数据。
We ran the Performance Monitor in logging mode and collected data at 15-minute intervals.
LOGRETAIN——设置logretain值会自动地将参数LOGRETAIN的值改为RECOVERY,这表示使用存档日志模式。
LOGRETAIN - Setting the value LOGRETAIN will automatically change the value for the parameter, LOGRETAIN to RECOVERY, which indicates archive logging mode will be used.
为转换到归档日志模式,只需运行命令db2updatedbcfgfor icmnlsdb usinglogretain on即可。
In order to turn to the archive log mode, simply issue the command db2 update db CFG for icmnlsdb using logretain on.
Logging列显示在创建数据库时设置的日志模式(buffered、unbuffered、ANSI compliant和notlogged)。
The Logging column mentions the logging mode that has been set while creating the database (buffered, unbuffered, ANSI compliant, and not logged).
在物理恢复完成之后,数据库实例处于快速恢复模式,等待恢复逻辑日志。
After the physical restore completes, the database instance waits in fast recovery mode to restore logical logs.
在上述情况下,如果性能很重要的话,最好是在执行上述操作时禁用事务日志归档模式。
If performance is important in the above cases, it would be a good idea to disable transaction log archive mode for the duration of their execution.
清单10:查看事务日志归档模式状态。
Listing 10: Checking for the transaction log archive mode status?
定期启用事务日志归档模式进行的在线备份,事务日志存储在一个容错磁盘上。
Online backups with transaction log archive mode enabled at regular intervals and the transaction logs are stored on a fault-tolerant disk.
当系统中不再存在属于旧模式的日志记录时,影子复制将被自动删除,系统中就只有新的主复制。
After the log records pertaining to older schema no longer exist in the system, the shadow replicate is automatically deleted and system only has new master replicates.
日志记录模式提供服务调用可跟踪性。
The logging pattern provides service invocation traceability.
检查事务日志归档模式是否启用。
清单7:执行备份,启用事务日志归档模式,并删除这次备份之前归档的事务日志。
Listing 7: Perform a backup, enable the transaction log archive mode, and delete archived transaction logs before this backup.
清单6:执行备份,启用事务日志归档模式,并保存这次备份之前归档的事务日志。
Listing 6: Perform a backup, enable the transaction log archive mode, and preserve archived transaction logs before this backup.
如果事务日志归档模式被启用,那么这个属性将被设为true。
If the transaction log archive mode is enabled, this property will be set to true.
禁用事务日志归档模式。
启用事务日志归档模式的一个副作用是:在下面两种情况下,所有数据更改(insert)都会被记录到日志中,而默认情况下它们不会被记录。
One side effect of enabling the transaction log archive mode is all the data changes (inserts) get logged, whereas by default they are not logged in the following two cases.
HADR日志写入同步模式。
HADR日志写入同步模式。
应用推荐