backup_mode = all

backup_type = online

backup_dev_type = pipe_auto

backup_root_dir = ?/sapbackup

compress = no

compress_cmd = "compress -c $ > $"

uncompress_cmd = "uncompress -c $ > $"

compress_dir = ?/sapreorg

archive_function = copy_delete_save

archive_copy_dir = ?/sapbackup

cpio_flags = -ov

cpio_in_flags = -iduv

cpio_disk_flags = -pdcu

dd_flags = "obs=16k"

dd_in_flags = "ibs=16k"

read_fifo_cmd = "rsh backup"

copy_out_cmd = "dd ibs=512 obs=32k conv=block of=$"

copy_in_cmd = "dd ibs=32k obs=512 conv=block if=$"

rewind = "mt -f $ rew"

rewind_offline = "mt -f $ offline"

tape_size = 20000M

exec_parallel=0
tape_address = /dev/nrmt1h

tape_address_rew = /dev/rmt1h

expir_period = 0

tape_use_count = 500

After tuning, parameter in /oracle/<SID>/dbs/init<SID>.sap

backup_mode = all

backup_type = online

backup_dev_type = pipe_auto

backup_root_dir = ?/sapbackup

compress = hardware

compress_cmd = "compress -c $ > $"

uncompress_cmd = "uncompress -c $ > $"

compress_dir = ?/sapreorg

archive_function = copy_delete_save

archive_copy_dir = ?/sapbackup

cpio_flags = -ovB

cpio_in_flags = -iduvB

cpio_disk_flags = -pdcu

dd_flags = "obs=64k bs=64k"

dd_in_flags = "ibs=64k bs=64k"

read_fifo_cmd = "rsh backup"

copy_in_cmd = "dd ibs=64k obs=64k if=$"

tape_copy_cmd = "dd"

rewind = "mt -f $ rew"

rewind_offline = "mt -f $ offline"

tape_pos_cmd = "mt -f $ fsf $"

tape_size = 20000M

exec_parallel = 0

tape_address = /dev/nrmt1h

tape_address_rew = /dev/rmt1h

expir_period = 0

tape_use_count = 500

Look at backup result before tuning :

BR051I BRBACKUP 3.1H

BR189W Expiration period equals 0 - volumes could be immediately overwritten!

BR055I Start of database backup: bcxynsig anp 1998-08-05 17.04.54

BR319I Control file copied to /oracle/HRD/sapbackup/cntrl.dbf

BR101I Parameters

oracle_sid HRD

oracle_home /oracle/HRD

oracle_profile /oracle/HRD/dbs/initHRD.ora

sap_profile /oracle/HRD/dbs/init1.sap

backup_mode ALL

backup_type online

backup_dev_type pipe_auto

compress no

tape_copy_cmd cpio

cpio_flags -ov

cpio_in_flags -iduv

cpio_disk_flags -pdcu

dd_flags obs=16k

dd_in_flags ibs=16k

read_fifo_cmd rsh backup

copy_out_cmd dd ibs=512 obs=5k conv=block of=$

copy_in_cmd dd ibs=5k obs=512 conv=block if=$

rewind mt -f $ rew

rewind_offline mt -f $ offline

tape_size 20000.000 MB

tape_address /dev/nrmt1h

tape_address_rew /dev/rmt1h

volume_backup HRDB03

expir_period 0

tape_use_count 500

exec_parallel 0

:

:

BR056I End of database backup: bcxynsig anp 1998-08-06 08.28.15

BR053I BRBACKUP terminated successfully with warnings.

Look at backup result after tuning

BR051I BRBACKUP 3.1H

BR189W Expiration period equals 0 - volumes could be immediately overwritten!

BR055I Start of database backup: bcyghgmz anp 1998-09-15 17.04.17

BR319I Control file copied to /oracle/HRD/sapbackup/cntrl.dbf

BR083W Compression rates out of date - run BRBACKUP with option '-k only'.

BR101I Parameters

oracle_sid HRD

oracle_home /oracle/HRD

