Shulou(Shulou.com)06/01 Report--

Type of backup

OptionDescriptionComplete Data BackupA data backup includes all the data structures that are required to recover the database.Differential Data BackupDifferential backups store all the data changed since the last full data backup.Incremental Data Backup

An incremental backup stores the data changed since the last full data backup or the last

Delta backup (incremental or differential).

Tools for backup

SAP HANA studio

HANA studio-right SID-Backup and Recovery-Back Up system backup the full database or open Open Backup Console to select the backup type

The backup file name here is generated automatically. If it is the same backup path, the last backup will be overwritten.

SAP HANA cockpit

Enter or open a link from studio

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

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

SAP HANA Backup-Create Backup create a backup backup now

Or create a schedule cycle schedule, pay attention to Backup Prefix, schedule name, cycle

If you do not see SAP HANA Backup tiles, you need to authorize the logged-in HANA database user

Sap.hana.backup.roles::Administrator

If you do not see the Create Schedule, you need to authorize the logged-in HANA database user

Sap.hana.backup.roles::Scheduler

The associated operational role is sap.hana.backup.roles::Operator

Note: the scheduler is inactive by default and will be prompted after the scheduling plan is created

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

You need to activate enable: http://eccqas:8000/sap/hana/xs/admin/jobs/# in URL.

And the role sap.hana.xs.admin.roles::JobSchedulerAdministrator is required, otherwise it is gray and cannot be activated.

Job Management role: sap.hana.xs.admin.roles::JobAdministrator

3.Native SQLDBA Cockpit for SAP HANA

Process reference: 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

-n [:]

-d

-u

-p

-U

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

You can use crontab under the system

Complete complete: hdbsql-U USER4BACKUP "backup data using file ('complete_backup_prefix')"

Incremental add: hdbsql-U USER4BACKUP "backup data INCREMENTAL using file ('incremental_backup_prefix')"

Differential differential: hdbsql-U USER4BACKUP "backup data DIFFERENTIAL using file ('differential_backup_prefix')"

Async and finally add ASYNCHRONOUS

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

Create user password ""

Alter user DISABLE PASSWORD LIFETIME

Grant backup operator to

Hdbuserstore set USER4BACKUP localhost:315

Note already has standard shell scripts

#! / bin/sh#/* Backup script * / source $HOME/.bashrcdate= "$(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 $backuptime= "$(date +"% Y-%m-%d% H) :% time% S ")" echo "daily backup:" $time "End" > $DIR_INSTANCE/backup.log

Full availability on Sunday and additional equipment from Monday to Saturday

#! / bin/sh#/* Complete Backup script_completebackup.sh*/source $HOME/.bashrcdate= "$(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 $backuptime= "$(date +"% Y- % echo% d% H:%M:%S ")" echo "daily backup:" $time "End" > > $Dirty backup data INCREMENTAL using file backup data INCREMENTAL using file ('$date') "echo" daily backup : "$time" Start "> > $DIR_INSTANCE/backup.log$DIR_EXECUTABLE/hdbsql-U USER4BACKUP-x $backuptime=" $(date + "% Y-%m-%d% H:%M:%S") "echo" daily backup: "$time" End "> > $DIR_INSTANCE/backup.log

Third-party backup tools change file to backint

4. Backing up the HANA database through SAP HANA Cockpit

Transaction code: DBACOCKPIT or DB13

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.