Kbase 17527: How to backup multiple databases to One Tape -- UNIX
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
GOAL:
How to backup more than one database to tape using probkup?
GOAL:
Is it possible to use one tape for all your databases.
FACT(s) (Environment):
UNIX
FIX:
By doing the PROBKUP to a single tape you eliminate the need to store
extra media.
For the backup, use no rewind for both open and close on your device.
For example (each tape device may differ):
#probkup test1 /dev/rmt/c0t2d0s0nn
#probkup test2 /dev/rmt/c0t2d0s0nn
For restore, rewind first. You do not need to skip files for the first database. Skip 1 file and restore the second database, skip 2 and restore the third database... skip n-1 files and restore the n-th database. Using a non-rewinding device puts a file marking on the tape so that you can now skip to the next database backup for your prorest.
For first database restore procedure:
#/usr/ucb/mt -f /dev/rmt/c0t2d0s0 rewind
#prorest test1 /dev/rmt/c0t2d0s0n
For Second database restore procedure:
#/usr/ucb/mt -f /dev/rmt/c0t2d0s0 rewind
#/usr/ucb/mt -f /dev/rmt/c0t2d0s0n fsf 1
#prorest test2 /dev/rmt/c0t2d0s0n
For n-th database restore procedure:
#/usr/ucb/mt -f /dev/rmt/c0t2d0s0 rewind
#/usr/ucb/mt -f /dev/rmt/c0t2d0s0n fsf n-1
#prorest testn /dcv/rmt/c0t2d0s0n