Forum Discussion

David_Bowlby's avatar
David_Bowlby
Level 4
11 years ago

SAP HANA Full Backups Show 0 Kilobytes Written and 0 Files Written

The SAP Administrators states these backups run successfully, but i do not see how much data is being written.  This isnt necessarily an issue, but could be if i can not judge the amount of data being backed up.

 

Activity Monitor on states connecting

Activity Monitor.png

 

Detailed Status:

 

4/9/2014 10:28:37 AM - Info nbjm(pid=12356) starting backup job (jobid=1905249) for client psaphanahrd01.loves.com, policy SAP_HANA_HRX, schedule FULL 
4/9/2014 10:28:37 AM - Info nbjm(pid=12356) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=1905249, request id:{2A0D59B3-5C61-452E-86B1-237ECC49520D}) 
4/9/2014 10:28:37 AM - requesting resource PTCDD01
4/9/2014 10:28:37 AM - requesting resource okcnbkp02.loves.com.NBU_CLIENT.MAXJOBS.psaphanahrd01.loves.com
4/9/2014 10:28:37 AM - requesting resource okcnbkp02.loves.com.NBU_POLICY.MAXJOBS.SAP_HANA_HRX
4/9/2014 10:28:37 AM - granted resource okcnbkp02.loves.com.NBU_CLIENT.MAXJOBS.psaphanahrd01.loves.com
4/9/2014 10:28:37 AM - granted resource okcnbkp02.loves.com.NBU_POLICY.MAXJOBS.SAP_HANA_HRX
4/9/2014 10:28:37 AM - granted resource PTCDD01
4/9/2014 10:28:38 AM - estimated 0 Kbytes needed
4/9/2014 10:28:38 AM - Info nbjm(pid=12356) started backup (backupid=psaphanahrd01.loves.com_1397057317) job for client psaphanahrd01.loves.com, policy SAP_HANA_HRX, schedule FULL on storage unit PTCDD01
4/9/2014 10:28:40 AM - started process bpbrm (6244)
4/9/2014 10:28:41 AM - Info bpbrm(pid=6244) psaphanahrd01.loves.com is the host to backup data from    
4/9/2014 10:28:41 AM - Info bpbrm(pid=6244) reading file list from client       
4/9/2014 10:28:41 AM - connecting
4/9/2014 10:28:43 AM - Info bpbrm(pid=6244) starting bphdb on client        
4/9/2014 10:28:43 AM - Info bphdb(pid=65213) Backup started          
4/9/2014 10:28:43 AM - Info bphdb(pid=65213) Processing /sapmnt/HRX/netbackup/sap_hanadb_backup          
4/9/2014 10:28:43 AM - Info bphdb(pid=65213) Waiting for the child status       
4/9/2014 10:28:43 AM - connected; connect time: 00:00:02
4/9/2014 10:32:00 AM - Info bphdb(pid=65213) Script exited with status = 0 <the requested operation was successfully completed>
4/9/2014 10:32:00 AM - Info bpbrm(pid=6244) validating image for client psaphanahrd01.loves.com       
4/9/2014 10:32:02 AM - Info bphdb(pid=65213) done. status: 0: the requested operation was successfully completed   
4/9/2014 10:32:02 AM - end writing
the requested operation was successfully completed(0)

 

Detailed Status showing Job Completed Successfully, with 0 Kilobytes Written, and 0 File Written.  SAP Admin states a full backup was completed.  Admin did not state how large the Backup was.

 

Detailed Status_0.png

7.5
Agents
Backing Up
Backup and Recovery
Configuring
Documentation
Monitoring
NetBackup
Reporting
Windows Server (2003-2008)
  • David_Bowlby's avatar
    David_Bowlby
    11 years ago

    According to Symantec Tech Support SAP Hana is pretty new, and Netbackup does not have a way to create a child job so we can view the amount of data backed up during the backup job.  This is in the works.  Advised me to use the bplist command to view the amount of data backed up.  

15 Replies

Sort By
Show More
  • Marianne's avatar
    Marianne
    Level 6
    11 years ago

    The Parent job won't show any details. It is simply 'taking care of' the child jobs. You should only look at the child jobs which is performing actual backup. 
    We can see figures next to the SAP child jobs which tells us the size of each stream.
    The FULL next to the parent job corresponds with the Automatic schedule in the policy that is merely starting the script on the client.
    The agent on the client is then sending actual data in the child streams against the Application Backup schedule type.

    The red 'stars' in Backup History are the successful database backups for each successful child stream. 
    Restore cannot be done from here - dba's need to use SAP commands/tools to start restore from the SAP server.

    The green 'tick' in between looks like a normal filesystem backup.

    Your post above tells us that all is good.

  • David_Bowlby's avatar
    David_Bowlby
    Level 4
    11 years ago

    @marianne - Do you know of a change either in the script or some other way, that i can view the child job of the full database backups?  Im only interested in the size of the job.

  • Nicolai's avatar
    Nicolai
    Moderator
    11 years ago

    Every job shows up in the activity monitor. There is no setting on the client side that will make job invisible in the activity monitor.

    Could it be the SAP backup uses the schedules for SAP-LOGS ? 

    Can you post the output from brtools from the SAP side. This will help us identify what schedules are in use. Attach output as a file to a post.

  • David_Bowlby's avatar
    David_Bowlby
    Level 4
    11 years ago

    I will see if i can get the sap admins to get me those logs pertaining to full backups on the sap side.   The security team has agreed to grant me backup operator access to sap hana.  it make take some time, but i will update as i view more of when the db fulls are in process. 

  • David_Bowlby's avatar
    David_Bowlby
    Level 4
    11 years ago

    According to Symantec Tech Support SAP Hana is pretty new, and Netbackup does not have a way to create a child job so we can view the amount of data backed up during the backup job.  This is in the works.  Advised me to use the bplist command to view the amount of data backed up.