Skip to Content
0
Dec 23, 2007 at 03:34 PM

Advice for large database backup

28 Views

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.