Question Re: Restoring Sap Hana cloud instance using a database ba... in Technology Q&A

Restoring Sap Hana cloud instance using a database backup file

Dipnesh — Thu, 03 Oct 2024 08:35:28 GMT

Hello experts

i have a backup file of a database of a particular SAP BTP trial account now i wants to restore this database over Sap Hana cloud instance in a new SAP BTP trial account .

i have explored Sap community to find solution and guidance .

in that journey i got some articles and tutorials.

1.) https://community.sap.com/t5/technology-blogs-by-sap/clone-sap-hana-database-instance-via-template-based-cloning/ba-p/13617031

This tutorial help us to clone SAP HANA database instance via template based cloning.

but this guidance only helps me to clone SAP HANA database instance within same trial account .

2.) https://community.sap.com/t5/technology-q-a/hana-database-explorer-import-catalog-objects-in-hdi-container/qaq-p/12235488

This guidance material helps me to import catalog objects in HDI container.

again ,this solution is limited within single trial account because we can only import and export SAP HDI(Hana deployment infrastructure) Container for copy purposes within single trial account.

Both tutorial covers cloning Hana cloud instance and importing and exporting HDI container but both are limited within single SAP BTP trial account and i wants to restore Database over sap Hana cloud instance using database back up file of different trial account.

@thomas_jung @qmacro , @MioYasutake ,@gregorw, please help me How to restore database over SAP HANA cloud instance using backup file of a database.

Re: Restoring Sap Hana cloud instance using a database backup file

RobertWaywell — Thu, 03 Oct 2024 15:16:56 GMT

How did you create your database backup from the trial HANA instance? Backup and restore of SAP HANA Cloud instances is fully managed by SAP HANA Cloud. There is no option for creating an external backup.

Re: Restoring Sap Hana cloud instance using a database backup file

AlexPJ — Mon, 07 Oct 2024 09:54:46 GMT

SAP HANA Cloud recovery to another instance is on the roadmap for Q4/2024:
https://roadmaps.sap.com/board?PRODUCT=73554900100800002881&range=CURRENT-LAST#;INNO=000D3ABE772D1EED95CF5E8665C8E312
I have no idea whether this will be supported with a Trial Account.
You may want to have a look into the HDI Container Export/Import functionality (though I do not know whether this works in a Trial Account):
Export/Import an SAP HDI Container for Copy Purpos... - SAP Community

Re: Restoring Sap Hana cloud instance using a database ba...

Dipnesh — Wed, 09 Oct 2024 11:48:12 GMT

Thanks @AlexPJ @RobertWaywell for your reply , i have followed this article for exporting Hana HDI container for copy purposes

https://help.sap.com/docs/SAP_HANA_PLATFORM/3823b0f33420468ba5f1cf7f59bd6bd9/36a5547af0304ee29e964abf27468f52.html.

CREATE COLUMN TABLE <MySchema>.EXPORT_TABLE LIKE _SYS_DI.TT_CONTAINER_EXPORT;
GRANT INSERT, SELECT ON <MySchema>.EXPORT_TABLE TO C1#DI;
CALL _SYS_DI#G.EXPORT_CONTAINER_FOR_COPY
('C1', <MySchema>, 'EXPORT_TABLE', _SYS_DI.T_NO_PARAMETERS, ?, ?, ?);
EXPORT <MySchema>.EXPORT_TABLE AS BINARY INTO '<export_path>'
WITH REPLACE NO DEPENDENCIES;

as per article ,this SQL code exports HDI container. I am using using sap BTP trail account ,in this environment what should be value of '<export_path>' .

@thomas_jung @qmacro , @MioYasutake ,@gregorw,

Re: Restoring Sap Hana cloud instance using a database ba...

RobertWaywell — Wed, 09 Oct 2024 20:24:49 GMT

The equivalent SAP HANA Cloud documentation is here: https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-deployment-infrastructure-hdi-reference/import-sap-hdi-container-for-copy-purposes

That should provide you with the necessary information to import the HDI container that you had previously exported.

Note that exporting an HDI container can be used as a method to backup an individual HDI container, but that is quite different from creating a full database backup. The good news is that SAP HANA Cloud, SAP HANA database supports importing HDI containers.

Re: Restoring Sap Hana cloud instance using a database ba...

AlexPJ — Thu, 10 Oct 2024 07:08:16 GMT

You followed documentation that is for HANA Platform, i.e. for HANA on-premise instances. This won't work with HANA Cloud.
Use the documentation for HANA Cloud, HANA databases instead, for instance Importing and Exporting with Amazon Web Services | SAP Help Portal or Export an SAP HDI Container for Copy Purposes to a Cloud Store