cancel
Showing results for 
Search instead for 
Did you mean: 

RMAN backups running too slow

Rulo
Level 0

Hi

We are making backup with Veritas Backup Exec 16 (running RMAN scripts) , the client is a Red Hat 6.9 with Oracle Database 12c.

When we launch a DELETE OBSOLETE, CROSSCHECK BACKUP to SBTAPE, takes about 3.5 min to delete each backup piece. 

DBGMISC:       ENTERED krmzlog [11:20:00.166]
RMAN-08517: backup piece handle=5hslgd6u_1_1 RECID=224 STAMP=962082014
DBGMISC:       EXITED krmzlog [11:20:00.166] elapsed time [00:00:00:00.000]
DBGPLSQL:      channel ORA_SBT_TAPE_1: File 5islgd9t_1_1 belongs to 4810408 [11:20:00.166] (change)
DBGPLSQL:      channel ORA_SBT_TAPE_1: File 5islgd9t_1_1 virtual key 0 [11:20:00.166] (change)
DBGPLSQL:      channel ORA_SBT_TAPE_1: File 5islgd9t_1_1 am_access  [11:20:00.166] (change)
DBGPLSQL:      channel ORA_SBT_TAPE_1:  processing (file/handle=5islgd9t_1_1,recid=225, old_status=A, hdl_isdisk=0, devicetype=SBT_TAPE, source_dbid=0) [11:20:00.166] (change)
DBGPLSQL:      channel ORA_SBT_TAPE_1:  force: 0 [11:20:00.166] (change)
DBGPLSQL:      channel ORA_SBT_TAPE_1: Calling ValidateBackupPiece for 5islgd9t_1_1 [11:20:00.166] (change)
DBGRPC:        krmxrpc - channel ORA_SBT_TAPE_1 kpurpc2 err=0 db=target proc=SYS.DBMS_BACKUP_RESTORE.VALIDATEBACKUPPIECE excl: 0
DBGPLSQL:      channel ORA_SBT_TAPE_1: file 5islgd9t_1_1, rc=4 [11:23:12.228] (change)
DBGPLSQL:      channel ORA_SBT_TAPE_1: file 5islgd9t_1_1, Modified rc=4 rc_in_use=0 [11:23:12.228] (change)
DBGPLSQL:      channel ORA_SBT_TAPE_1: file 5islgd9t_1_1, found=FALSE [11:23:12.228] (change)
DBGPLSQL:      channel ORA_SBT_TAPE_1: file 5islgd9t_1_1 not found for cmd 599 [11:23:12.228] (change)

DBGPLSQL:      channel ORA_SBT_TAPE_1: file 5islgd9t_1_1 not found for cmd 599 [11:23:12.228] (change)
DBGPLSQL:      channel ORA_SBT_TAPE_1: file 5islgd9t_1_1 mismatch: FALSE force: 0 rc_in_use: 0 [11:23:12.228] (change)
DBGRPC:        krmxrpc - channel ORA_SBT_TAPE_1 kpurpc2 err=0 db=target proc=SYS.DBMS_BACKUP_RESTORE.CHANGEBACKUPPIECE excl: 0
DBGMISC:       ENTERED krmzlog [11:23:12.263]
RMAN-08074: crosschecked backup piece: found to be 'EXPIRED'
DBGMISC:       EXITED krmzlog [11:23:12.263] elapsed time [00:00:00:00.000]

 

This is the trace of a CROSSCHECK BACKUP (In bold you can see the delay)

When we run a backup the first connection takes about 5 minutes. Once the connection is established the transfer rate is normal. Hosts files are edited in both server to avoid DNS problems, and they are in the same VLAN.

Thanks

 

 

 

1 REPLY 1

MIL1
Level 3

Please review the following article. The issue may related delay cuased by the Oracle Sbtwrite calls during the backup job. 

https://www.veritas.com/support/en_US/article.000007259

To check Backup Exec specific debug of Oracle you can enable and review the debug logs as mentioned in the following document

https://www.veritas.com/support/en_US/article.000038281