on 10-06-2015 4:43 AM
Hi All,
How do I restore SYSTEMDB backup from HANA A (MDC) to HANA B (MDC)?
I've done full data backup of SYSTEMDB from HANA A and when I go to HANA B in HANA studio I can't restore it using the full data backup from HANA A.
Understand that I only be able to restore to most recent backup, so what should I backup from HANA A, in order for me to restore / copy to HANA B?
Thank you,
Regards,
Ura
Hi Ura,
Is there a particular reason you would like to restore SYSTEMDB backup?
Is the SID at source and destination HANA Systems the same?
The only scenario you should be required to recover the SYSTEMDB is from Production Appliance SID: ABC to a HA/DR Appliance with the same SID:ABC and it should work provided you have the identical Multitenant systems underneath
SYSTEMDB backup contains the underlying Multitenant Database's properties in it so it would not help if a SYSTEMDB with a set of tenant Database's is being restored to another Appliance with non identical set of tenant Database's
Hope this helps
Sunil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sunil,
I wanted to perform restoration test, while keeping in mind that both HANA SID is different.
by restoring SYSTEMDB from backup, we would recover all the relevant tenant information that stored during backup and we then we can proceed to restore it using the tenant backup?
Thank you,
Ura
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
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.