DBMS/MaxDB
[MaxDB] 백업 히스토리
날았다 고양이
2020. 9. 3. 22:15
반응형
개요
구성환경
MaxDB 7.9.10, CentOS 7.6
예) DATA_BK1(데이타 백업), LOG_BK1(로그 백업)
| dbmcli on maxdb>backup_start DATA_BK1 OK dbmcli on maxdb>backup_start LOG_BK1 OK dbmcli on maxdb>backup_history_list 5F4E2F820005| |HISTLOST |2020-09-01 20:24:50| |2020-09-01 20:24:50| | | | | | | | 0| | 5F4E2F820006| |HISTLOST |2020-09-01 20:24:50| |2020-09-01 20:24:50| | | | | | | | 0| | 5F4E2F88000D|DAT_000000001|SAVE WARM|2020-09-01 20:24:56|2020-09-01 20:24:56|2020-09-01 20:24:56|2020-09-01 20:24:56| 435| |NO |INITIALBACKUP | 392| 1| 0| | 5F5091EA0016|DAT_000000002|SAVE WARM|2020-09-03 15:49:14|2020-09-03 15:49:14|2020-09-03 15:49:14|2020-09-03 15:49:14| 520| |NO |DATA_BK1 | 392| 1| 0| | 5F50CF44001A|LOG_000000001|SAVE WARM|2020-09-01 20:24:50|2020-09-03 15:49:14|2020-09-03 20:11:00|2020-09-03 20:11:00| 0| 520| |LOG_BK1 | 536| 0| 0| | --- dbmcli on maxdb>backup_start LOG_BK1 OK dbmcli on maxdb>backup_history_close dbmcli on maxdb>backup_history_list 5F4E2F820005| |HISTLOST |2020-09-01 20:24:50| |2020-09-01 20:24:50| | | | | | | | 0| | 5F4E2F820006| |HISTLOST |2020-09-01 20:24:50| |2020-09-01 20:24:50| | | | | | | | 0| | 5F4E2F88000D|DAT_000000001|SAVE WARM|2020-09-01 20:24:56|2020-09-01 20:24:56|2020-09-01 20:24:56|2020-09-01 20:24:56| 435| |NO |INITIALBACKUP | 392| 1| 0| | 5F5091EA0016|DAT_000000002|SAVE WARM|2020-09-03 15:49:14|2020-09-03 15:49:14|2020-09-03 15:49:14|2020-09-03 15:49:14| 520| |NO |DATA_BK1 | 392| 1| 0| | 5F50CF44001A|LOG_000000001|SAVE WARM|2020-09-01 20:24:50|2020-09-03 15:49:14|2020-09-03 20:11:00|2020-09-03 20:11:00| 0| 520| |LOG_BK1 | 536| 0| 0| | 5F50D043001F|LOG_000000002|SAVE WARM|2020-09-03 20:11:00|2020-09-03 20:11:00|2020-09-03 20:15:15|2020-09-03 20:15:15| 521| 522| |LOG_BK1 | 16| 0| 0| | --- dbmcli on maxdb> |
컬럼 정보
| key | LABEL | ACTION | STAMP1 | STAMP2 | START | STOP | FIRSTLOG | LASTLOG | LOG | MEDIA | PAGES | VOLUMES | RC | ERROR |
예) 특정 컬럼(MEDIA,START,STOP) 정보만 보기
| dbmcli on maxdb>backup_history_list -c MEDIA,START,STOP ........(중략) DATA_BK1 |2020-09-03 15:49:14|2020-09-03 15:49:14| LOG_BK1 |2020-09-03 20:11:00|2020-09-03 20:11:00| LOG_BK1 |2020-09-03 20:15:15|2020-09-03 20:15:15| |
LABEL :
참조 : https://maxdb.sap.com/doc/7_7/44/92ba6212f54c20a85fca1e18761541/content.htm
반응형