Progress
Database Administration
Guide and Reference
Performing an Online Full Backup With PROBKUP
To perform an online, full backup, run PROBKUP from the operating system prompt using the following command syntax:
UNIX Full Backup Example
The database administrator of Company X’s development department performs a full backup of the
devel.db
database every Friday on 9-track tapes.Company X’s DBA prepares the backup media according to the operating system documentation, then follows these steps to perform a full online backup of the
devel.db:
- Verify that the database is not in use by entering the following command:
- Enter the following command to perform a full online database backup:
These are the parameters for the commands:
devel
Identifies the name of the database you are backing up.
online
Specifies that the backup is an online backup.
/dev/rrm/0m
Specifies the output destination is a tape drive,
/dev/rrm/0m.
-vs 35
Indicates that the volume size in database blocks is 35. If you do not specify the volume size, Progress fills the entire tape before prompting you for a new tape.
-bf 20
Specifies that the blocking factor is 20.
-verbose
Displays information at 10-second intervals during the installation.
As the full offline backup of
devel.db
begins, the following report appears:
The number of backup blocks is the number of -
bf
units written to the tape. Backup blocks contain data, primary recovery, and error-correction blocks.This example backs up a very small database. Using the -
red
parameter on a larger database increases the amount of time and backup media required for the backup. Also, PROBKUP displays the number of blocks and the amount of backup required for an uncompressed database because you cannot specify the -scan
parameter for an online backup.- If you enable after-imaging, back up the AI files to a separate tape or disk using a UNIX backup utility.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |