roll-back Hana revision after upgrade

[davidebruno]

Hi all,

I have to upgrade my HANA database from rev 97 to rev 110.

I need to understand what I have to do in case of restore of the system (for example in case of error during the upgrade, or for a roll-back)

I'll do a data backup, and a backup of every file system in the host.

In case of the restore, what I have to do?

Because I think that I can't restore the data backup with any pre-activity, because the system will be upgraded (or in case of error, in half!)

thank you and kind regards

Davide Bruno

[Former Member · Accepted solution]

Hi Davide.

If you take a look at the SAP_HANA_INSTALLATION_GUIDE, there are 3 options to do your upgrade:

Update an SAP HANA System Using the Graphical User Interface

Update an SAP HANA System Using the Command-Line Interface

Update an SAP HANA System Using the Web User Interface

The prerequisites are a few, and the most important, is the backup.

1. You are updating to a new SPS from an installation medium or you have prepared for update, either in the SAP HANA studio or manually.
2. You have stopped the data replication.
3. You have performed a system backup. Also note that during the update there is a business downtime for your SAP HANA system
4. You know the <sid>adm, and database administrator passwords.
5. You have applied a valid license key for the SAP HANA system.

This is some info nice to have:

The steps I do before upgrade SAP HANA.

- Full Database Backup in SAP HANA Studio.

- Backup of the configuration files (it has to be done mannually)

As for errors in upgrade, if it fails at half point, I think that the systems does a rollback and  goes back to rev 97.

if you need to recover using command line:

RECOVER DATABASE - SAP HANA SQL and System Views Reference - SAP Library

RECOVER DATABASE UNTIL TIMESTAMP '2015-10-22 15:00:00' USING DATA PATH ('/backup/THURSDAY/') USING LOG PATH ('/backup/logs1/','/backup/logs2/')

I already did several upgrades, all went fine and very quickly.

Best regards.

Osvaldo Dias Ferreira

[davidebruno · Accepted solution]

Thanks for your answer !

My doubt is regarding the file system of the instance: we have to restore? I have to do other activity?

thank you

[Former Member · Accepted solution]

Hi.

If you do a backup full with SAP HANA Studio, the backup data goes to a different Filesystem (SAP best practices).

/hana

/log

/backup

When you do the restore you have to give the file location of the data backup done earlier (/backup).

So, no restore of the filesystem is needed.

Take a look at this SAP doc. (Recovery = page 34,...,...)

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e09dae76-27a3-3210-828f-ce9de54e6...

Regards.

Osvaldo Dias Ferreira

[davidebruno · Accepted solution]

ok regarding the databackup I have no doubt,

but, on file system there is no binary file modified after a restore?

the directory /usr/sap/<SID>/HDB<NUM>/exe for example..

I think that after an upgrade, if I want ro roll-back I have to restore it to the older version

or not?

thank you for your help!

[former_member182967 · Accepted solution]

Hi David,

HANA software itself is changed during update.

You'd better make a backup of folder /hana/shared and /usr/sap/SID.

Regards,

Ning

[Former Member · Accepted solution]

Hi Davide.

Yes, Ning is correct.

Yesterday I did your scenario in a lab system and yes /hana/shared and /usr/sap/SID binaries are changed during the Upgrade.

Sorry for my late response.

Regards.

Osvaldo Dias Ferreira

[davidebruno]

thank you very much all!

this community is very usefull