当数据库管理器关闭日志文件时,会归档日志文件。
Log files are archived when the database manager closes the log file.
每晚进行一次联机备份操作,备份所有数据文件、所有归档日志文件、一个控制文件。
Undertake online backup is operated every night, backup place know exactly about STH seizes file of file of file, all file log, a control.
当启用了userexit配置参数时,会调用用户出口来归档日志文件,并将它们移到活动日志路径以外的位置。
When the userexit configuration parameter is enabled, the user exit is called to archive log files and move them to a location away from the active log path.
可以弄一个和源数据库一样的备份数据库,通过源数据库生成的归档日志文件,把源数据库里的数据同步到备份数据库中。
You can keep a standby database current with its original database by continuously applying the original archived redo logs to the standby database.
在这种情况下,数据库管理器会删除logpath目录中的所有日志文件(包括联机归档日志文件),分配新的活动日志文件,并且回复到循环日志记录。
In this situation, the database manager deletes all log files in the logpath directory (including online archive log files), allocates new active log files, and reverts to circular logging.
在这种情况下,数据库管理器会删除logpath目录中的所有日志文件(包括联机归档日志文件),分配新的活动日志文件,并且回复到循环日志记录。
In this case, the database manager deletes all log files in the logpath directory (including online archive log files), allocates new active log files, and reverts to circular logging.
如果logretain设置成“Recovery”或者userexit设置成“Yes”(请参阅下一节),将保留活动日志文件,而且这些文件将变成联机归档日志文件,以便在前滚恢复中使用。
If logretain is set to "recovery" or userexit is set to "Yes" (see below), the active log files will be retained and become online archive log files for use in roll-forward recovery.
IDS将日志文件归档到包内,配置参数ltapedev为之指定一个有效的路径或设备。
IDS archives the log files incase, the configuration parameter LTAPEDEV points to an valid path or device.
例如,如果您已使用日期对访问日志归档,则可以选择在某个特定日期范围内的所有文件。
For example, if you have filed your access logs using dates, you can then select all of the files within a specific range of dates.
该参数还表示用户出口程序应该用于归档和检索日志文件。
This parameter also indicates that a user exit program should be used to archive and retrieve the log files.
使用归档日志记录时,如果您没有把旧的日志文件从活动日志目录中移走,它们将累积起来,并与活动日志文件共享该目录。
With archive logging, if you don't move old log files from the active log directory, they will accumulate and share the directory with the active log files.
与循环日志记录相比,当最后一个日志文件写满时,归档日志记录过程会创建一个新的日志文件,这样将来的事务就不会覆盖现有的日志文件。
In contrast to circular logging, the archival logging process creates a new log file when the last log file is filled so that future transactions will not overwrite existing log files.
其想法是由于在长事务期间,日志文件将经常由userexit程序归档,在活动日志目录中始终要有新的空间来存放额外的日志文件。
The idea is that since log files will be constantly archived by the userexit program during a long transaction, there will always be new room for additional log files in the active log directory.
该命令提供了目前活动的日志文件,因此被归档的日志将是那些比当前日志更早的日志。
It provides the log file that is currently active, and therefore archived logs will be those logs earlier than this current one.
所有归档的事务日志文件也存储在数据库事务日志目录中。
All the archived transaction log files are also stored in the database transaction log directory.
通过对日志文件进行归档,可以将日志文件移动到另外一个位置进行分析、存储或删除。
Archiving the log files allows you to move the log files to another location for analysis, storage, or deletion purposes.
对日志文件进行归档,将当前日志文件维护到一个可管理的大小。
Archive log files to maintain the current log file at a manageable size.
要确定哪个日志是活动的,哪些日志是归档的,请使用DB2命令GETDBCFG来查看“第一个活动日志文件”。
To figure out which log is active and which are archived, use the DB2 command GET DB CFG to view the 'First active log file'.
像通过多路复用(放在不同的位置)控制文件使数据库免疫、使用联机重做日志和归档重做日志这样的步骤,都是避免单点故障所必需的。
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.
日志循环会周期性地对旧日志进行归档,这样新消息就可以总能写到一个相对较小的文件中。
Log rotation periodically archives old log messages so that new messages are always written to a relatively small file.
从未归档联机日志文件的丢失中恢复。
清单9:禁用事务日志归档模式,并删除所有归档的事务日志文件。
Listing 9: Disable the transaction log archive mode, and delete all the archived transaction log files.
但是其缺点是:如果发生回滚,就可能有性能影响,因为userexit程序将需要从归档日志路径中检索未提交的日志文件。
The drawback though, can be a performance impact if a rollback occurs since the userexit program will need to retrieve the uncommitted log files from the archive log path.
联机归档日志:它们是驻留在数据库日志目录(“online”)中、普通数据库活动不再需要的日志文件。
Online archived logs: These are the log files that reside in the database log directory (' online ') and are no longer needed for normal database activity.
比如,是否有比较明显的不合适的日志文件大小问题,归档问题,大量的系统检测点,或者不合适的参数设置?
For example, is there evidence of incorrect sizing of log files, archiving issues, excessive number of checkpoints, or suboptimal parameter Settings?
比如,是否有比较明显的不合适的日志文件大小问题,归档问题,大量的系统检测点,或者不合适的参数设置?
For example, is there evidence of incorrect sizing of log files, archiving issues, excessive number of checkpoints, or suboptimal parameter Settings?
应用推荐