[MaxDB] 백업 히스토리

개요

 

구성환경

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