on 11-24-2013 6:34 PM
Experts:
We setup a demo hana system and the database copied into is about 2TB.
We notice it takes about 5 hours to backup it to file system.
It is too slow.
1) if when apply note 1697613, can we start the applications first then do a backup?
2) any way to speed up the backup, what is the normal speed for hana backup?
3) if I use backing to 3-rd party utility, can it improve speed?
Thanks!
note 1697613:
If you want to restart SAP HANA XS, proceed as follows:
l
Stop all the applications that use the database.
l
Activate SAP HANA XS. When you do this, specify the host on which you want SAP HANA XS to run:
ALTER SYSTEM ALTER CONFIGURATION ('daemon.ini', 'host', '<host name>') SET ('xsengine','instances') = '1' WITH RECONFIGURE
SAP HANA XS is started automatically, and the volumes of the service are created automatically.
l
Create a new data backup.
l
Start the applications that use the database.
1) if when apply note 1697613, can we start the applications first then do a backup?
You don't need to wait until the backup completes to start the applications.
You can trigger the backup and start the applications.
2) any way to speed up the backup, what is the normal speed for hana backup?
The DB backup is taken to the filesystem level and then the backup set or the files are backed up to the backup server. Eg: TSM
If the duration of backup taken to the filesystem level is not acceptable then I would check that with SAP Support. Have you tried taking a backup using the Studio Manager manually to see whether it takes the same time ?
3) if I use backing to 3-rd party utility, can it improve speed?
This is a question to be answered by the 3rd party solution provider. For sure there should be ways to optimize the speed of the backups by using multiple channels and other options as well.
Regards
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am not sure the standard speed of the backup to disk. But you can refer to these notes and raise an OSS message to SAP for assistance.
1835075 - Analyze backup and recovery performance issues
1842096 - HANA Backup & Restore Performance
1642148 - FAQ: SAP HANA Database Backup & Recovery
Regards
RB
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.