Page 1 of 1

HANA backup and restore to different host

Posted: Thu Mar 07, 2013 10:37 pm
by Hay Bouten
This post shows how to backup a HANA database on host A and theb restore that database backup to host B.

Backup HANA on host A

Host A: In the context menu select Back Up to start the backup wizard.
HANA_Backup001.png
HANA_Backup001.png (147.81 KiB) Viewed 17150 times
Host A: Specify the storage location and the name prefix for the backup files and press [Next >]
HANA_Backup002.png
HANA_Backup002.png (108.96 KiB) Viewed 17150 times
Host A: Check the backup information and when all is correct press [Finish]
HANA_Backup003.png
HANA_Backup003.png (69.55 KiB) Viewed 17150 times
Host A: The backup is running.......
HANA_Backup004.png
HANA_Backup004.png (64.25 KiB) Viewed 17150 times
Host A: ....... and finished succesfully.
HANA_Backup_005.png
HANA_Backup_005.png (30.35 KiB) Viewed 17149 times
Restore HANA on host B

Host B: In the context menu select Recover to start the recovery wizard.
HANA_BackupRestore_001.png
HANA_BackupRestore_001.png (149.71 KiB) Viewed 17150 times
The recovery can only start after the database had been shutdown. Press [OK] to shutdown the database.
HANA_BackupRestore_002.png
HANA_BackupRestore_002.png (14.19 KiB) Viewed 17150 times
The Recovery Wizard is collecting system data.
HANA_BackupRestore_003.png
HANA_BackupRestore_003.png (23.54 KiB) Viewed 17150 times
Select the required recovery method. In this example I select the option "Recover the database to a specific data backup". Click [Next >] to continue.
HANA_BackupRestore_005.png
HANA_BackupRestore_005.png (65.38 KiB) Viewed 17150 times
Specify the location were you stored the backup files from host A. Click [Next >] to continue.
HANA_BackupRestore_007.png
HANA_BackupRestore_007.png (65.57 KiB) Viewed 17150 times
The license key can be applied during the restore. This can also be done after the recovery. Click [Next >] to continue.
HANA_BackupRestore_008.png
HANA_BackupRestore_008.png (55.76 KiB) Viewed 17150 times
Review the recovery information displayed. If it is correct the click [Finish] to start the recovery.
HANA_BackupRestore_009.png
HANA_BackupRestore_009.png (128.08 KiB) Viewed 17150 times
The recovery process is initializing ......
HANA_BackupRestore_010.png
HANA_BackupRestore_010.png (31.4 KiB) Viewed 17150 times
...... recovery is running ......
HANA_BackupRestore_011.png
HANA_BackupRestore_011.png (51.8 KiB) Viewed 17150 times
...... recovery finished successfully. Click [Close] to exit the recovery wizard.
HANA_BackupRestore_012.png
HANA_BackupRestore_012.png (30.36 KiB) Viewed 17150 times