...
Comparison by backup type
The following is a table comparing the pros and cons of each backup type.
| Classification | Logical backup | Physical backup | Incremental backup |
|---|
| aexport | iloader | Online backup | Offline backup |
|---|
| Characteristics | - Object-level backup/recovery
- Require backup only when changing object structure
| | - When to minimize data loss
- When point-in-time recovery is required
- When there is no burden on the archive log mode operation
- When need to prepare for physical loss of files such as data files and log anchor files
| - When Altibase server downtime for backup can be secured
- When to minimize recovery time
| - When to minimize data loss
- When point-in-time recovery is required
- When there is no burden on the archive log mode operation
- When to prepare for physical loss of files such as data files and log anchor files
- When the DB performance degradation due to activating the 'Page Change Tracking" function can be sustained
|
|---|
| Pros | - Altibase server operation possible during recovery
| - Altibase server operation possible during recovery
| - Point-in-time recovery is possible
- Possible to prepare for the physical failure of data files and log anchor files
| | - Point-in-time recovery is possible
- Possible to prepare for the physical failure of data files and log anchor files
- Save backup time compared to online backup
- Save backup space compared to online backup
|
|---|
| Cons | | - Point-in-time recovery is unable
| - Manage archive log files
- Operating Altibase server is unable during recovery
| - Operating Altibase server is unable during recovery
| - Manage archive log files
- Operating Altibase server is unable during recovery
|
|---|
The following is a table comparing the features of each backup method in detail.
Backup type | Altibase server running status | Database mode | Backup file | Recovery point | Recovery target | Etc. |
|---|
| Backup | Recovery |
|---|
| Logical backup | aexport | Running | Running | Irrelevant | - Database object creation script (.sql extension)
- Automation script (.sh extension)
| | | |
|---|
| iloader | Running | Running | - FORM file for each table
- Data file in text format
| | | |
|---|
| Physical backup | Online backup | Running | Running (Control step) | Archive mode | - Disk data file
- 1 memory checkpoint image file
- Log anchor file
- Archive log file
| - Complete recovery
- Incomplete recovery
| - All databases
- Tablespace-level
| - Require archive log file management
|
|---|
| Offline backup | Stopped | - | Irrelevant | - Disk data file
- Memory checkpoint image file
- Log anchor file
- Online log file
| | | |
|---|
| Incremental backup | Running | Running (Control step) | Archive mode | - Disk data file
- 1 memory checkpoint image file
- Log anchor file
- Archive log file
- backupInfo file
| - Complete recovery
- Incomplete recovery
| - All databases
- Tablespace-level
| - Neet to active 'Page Change Tracking" function
- Require Archive log file
|
|---|
- Technical document " Altibase Capacity Guide"
- Technical document "Volume Configuration Guide Considering disk I/O"
- Administrator Manual -> 10. Backup and Recovery
- Administrator Manual -> 11. Incremental backup and Recovery
- Utilities Manual -> 1. aexport
- iLoader User's Manual
- Manual page: https://github.com/ALTIBASE/Documents/tree/master/Manuals