什么是逻辑日志 - informix - 学习学习（What is logical log - Informix - learning to learn）.docVIP

什么是逻辑日志 - informix - 学习学习（What is logical log - Informix - learning to learn） What is the logical log - Informix - learning, learning blog home registration proposal and exchange list, join links recommend complaints search: help Study, study, and accept reality! Try to give up voluntarily! Trying to forget the past! S management blogs, post articles, message favorites, other program development}, database, SharePoint ? stock markets, finance, travel, blogs, music, album articles, Cognos, databases,}, Informix, Oracle Java learning, application learning, SharePoint, VS.NET, other operating systems,}, AIX, UNIX Windows stock analysis home page What is a logical log? Logs are used to record database operations. Including the physical log and logical log. The physical log records the physical changes in the database, that is, changes in the data information, while logical devices record logical changes, such as insert, Update and other actions, but not to record specific data, that is done by the physical log. Type of logical log You can use Informixs log type to understand logical logs: no logs, no buffer logs, and buffer logs, ASII logs No logs: do not log, and of course, do not support transactions (you can temporarily switch to a no log state in large transactions to prevent long transactions from occurring. ) No buffer logs: not all operations are written directly to disk, but each transaction is written immediately after completion. Buffer log: usually writes to disk after buffer is full Assii logs: similar to handling without buffer Handover command between logs: Backup mode for logical logs First talk about the backup level, and also use the concept of Informix to understand The backup levels are divided into 0, 1, 2 0: full backup 1: since the last full backup, incremental 2: increments from the last increment There are two kinds of backup methods: automatic and continuous Automation is not automatic in its imagination. It will end once it runs, so that script