Most frequently used commands in HANA database level and automatic back up

[Former Member]

Hi HANA guru,

1. Would you provide some pointer on Most frequently used commands in OS ( linux) with respect to HANA

2. Is there any automatic back up process or etc

Regards,

Manoj.

[tomas-krojzl · Accepted solution]

Hello,

2. Is there any automatic back up process or etc

I would recommend this blog:

And following threads:

You can also find some information in SAP HANA Backup and Recovery Guide:

http://help.sap.com/hana/hana1_imdb_backup_en.pdf

Tomas

[SK-EA]

Manoj,

Check the below OSS note for scheduling SAP Hana Database backups

Note 1651055 - Scheduling SAP HANA Database Backups in Linux

Check the attachments to this OSS note for details of the script.

Another options would be scheduling cron jobs with hdbsql BACKUP DATA commands. More details can be found in section "Performing a Data Backup in Batch Mode" of Hana Administration guide.

As Tomas explained, you do not have frequent activities to be performed at OS level in SAP Hana server.

Hope this helps.

Regards,

Srinivas K.

[petr_solberg]

Hi All,

this might be useful:

SAP Hana Commands and Command Line Tools And SQL Reference Examples For Netweaver Basis Administrato...

Andy.

[tomas-krojzl]

Hello,

1. Would you provide some pointer on Most frequently used commands in OS ( linux) with respect to HANA

Not sure what exactly have in mind... Technically you do not need to do much on OS level when working with SAP HANA database... (Just regular Linux administration tasks that are SAP HANA independent..)

Tomas

[Former Member]

Dear Tomas,

tail -f <tracefile> like in any db.

Like in HANA is there any

Regards,

Manoj

[tomas-krojzl]

Hello,

trace files can be found here:

/usr/sap/<SID>/HDB<system number>/<hostname>/trace

you can also access them from HANA Studio:

1.) Choose system - right click and choose Administration

2.) Go to tab Diagnostic files

3.) If needed you can also activate trace by clicking on "Configure trace" (you need SP03 for this)

Tomas