About Journals, Journal Files, and Journal Archives

From InterBase

Go Up to Journaling and Disaster Recovery

A journal consists of one or more journal files. A journal file records each database transaction as it occurs. This makes a journal an always-up-to-date record of database transactions. Journaling is sometimes referred to as write-ahead logging (WAL).

A journal archive is a directory that contains a full database dump and all the journal files completed since that dump. You can use the journal archive to recover to the last transaction recorded in the most recently archived journal file. You can also use an archived journal file to perform point-in-time recovery. Point-in-time recovery uses the internal timestamp that is recorded on each transaction in the file, which allows you to, if desired, recover to a specific date and time.


Advance To: