Hi,
we need a backup procedure for large Oracle 9.2.0.7 on Solaris 10 database, 1.5 TB. We haven't a BACKINT-compatible software as backup software, we have NetVault BakBone, so we save to others disks (900 GB) our database with BRBACKUP and then save to tape (Sun C4 Tape Library - 38 drive LTO3) with BakBone.
Have you got any advice ? ... to reduce the time, cpu load, ecc. ?
I try with ....
brbackup -p initSID.sap -u system/**** -d disk -t online_cons -m all -c force -k yes -l E
our initSID.sap:
-
backup_mode = all
restore_mode = all
backup_type = online_cons
backup_dev_type = disk
backup_root_dir = /stage_prod/SID
stage_root_dir = /stage_prod/SID
compress = yes
compress_cmd = "compress -c $ > $"
uncompress_cmd = "uncompress -c $ > $"
compress_dir = /oracle/SID/sapreorg
archive_function = save_delete
archive_copy_dir = /stage_prod/SID
archive_stage_dir = /stage_prod/SID
tape_copy_cmd = dd
disk_copy_cmd = dd
stage_copy_cmd = rcp
cpio_flags = -ovB
cpio_in_flags = -iuvB
cpio_disk_flags = -pdcu
dd_flags = "obs=64k bs=64k"
dd_in_flags = "ibs=64k bs=64k"
saveset_members = 1
copy_out_cmd = "dd ibs=8k obs=64k of=$"
copy_in_cmd = "dd ibs=64k obs=8k if=$"
rewind = "mt -f $ rew"
rewind_offline = "mt -f $ offline"
tape_pos_cmd = "mt -f $ fsf $"
tape_size = 1200M
exec_parallel = 6
tape_address = /dev/rmt/0mn
tape_address_rew = /dev/rmt/0m
volume_archive = (SIDA01, SIDA02, SIDA03, SIDA04, SIDA05,
SIDA06, SIDA07, SIDA08, SIDA09, SIDA10,
SIDA11, SIDA12, SIDA13, SIDA14, SIDA15,
SIDA16, SIDA17, SIDA18, SIDA19, SIDA20,
SIDA21, SIDA22, SIDA23, SIDA24, SIDA25,
SIDA26, SIDA27, SIDA28, SIDA29, SIDA30)
volume_backup = (SIDB01, SIDB02, SIDB03, SIDB04, SIDB05,
SIDB06, SIDB07, SIDB08, SIDB09, SIDB10,
SIDB11, SIDB12, SIDB13, SIDB14, SIDB15,
SIDB16, SIDB17, SIDB18, SIDB19, SIDB20,
SIDB21, SIDB22, SIDB23, SIDB24, SIDB25,
SIDB26, SIDB27, SIDB28, SIDB29, SIDB30)
expir_period = 2
tape_use_count = 100
-
Regards.
Ganimede Dignan.