Backup strategy for Hana database

[Former Member]

Hi all,

I am new to Hana and our company is planning a Hana project.

I am the dba for this project.

I have a few questions about backup strategy in Hana env.

1. storage snaphost

In our current oracle env, we do a bcv copy at storage level (snapshot), before we do this, we put the db in hot backup mode, In Hana,   can we still use the same strategy?

Based on my current understanding of Hana, every 5-min it flush the memory to the disk which is a consistent image.

So ,we just need to do a snapshot for storage ( without  doing anything like put db in hot backup mode as we did  in oracle env)? Am I right?

1. the db-level backup

we plan to backup the db first to the local file system and keep the copy there for 1 or 2 weeks and then move the tape.

Our production  environment will be a 4-node cluster environment.

The non-prod will be single node.

is there anything different between single node and cluster env in terms of backup/recover ?

Thanks,

Lily

[AtulKumarJain]

Hi Lily,

Please check

http://www.saphana.com/docs/DOC-1220

http://scn.sap.com/docs/DOC-35621

and also check

1642148   FAQ: SAP HANA Database Backup & Recovery

1730998   Unrecommended versions of backup tools

it could answer your question.

Best Regards

Atul

[Former Member]

Hi Atul,

Thanks for your reply.

one more question,   so far, what kind of third-party backup tools are certified by sap hana?

We are using data protector and we want to know if it is certified or not.

Thanks,

Lily

[Former Member]

Hi Lily,

Symantec Netbackup 7.5 is currently certified for Hana . there are other vendors who are in process of getting  certified for hana . Please find attached link with details .

http://www.saphana.com/community/blogs/blog/2012/12/19/backint-for-sap-hana-certification-available-...

Thanks,

Kiran .

[naveen_kumar1]

Hi Lily,

Backint Backs up the database using a third-party backup tool.

Each SAP HANA service starts the Backint agent and sends the

backup data to the third-party backup tool.

Symantec NetBackup   - SAP Certified.

Third-party backup tools communicate with the SAP HANA
database through the Backint for SAP HANA interface. Backint for SAP
HANA uses pipes to back up the content of the database and performs
all the actions needed to write the backup data to external storage.

Note that backup tools using Backint for SAP HANA must be certified
by SAP. For more information see SAP Note 1730932.

Backint for HANA is available as of SAP HANA Version 1.0 SPS05.

Regards,

Naveen.