We can perform manual backups on SAP HANA database as and when required using SQL commands or by SAP HANA Studio. Backup commands are
executed on a SAP HANA database system as a user having BACKUP_ADMIN privileges.
Manual Backup example as below
-----------Command : BACKUP DATA ALL USING FILE
('COMPLETE')----------------------
hdbsql -i 02 -u system -p a1234 "backup data using file ('xyz/hdb/SID/backup/data')"
hdbsql -i 02 -u system -p a123 "BACKUP DATA ALL USING FILE ('xyz/hdb/SID/backup/data/BEFORE_UPGRADE_FULL')"
hdbsql -i 02 -u system -p a1234 "backup data using file ('xyz/hdb/SID/backup/data')"
hdbsql -i 02 -u system -p a123 "BACKUP DATA ALL USING FILE ('xyz/hdb/SID/backup/data/BEFORE_UPGRADE_FULL')"
Using above SQL command we can perform data backup for
a HANA instance which creates data backup files for every service.
Data backup files will be labeled with leading string ‘COMPLETE’. Therefore the
following backup files will be created:
No comments:
Post a Comment