...
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 - All database objects
- By database user
- By object
| Example of aexport execution result and file contents. $ ls eheejung eheejung 303 2019-07-12 13:15 ALL_ALT_TBL.sql |
eheejung eheejung 0 eheejung eheejung 0 2019-07-12 13:15 ALL_CRT_DIR.sql |
eheejung eheejung 0 eheejung eheejung 0 2019-07-12 13:15 ALL_CRT_FK.sql |
-rw-rw-rw- 1 eheejung eheejung 1539 2019-07-12 13:15 ALL_CRT_INDEX.sql |
eheejung eheejung 0 eheejung eheejung 0 2019-07-12 13:15 ALL_CRT_JOB.sql |
eheejung eheejung 0 eheejung eheejung 0 2019-07-12 13:15 ALL_CRT_LIB.sql |
eheejung eheejung 0 eheejung eheejung 0 2019-07-12 13:15 ALL_CRT_LINK.sql |
eheejung eheejung 0 eheejung eheejung 0 2019-07-12 13:15 ALL_CRT_REP.sql |
eheejung eheejung 0 eheejung eheejung 0 2019-07-12 13:15 ALL_CRT_SEQ.sql |
$ cat headconnect
--############################ |
--############################ |
table (
|
|---|
| 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 $ cat | Code Block |
|---|
| $ cat SYS_DEPARTMENTS.dat |
1001,"RESEARCH DEVELOPMENT DEPT |
1 York
1002,"RESEARCH DEVELOPMENT DEPT |
2 Sydney DEVELOPMENT DEPT Osaka ASSURANCE DEPT Seoul SUPPORT DEPT London DEPT Peking DEPT Brasilia DEPT Alto |
|---|
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.
...