Saving some time during dump and loads

[Cool_Dude_eh]

HPUX 11
progress 8.3b

I would like to figure out how to do a probkup of a multi volume DB(15 Gb) from disk to disk. (we have lost of fast disk)
(We currently do 2 probackups to tape before doing dump and loads, but I think we could save time by doing one of them to disk)
I obviously need to be able to do a prorest too to prove this method.

 

[breakdown]

backup to disk

Use the -vs switch on probkup and specify a file size that you want the backup files to be. You will then have to pass it a list of files to use once the first file size limit is reached.

"-vs" will multiply the database blocksize by whatever value you provide for "-vs". For example, running a db with an 8k blocksize and a -vs of 250000 will create a backup file that is right at 2GB.

use this:
$DLC/bin/probkup /"DATABASE" /BACKUP_AREA/backup.1 -vs 250000 < BACKUPFILES

The contents of BACKUPFILES would be the following:
/BACKUP_AREA/backup.2
/BACKUP_AREA/backup.3
/BACKUP_AREA/backup.4
/BACKUP_AREA/backup.5
etc...

The probkup utility will use as many "backup.#" files as it needs, as long as they are in the "BACKUPFILES" file. Make sure you put a lot of entries in that file to cover all your data. If you have a 15GB database, I'd make available at least 10 backup files at 2GB each in the "BACKUPFILES" file.

Any questions about this, feel free to email me.