oracle_profile /oracle/HRD/dbs/initHRD.ora

sap_profile /oracle/HRD/dbs/init1.sap

backup_mode ALL

backup_type online

backup_dev_type pipe_auto

compress hardware

tape_copy_cmd dd

cpio_flags -ovB

cpio_in_flags -iduvB

cpio_disk_flags -pdcu

dd_flags obs=64k bs=64k

dd_in_flags ibs=64k bs=64k

read_fifo_cmd rsh backup

copy_out_cmd dd obs=64k ibs=64k of=$

copy_in_cmd dd ibs=64k obs=64k if=$

rewind mt -f $ rew

rewind_offline mt -f $ offline

tape_size 20000.000 MB

tape_address /dev/nrmt1h

tape_address_rew /dev/rmt1h

volume_backup HRDB02

expir_period 0

tape_use_count 500

exec_parallel 0

:

:

BR056I End of database backup: bcyghgmz anp 1998-09-16 07.09.04

BR053I BRBACKUP terminated successfully with warnings.

BR051I BRBACKUP 3.0F

BR189W Expiration period equals 0 - volumes could be immediately overwritten!

BR055I Start of database backup: bcxytfxp ant 1998-08-06 20.02.41

BR319I Control file copied to /oracle/P11/sapbackup/cntrl.dbf

BR083W Compression rates out of date - run BRBACKUP with option '-k only'.

BR101I Parameters

oracle_sid P11

oracle_home /oracle/P11

oracle_profile /oracle/P11/dbs/initP11.ora

sap_profile /oracle/P11/dbs/initcoba2.sap

backup_mode ALL

backup_type online

backup_dev_type tape_auto

compress hardware

cpio_flags -ovB

cpio_in_flags -iuvB

cpio_disk_flags -pdcu

dd_flags obs=16k

dd_in_flags ibs=16k

rewind mt -f $ rew

rewind_offline mt -f $ offline

tape_size 40000.000 MB

tape_address /dev/nrmt3h,/dev/nrmt4h,/dev/nrmt5h

tape_address_rew /dev/rmt3h,/dev/rmt4h,/dev/rmt5h

volume_backup P11B17,P11B18,P11B19

expir_period 0

tape_use_count 500

exec_parallel 3

:

:

BR056I End of database backup: bcxytfxp ant 1998-08-07 05.19.12

BR053I BRBACKUP terminated with warnings.

Look at backup result before tuning at ASMODB :

BR051I BRBACKUP 3.1H

BR189W Expiration period equals 0 - volumes could be immediately overwritten!

BR055I Start of database backup: bcygmuds ant 1998-09-16 20.02.40

BR319I Control file copied to /oracle/P11/sapbackup/cntrl.dbf

BR083W Compression rates out of date - run BRBACKUP with option '-k only'.

BR101I Parameters

oracle_sid P11

oracle_home /oracle/P11

oracle_profile /oracle/P11/dbs/initP11.ora

sap_profile /oracle/P11/dbs/initcoba2.sap

backup_mode ALL

backup_type online

backup_dev_type tape_auto

compress hardware

tape_copy_cmd dd

cpio_flags -ovB

cpio_in_flags -iuvB

cpio_disk_flags -pdcu

dd_flags obs=64k bs=64k

dd_in_flags ibs=64k bs=64k

rewind mt -f $ rew

rewind_offline mt -f $ offline

tape_size 40000.000 MB

tape_address /dev/nrmt3h,/dev/nrmt4h,/dev/nrmt5h

tape_address_rew /dev/rmt3h,/dev/rmt4h,/dev/rmt5h

volume_backup P11B14,P11B15,P11B16

expir_period 0

tape_use_count 500

exec_parallel 3

:

:

BR056I End of database backup: bcygmuds ant 1998-09-16 23.16.50

BR053I BRBACKUP terminated successfully with warnings.

Notes : Look at the different between two backup result, to change the parameter just add or remove the old parameter at /oracle/<SID>/dbs/init<SID>.sap.