Kbase P11503: How to automatically backup a multi-volume database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
GOAL:
How to automatically backup a multi-volume database
GOAL:
How to automate a backup that spawn multiple volumes?
GOAL:
How to inform the next volume of a backup automatically?
FIX:
This solution describes how to automatically backup a Progress database even if the database is larger than the capacity of the target backup media.
The strategy is to break the backup into multiple target files pointing them to the location where space is available and pass that information to PROBKUP utility so it will create the multiple backup file on the requested destination.
1. Determine the target destination for the backup file and how much space is available
2. Using a text editor create a file that will later be used to feed PROBKUP, this file should contain the path and the backup file name one extent per line. The file should looks like this:
/backup/db/sports2000.bkp2
/backup/db/sports2000.bkp3
/backup/db/sports2000.bkp4
Make sure there are enough backup extents to complete the backup process
3. Start the backup command specifying the size of each backup volume and the file created on step 2:
probkup <db-name> /backup/db/sports2000.bkp1 ?vs <volume-size> < backup.txt
<volume-size> is the units in database block size
<db-name> is database name
To restore the database run the prorest command referencing the first extent but with the same reference to the text file, eg:
prorest sports2000 /backup/db/sports2000.bkp1 < backup.txt
NOTE: During PROREST it may be necessary to add a blank line or the letter ?y? to the first line of the input file if the restore is overwriting an existing database as the following message may appear:
Do you want to over write it? [y
]: Restore failed. (1618)