v11 SAP HANA on Linux

Last post 01-09-2019, 11:30 AM by ssunkara. 18 replies.
Sort Posts: Previous Next
  • v11 SAP HANA on Linux
    Posted: 12-28-2016, 11:48 AM
    Hi all,

    This is my first time dealing with SAP HANA. Target server is a single node server. I would like to configure and run backup using commcell console. Appreciate if anyone here could help to clarify my steps to configure.

    1) Install SAP HANA on client server

    2)
    a) Log on to the SAP HANA database by using the following command:

    b) su - <databaseadm>

    c) Create the /usr/sap/<SID>/SYS/global/hdb/opt/ directory and change the group owner to the SAP HANA user group.

    d) Create a symbolic link at /usr/sap/<SID>/SYS/global/hdb/opt/ by running the following commands:

    cd /usr/sap/<SID>/SYS/global/hdb/opt

    ln –s /opt/commvault/iDataAgent/backint hdbbackint

    e) Verify that there is a symbolic link from

    the /usr/sap/<SID>/SYS/global/hdb/opt/hdbbackint directory to

    the /opt/commvault/iDataAgent/backint directory.

    2) Create a SAP HANA pseudo client.
    3) Create instance, subclient (or use default)
    3) Configuring SAP HANA Persistent Log Backups with 2 registries on client

    nPersistentLogBackup set to 1
    nPERSISTLOGJOBCLOSEMINS set to 360 (6 hours)

    4) Configure schedule for full backup and let the persistent log backup to run automatically. (Based on BOL, only Full, Incremental and differential available, is the log backup set from SAP HANA studio?)

    Do I still need to set parameter If I were to run backups from commcell console only?

    Thanks and have a good day.
     
    Regards,
    Lee
     
  • Re: v11 SAP HANA on Linux
    Posted: 01-03-2017, 4:03 PM
    • efg is not online. Last active: 01-17-2019, 11:59 AM efg
    • Top 10 Contributor
    • Joined on 02-02-2010
    • CommVault Tinton Falls NJ
    • Expert
    • Points 1,607

    Hi Lee,

    Yes, you still need to configure the param file for the agent.   There is only one parameter required which is the CvInstanceName parameter which is typically Instance001.

    It should look like this in the file:

    CvInstanceName

    Instance001

     

    After that you also need to configure the API in HANA studio.

    Bring up HANA Studio and open the Backup Console for the DB in question.   In the Backup configuration tab you will need to specify the parameter file location.   The file should be located under CV install/iDataAgent (Typically this is /opt/commvault/iDataAgent/param) and then linked to a directory called hdbconfig under the opt directory (where the hdbbackint link is located)

    Then in HANA studio point to the param file/link under the hdbconfig directory, enable the automatic log backups, Point log backup to use backint, and set the log backup interval (Default is 15 min).

     

    Even though you are backing up the DB using the CV console/comserver, HANA is still triggering the log backups which require the param file in order to function correctly.

    Once saved you should see the persistent log backups start in the GUI.  In my small test DB I have 1 persistent log backup job per HANA service (so there are 4 jobs running).

    Let us know if this helps.


    Ernst F. Graeler
    Product Specialist
    Applications and File Systems
  • Re: v11 SAP HANA on Linux
    Posted: 01-05-2017, 10:12 AM

    Hi Ernst,

     

    I have configured some SAP Hana Clients this week aswell.

    Is it a best practice to activate "persistant log backup"?

    -> http://documentation.commvault.com/commvault/v11/article?p=products/sap_hana/t_hana_enable_persistent_log.htm

    I am triggering full/ inc backups throughout the commcell and log backups every 15 minutes from via the SAP Hana Studio. I am wondering if the persistent log backup is needed, too.

     

    Regards,
    Marcel

  • Re: v11 SAP HANA on Linux
    Posted: 01-05-2017, 11:13 AM
    • efg is not online. Last active: 01-17-2019, 11:59 AM efg
    • Top 10 Contributor
    • Joined on 02-02-2010
    • CommVault Tinton Falls NJ
    • Expert
    • Points 1,607

    Hi Marcel,

    It's your choice.   From what I understand, SAP HANA is quite aggressive with automatic log backups, and we have seen implementations where there are literally thousands of log backup jobs triggered for a single database.   We have had a large push back from customers requesting persistent log backups where the number of log jobs can be reduced in the hundreds if not thousands by coalescing the log backups into a single persistent log job.   The basic configuration dictates that once the first job is triggered, rather than the job terminates at the completion of the log backup, the job will persist, and new log jobs coming in will be picked up by that job.   The total run time for any given log backup will be 6 hours (default timeout) with a 1 hour idle timeout in between.  Also note that there may be several persistent log backups jobs for a given database as each service would have it's own log backup.  In my lab I am seeing 4 persistent jobs for each test DB that I have.

    If you have configured the log backups with the 15 min window, you may want to configure the persistent backup in commvault.  It will make the job reporting much more managable.

    Let me know how you make out.

    Ernie


    Ernst F. Graeler
    Product Specialist
    Applications and File Systems
  • Re: v11 SAP HANA on Linux
    Posted: 02-08-2018, 2:13 PM

    By the way, did someone know how to backup logs not using the same storage policy used for full backups? As we cannot create a subclient for logs we cannot specify a different policy when logs are trigged by backint.

    We backup the database directy to tape, but for logs it's not recommended.

  • Re: v11 SAP HANA on Linux
    Posted: 02-08-2018, 2:18 PM

    You may use the storage policy that goes to disk library.

    Also Log backup are Application commandline jobs and hence you need to make sure set the proper retention as commandline jobs aged based on the days retention.

     

    Thanks,
    Srinivas

  • Re: v11 SAP HANA on Linux
    Posted: 02-08-2018, 2:24 PM

    So I cannot make different policies for full and for logs on SAP HANA?

    I have not sufficient space on disk library for full backups but I have for logs

    Thanks for the reply... 

  • Re: v11 SAP HANA on Linux
    Posted: 02-08-2018, 2:30 PM

    you can make different policies for data and log. That is my earlier reply.

    Please select storage policy with disk library and set the required days retention to make sure the logs are available for recovery and not aged.

    Let me know if this clear.

     

    Thanks,
    Srinivas

     

     

  • Re: v11 SAP HANA on Linux
    Posted: 02-08-2018, 2:58 PM

    The proble is i don't know how to trigger log backup indicating the storage policy. Do I need to define in an new param file? I cannot find the variable to define the storage policy (in this link we don't find something associated to polcies http://documentation.commvault.com/commvault/v11/article?p=products/sap_hana/r_hana_config_file_parameters.htm)

  • Re: v11 SAP HANA on Linux
    Posted: 02-08-2018, 3:05 PM
    • efg is not online. Last active: 01-17-2019, 11:59 AM efg
    • Top 10 Contributor
    • Joined on 02-02-2010
    • CommVault Tinton Falls NJ
    • Expert
    • Points 1,607

    At the HANA instance properties in the java GUI there is a tab for the log storage policy (This is pretty much the same for ALL the database agents)  What ever the policy that gets defined here will be the policy that the log backup will go to. 


    Ernst F. Graeler
    Product Specialist
    Applications and File Systems
  • Re: v11 SAP HANA on Linux
    Posted: 02-09-2018, 1:54 PM

    Thanks for the explanation!

    best regards!

  • Re: v11 SAP HANA on Linux
    Posted: 03-16-2018, 9:03 PM

    Hello,

    Its supposed that it opens more than 1 job per hana database. For some hana databases we have 3 persistent backups running, other 4 and 5.

    Is this normal or it should open only 1?

     

    Also in documentation says:

    "The persistent log backup feature ensures that you have all log files so that you can successfully restore your database"

    How come? why the other method doesn’t ensure that?

     

    Regards,

    STG

  • Re: v11 SAP HANA on Linux
    Posted: 03-16-2018, 10:47 PM

    you can choose the log storage policy at instance properties. Log backups are commandline jobs and not controlled ny Commvault.

    MAke sure you have proper retention set.

     

    Thanks,

    Srinivas

  • Re: v11 SAP HANA on Linux
    Posted: 03-16-2018, 10:55 PM

    STG,

     

    It depends on topology.

    Usuallly common topology with single database with single node contains 4 volumes. Hence you will see 4 seperate logs jobs upo and running.

    If it is worker node and multi node, then you may see one log per node and one catalog backup.

     

    IF it is multi tenant and for tenant database, you may see only one or 2 logs jobs depends on topology.

     

    THe note for persistent is correct. It is specific to persistant feature and even if you dont enable or disable persistant feature, logs jobs will invoke and PIT recovery always possible. THere is nothing difference.

    Let me know any more questions.

     

    Thanks,Srinivas

     

     

     

  • Re: v11 SAP HANA on Linux
    Posted: 03-17-2018, 5:28 AM

    Hello Srinivas,

    Thanks for your answers.

    Still, i have some doubts on the note "The persistent log backup feature ensures that you have all log files so that you can successfully restore your database."

    We just want to have sure that if we disable this feature, we will have all the information needed on the logs to recover the DB.

    Or the only difference is that you won’t have so many jobs to manage on the policy and like efg pointed in his post “It will make the job reporting much more manageable.

    We are just worried why CommVault add this statement for the persistent log backups and not for the no persistent log backups…

     

    Regards

    STG

  • Re: v11 SAP HANA on Linux
    Posted: 03-17-2018, 10:12 AM

    Hello STG,

     

    You are taking only tha tparticualr statement and worrying. The page talking about the feature and how feature ensure the recovery.

     

    Doesn't matter that whther you enable ot disable the feature, if the backint linking to commvault, once the HANA log request comes, we do backup. Yes recovery is possible at all times.IF in case any failures, HAAN consider that job failed and it re-initiate the request. We do backup.

     

    http://documentation.commvault.com/commvault/v11/article?p=22358.htm

     

    Configuring SAP HANA Persistent Log Backups

    This feature is available with Commvault Service Pack 6 or higher by setting the additional setting to 1.

    In SP10 or higher, this feature is activated by default.

    SAP HANA can produce a large number of log files that must be backed up to have a persistent backup.

    The persistent log backup feature ensures that you have all log files so that you can successfully restore your database.

    When you enable the persistent log backup feature, the Commvault software backs up the SAP HANA log files by using one persistent backup job for a specified period of time (the default is 6 hours). This operation caches the media resources throughout the job.

    The backup operation uses one job ID per SAP HANA database service.

    The Commvault software gracefully shuts down the service, and marks the backup job as complete when any of the following conditions are met:

    • There is a job failure
    • The specified time period expires
    • There is no log activity for one hour

    After the service is shut down, the next log request starts the process with a new job ID.

    You can change the time period that the software backs up the SAP HANA log files. For more information, see Setting the SAP HANA Persistent Log Backup Time.

    Note: The Commvault software uses persistent log backups by default in the following cases, even when you do not set the additional setting:

    • When you specify a media parameter file
    • When you use Commvault third-party job authentication
  • Re: v11 SAP HANA on Linux
    Posted: 03-20-2018, 11:37 AM

    Ok.

    Got it.

    Thanks for your help.

    STG

  • Re: v11 SAP HANA on Linux
    Posted: 01-09-2019, 11:27 AM

    Hi all,

     

    Could you please tell me what happens after the 6 hours? Does the job start again?

    Does the job runs forever then? Only changing Job ID every 6 hours?

     

    Thanks.

  • Re: v11 SAP HANA on Linux
    Posted: 01-09-2019, 11:30 AM

    Singham,

     

    AFter 6 hours, current job will completed and up on next backint request, new job will start.

     

    Thanks,
    Srinivas

The content of the forums, threads and posts reflects the thoughts and opinions of each author, and does not represent the thoughts, opinions, plans or strategies of Commvault Systems, Inc. ("Commvault") and Commvault undertakes no obligation to update, correct or modify any statements made in this forum. Any and all third party links, statements, comments, or feedback posted to, or otherwise provided by this forum, thread or post are not affiliated with, nor endorsed by, Commvault.
Commvault, Commvault and logo, the “CV” logo, Commvault Systems, Solving Forward, SIM, Singular Information Management, Simpana, Commvault Galaxy, Unified Data Management, QiNetix, Quick Recovery, QR, CommNet, GridStor, Vault Tracker, InnerVault, QuickSnap, QSnap, Recovery Director, CommServe, CommCell, SnapProtect, ROMS, and CommValue, are trademarks or registered trademarks of Commvault Systems, Inc. All other third party brands, products, service names, trademarks, or registered service marks are the property of and used to identify the products or services of their respective owners. All specifications are subject to change without notice.
Close
Copyright © 2019 Commvault | All Rights Reserved. | Legal | Privacy Policy