SAP backup is taking longer time to complete

[Prem108]

SAP application backup is taking longer time to complete

both the media server and the client are same. (adxsap20)

We run an incremental backup ever day @ 6 pm CST except Friday and run full backup every Friday @ 6 pm CST.  Here are the good incremental backup information.

Backup ran 25 minutes on 2014-08-07
Backup ran 21 minutes on 2014-08-06
Backup ran 17 minutes on 2014-08-05

I was suspecting something has happened since 2014-08-10. nowadays it is taking 3-4 hrs to complete

SAPDB backup written to Netbackup SAN Media server and our netbackup external backup policy is unix_sap20_san

After viewing the file "vxbsa.1411518253.8061104.prog.pcb_std" from "/usr/openv/netbackup/logs/user_ops/dbext/logs". For more information,
you can find the below information. I think backup is taking longer time to run because of netbackup scheduleer work queue.

19:24:16 Initiating backup
19:26:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
19:28:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
19:30:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
19:32:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
19:34:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
19:36:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
19:38:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
19:40:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
19:42:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
19:44:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
19:46:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
19:48:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
19:50:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
19:52:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
19:54:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
19:56:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
19:58:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:00:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:02:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:04:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:06:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:08:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:10:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:12:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:14:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:16:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:18:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:20:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:22:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:24:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:26:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:28:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:30:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:32:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:34:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:36:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:38:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:40:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:42:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:44:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:46:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:48:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:50:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:52:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:54:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:56:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
20:58:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
21:00:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
21:02:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
21:04:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
21:06:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
21:08:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
21:10:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
21:12:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
21:14:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
21:16:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
21:18:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
21:20:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
21:22:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
21:24:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
21:26:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
21:28:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
21:30:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
21:32:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
21:34:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
21:36:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
21:38:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
21:40:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
21:42:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
21:44:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
21:46:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
21:48:20 INF - Waiting in NetBackup scheduler work queue on server netbackp.dx.deere.com
21:50:13 INF - Starting bpbrm
21:50:18 INF - Data socket = adxsap20.IPC:/usr/openv/var/tmp/vnet-36670411527016970161000000829--XabYZ;c1acdd520162b679ca136c23713800f5;11;300
21:50:19 INF - Name socket = adxsap20.IPC:/usr/openv/var/tmp/vnet-21916411527017370215000000829--TadYZ;cc45e1f37fe389268e13041845eff6f1;11;300
21:50:19 INF - Job id = 16721049
21:50:19 INF - Backup id = adxsap20_1411527012
21:50:19 INF - Backup time = 1411527012
21:50:19 INF - Policy name = unix_sap20_san
21:50:20 INF - Snapshot = 0
21:50:20 INF - Frozen image = 0
21:50:20 INF - Backup copy = 0
21:50:20 INF - Master server = netbackp.dx.deere.com
21:50:20 INF - Media server = adxsap20
21:50:21 INF - Multiplexing = 0
21:50:21 INF - New data socket = adxsap20.IPC:/usr/openv/var/tmp/vnet-62088411527016570070000000829--TaeIZ;84cfb787999c289b7eee673407bd9eeb;11;300
21:50:21 INF - Use shared memory = 1
21:50:21 INF - Compression = 0
21:50:21 INF - Encrypt = 0
21:50:22 INF - Keep logs = 3
21:50:22 INF - Client read timeout = 3600
21:50:22 INF - Media mount timeout = 0
21:50:26 INF - Data buffer size = 1048576
21:50:27 INF - Waiting for mount of media id A01060 on server adxsap20 for writing
21:50:28 INF - Using Media ID A01060 for Backup ID adxsap20_1411527012
21:50:28 /
21:50:28 /PROXY_BACKUP
21:50:28 INF - Processing /sapdb/bkup/PCE/scripts/log/backint.adapter.history
21:50:29 /
21:50:29 /sapdb/
21:50:29 /sapdb/bkup/
21:50:29 /sapdb/bkup/PCE/
21:50:29 /sapdb/bkup/PCE/scripts/
21:50:29 /sapdb/bkup/PCE/scripts/log/
21:50:29 /sapdb/bkup/PCE/scripts/log/backint.adapter.history
21:50:29 /sapdb/bkup/PCE/scripts/log/backint.adapter.history
21:50:30 INF - Client completed sending data for backup

21:50:56 INF - Mounted media id A01060
21:50:56 INF - Waiting for mount of media id A50853 on server adxsap20 for writing
21:50:57 INF - Using Media ID A50853 for Backup ID adxsap20_1411527012
21:51:31 INF - Mounted media id A50853
21:53:43 INF - Beginning backup on server adxsap20 of client adxsap20
21:53:45 INF - Using Media ID A01060 for Backup ID adxsap20_1411527012
21:53:47 INF - Using Media ID A50853 for Backup ID adxsap20_1411527012
21:54:01 INF - Server status = 0
21:54:07 INF - Backup by sdb on client adxsap20 using policy unix_sap20_san, sched User:the requested operation was successfully completed

[Prem108]

Team,

Any help on this ?

[Marianne · Accepted solution]

You need to check NBU Activity Monitor to see what else is happening in the environment from about 7pm onwards.

It seems other backups may be using the tape drives, leaving no available tape drives for this SAN media server.

When backup resources finally became available, the backup took 4 minutes from tape mount to completion. Quite fast, don't you think?