The simple classification of backup types provided by Altibase is as follows. The classification criteria follow the Administrator Manual.
- Logical backup
- Physical backup
- Online backup
- Offline backup
- Incremental backup (supported starting from Altibase 6.3.1)
Logical Backup
Logical backup is to back up database objects and data in the form of a text file that can be checked by a user using the aexport and iLoader utilities.
Backup type | Description | Example of backup result | |
---|---|---|---|
Logical Backup | aexport | aexport is a tool to support data migration between Altibase servers, but can be used for backup purposes. This creates all the database object creation statements created on the Altibase server as a file named .sql. It provides three methods to perform according to the purpose
| Example of aexport execution result and file contents.
|
iloader | Like aexport, this is a tool to support data migration, but it can be used for backup purposes. In table units, data is backed up in a text file that can be read by users.
| Example of DEPARTMENT sample table iloader execution |
Physical Backup
Physical backup is to copy files such as data files and log anchor files that make up the Altibase server and backing them up to a different physical location.
Physical backup classified into online backup and offline backup according to the Altibase server operation status.
Backup type | Description | Example of backup result | |
---|---|---|---|
Physical Backup
| Online backup | Performing physical backup while the Altibase server is running.
| Online backup only backs up one stable memory checkpoint image file. Data files in the disk temporary tablespace are not backed up.
|
Offline backup | Physical backup while the Altibase server has stopped. Only full database backup is possible.
| Offline backup backs up all data files.
|
Incremental Backup
Incremental backup is to back up only data pages that have changed since the last incremental backup and the 'page change tracking' must be activated.
The entire database or tablespace-level can be backed up.
Backup type | Description | Example of backup result | ||
---|---|---|---|---|
Incremental Backup | Level 0 incremental backup | Level 0 is incremental backup is similar to physical backup, but is a backup that is used for determining whether data pages have been changed. |
| |
Level 1 incremental backup | Differential incremental backup | This backs up pages that have changed since the most recently performed level 0 or level 1 incremental backup. | ||
Cumulative incremental backup | This backs up pages that have changed since the most recently performed level 0. |