Steps to duplicate HANA database
Can someone assist with steps on how to export a HANA database for import on another existing HANA database? I need to create a clone.
From HANA studio the SYSTEM user don't have access to the SAP schema. And If login to studio with the SAP schema owner, I get a ": insufficient privilege: not authorized" message if I try to export my own schema.
Lars Breddemann replied
There is no predefined HANA user that automatically has every privilege and all access to the data.
You can create such an import/export user, but it especially when it comes to object ownership this way of "system copy" will not deliver an identical copy.
The SAP system copy tools (e.g. SUM) use the SAP-schema logon to export/import data and only copy SAP<SID>-objects. For a SAP Netweaver system copy that would be my recommendation to go ahead.
Another pro-point for this approach is that the SUM tools are way better instrumented and task oriented than the bare-bone EXPORT/IMPORT tools.
For all practical matters there is no way to create a full SAP HANA export. At least core objects like the SAP HANA user management etc. won't be exported.
For the repository... I haven't tried it, but my guess would be that the import would lead to issues.