SAP HANA數據庫備份方式與工具

備份的類型

備份的工具

1. SAP HANA studio

   HANA studio - 右鍵SID - Backup and Recovery - Back Up system 備份完整數據庫或者打開Open Backup Console選擇備份類型 

   這里的備份文件命名自動生成，如果是同樣的備份路徑，上一次備份將會被覆蓋

   
   

2. SAP HANA cockpit

   從studio進入或者打開鏈接

   https://eccqas:4300/sap/hana/admin/cockpit/

   http://eccqas:8000/sap/hana/admin/cockpit/

   SAP HANA Backup - Create Backup創建一個backup馬上備份

   
   

   或者創建一個schedule周期調度，注意Backup Prefix，調度名字，周期

   
   

        如果看不到SAP HANA Backup磁貼，那么需要給登錄的HANA數據庫用戶授權

        sap.hana.backup.roles::Administrator

        如果看不到Create Schedule，那么需要給登錄的HANA數據庫用戶授權

        sap.hana.backup.roles::Scheduler

        與之相關的操作角色是sap.hana.backup.roles::Operator

    注意：調度器默認是不激活的狀態，創建調度計劃后會提示

    Backups cannot be scheduled, because the XS Job Scheduler is not active. For more information, see SAP HANA Administration Guide

    則需要到URL激活 enable：http://eccqas:8000/sap/hana/xs/admin/jobs/#

    并且需要角色sap.hana.xs.admin.roles::JobSchedulerAdministrator，否則是灰的無法激活

    作業管理角色：sap.hana.xs.admin.roles::JobAdministrator

    3.Native SQLDBA Cockpit for SAP HANA

    過程參考：http://tecadmin.net/backup-sap-hana-database-using-command-line/#

    #su - sidadm
    hdbsql
    \c -i 00 -n eccqas:30015 -u system -p Bm2015##

    help:

  hdbsql=> \h

 \? or \h[elp]  show help on internal slash commands

 \q[uit]        quit HDBSQL

 \c[onnect]     -i <instance number>

                -n <host>[:<port>]

                -d <database name>

                -u <user_name>

                -p <password>

                -U <user_store_key>

                connecting to the database

 \di[sconnect]  disconnecting from the database

    help.sap.com：https://help.sap.com/saphelp_hanaplatform/helpdata/en/75/a06c444e9a4b3287a46a6a40b4ee69/content.htm

    可以在系統下用crontab 

    complete 全備：hdbsql -U USER4BACKUP "backup data using file ('complete_backup_prefix')"

    incremental增備：hdbsql -U USER4BACKUP "backup data INCREMENTAL using file     ('incremental_backup_prefix')"

    differential差備：hdbsql -U USER4BACKUP "backup data DIFFERENTIAL using file     ('differential_backup_prefix')"

    異步最后加上ASYNCHRONOUS

1950261 - SAP HANA Database Backup Policy Recommendations and Regular Backup Script

create user <Backup User Name> password "<Password>";
alter user <Backup User Name> DISABLE PASSWORD LIFETIME;
grant backup operator to <Backup User Name>;

hdbuserstore set USER4BACKUP localhost:3<Instance Number>15 <Backup User Name> <Password>

note已經有標準shell腳本

#!/bin/sh
#/* Backup script */
source $HOME/.bashrc
date="$(date +"%Y-%m-%d")"
time="$(date +"%Y-%m-%d %H:%M:%S")"
backup="backup data using file ('$date')"
echo "daily backup  :"  $time  "Start" >> $DIR_INSTANCE/backup.log
$DIR_EXECUTABLE/hdbsql -U USER4BACKUP -x $backup
time="$(date +"%Y-%m-%d %H:%M:%S")"
echo "daily backup  :"  $time  "End" >> $DIR_INSTANCE/backup.log

周日全備，周一至周六增備

#!/bin/sh
#/* Complete Backup script_completebackup.sh*/
source $HOME/.bashrc
date="$(date +"%Y-%m-%d")"
time="$(date +"%Y-%m-%d %H:%M:%S")"
backup="backup data using file ('$date.complete')"
echo "daily backup  :"  $time  "Start" >> $DIR_INSTANCE/backup.log
$DIR_EXECUTABLE/hdbsql -U USER4BACKUP -x $backup
time="$(date +"%Y-%m-%d %H:%M:%S")"
echo "daily backup  :"  $time  "End" >> $DIR_INSTANCE/backup.log

#!/bin/sh
#/* Incremental Backup script_incrementbackup.sh */
source $HOME/.bashrc
date="$(date +"%Y-%m-%d")"
time="$(date +"%Y-%m-%d %H:%M:%S")"
backup="backup data INCREMENTAL using file ('$date')"
echo "daily backup  :"  $time  "Start" >> $DIR_INSTANCE/backup.log
$DIR_EXECUTABLE/hdbsql -U USER4BACKUP -x $backup
time="$(date +"%Y-%m-%d %H:%M:%S")"
echo "daily backup  :"  $time  "End" >> $DIR_INSTANCE/backup.log

    第三方備份工具將file改成backint

  4.通過SAP HANA Cockpit備份HANA數據庫

    事務碼：DBACOCKPIT 或者DB13，