SAP HANA revision upgrade step-by-step
Introduction. Basis Administration in the Age of SAP HANA requires new skills from SAP Basis Administrators. One of them HANA DB Maintenance & Upgrade. For example, DB-revisions should be installed at regular intervals to avoid errors and to keep your Database up to date
Prerequisites for HANA DB Upgrade.
Corrections are shipped in the form of Revisions and Support Packages Stack (SPS) of the product’s components. This blog post about Revisions.
Find correction on SAP Launchpad. For example, if you want upgrade Revision Rev037_1 to Rev037_3
NB: For HANA DB Rev037_3 ->LCAPPS plugin must be 037.03 version too
NB: Very important moment. Structure after extracting procedure must be separated
NB: stopsap j2ee *for Java systemsstopsap R3 *for ABAP systems
NB: su <sidadm>/usr/sap/<sid>/<sid><instance>/HDB stopNB: Average time for HANA DB stopping: 5-20 minutes (this measure depends on the DB-size).
NB:For example OS-path may be:/<path>/SAP_HANA_DATABASE/hdblcm –ignore=check_signature_file
NB: Installation process must be from SYSTEM (SAP HANA initial DB super user)If you lock this user for security reasons ->Unblock SYSTEM user for this task
NB: /usr/sap/<sid>/<sid><instance>/HDB version
NB:Result must be – no errors reported.
SAP BASIS Routine task with examples from real life was provided
Related Notes / Guides:
SAP HANA Administration Guide 2.0 SPS 03
SAP Note 1948334 – SAP HANA Database Update Paths for SAP HANA Maintenance Revisions
2378962 – SAP HANA 2.0 Revision and Maintenance Strategy
Correction about this statement:
NB: Installation process must be from SYSTEM (SAP HANA initial DB super user)
If you lock this user for security reasons ->
Unblock SYSTEM user for this task
I am rechecked SAP HANA Administration Guide.
"The SYSTEM user is not required to update the SAP HANA database system;
a lesser-privileged user can be created for this purpose."
Also does the Hana Client has to be updated?
Thank you so much for the question
This is not mandatory but very eligible step
What about backout procedure?
How to avoid any issues in case of revision upgrade process failure?
Backup procedure mandatory
Look at my separate blog-post - https://blogs.sap.com/2019/12/20/sap-hana-backup-via-backint-interface.-step-by-step-guide-for-veritas-netbackup./
You can also backup and the whole server too
My friendly advice look at Relax-and-Recover(ReaR) utility for this purpose.