Skip to Content

SAP HANA 1.0 System Refresh for BW

Hello,

We have HANA distributed environment where HANA database share 4 hosts (PRD) and 3 hosts (QAS).
We are planning for system refresh and hence we have some queries :

- We are following the Note (2093572 - SAP HANA Migration from Multi-Node to Single-Node) and have thought of using similar procedure of adding and removing the services. I hope this is correct way?

- Any reference blog for System Refresh for scenario as above will be helpful.

- How do I calculate the total required size on QAS system? Is it fine if I consider backup size of PRD and then resize QAS accordingly? OR I have to check and match the data/log volume size for each service including additionally added service?

- Also, the Note 2093572 mentions about REORG may I know why this is required and How long the execution takes?

Thanks in advance.

Regards,
Fernando

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Sep 27, 2018 at 02:46 AM

    "- Any reference blog for System Refresh for scenario as above will be helpful."

    -> also check note 1844468 - Homogeneous system copy on SAP HANA

    "- How do I calculate the total required size on QAS system? Is it fine if I consider backup size of PRD and then resize QAS accordingly? OR I have to check and match the data/log volume size for each service including additionally added service?"

    -> In my view, consider the backup size and corresponding whole size for data volume

    "Also, the Note 2093572 mentions about REORG may I know why this is required and How long the execution takes?"

    -> Please consider to check note 2081591 - FAQ: SAP HANA Table Distribution

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 26, 2018 at 09:04 PM

    Hi Fernando,

    This is good note to start 2093572 with.

    You can follow this note and perform the activity.Regarding REORG it might be due to Multi host,In BW multi host tables are distributed on differnt host with TABLE PLACEMENT rule . REORG might be take care of that.


    2334091 - BW/4HANA: Table Placement and Landscape Redistribution

    1908075 - BW on SAP HANA: Table placement and landscape redistribution

    Best Regards,

    Atul

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 02, 2018 at 03:15 PM

    Hello Tong/Atul, Thanks for your reply.

    For BW refresh for distributed host scenario i have further queries :

    1) Note 2093572 mentions about addition and removing of services (e.g. indexserver, stats...) on the target host for a perfect restoration on QAS from production backup.
    Hence if I add (assume) an indexserver service to QAS target host it will have its data and log volumes. correct?
    Secondly, what are the prerequisite or mandatory steps before I remove the additional services on QAS, after restore?

    2) Note 1908075 BW on SAP HANA: Table placement and landscape redistribution : suggested by @Atul Kumar Jain
    I see that these note comes with attachment as per the release and scale-out senario, is this necessary for BW refresh and who should take care of this tableplacement is it the database administrator or a BW consultant?

    Thanks.

    Regards,
    Fernando

    Add comment
    10|10000 characters needed characters exceeded