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:

probkup online db-name device-name [ parameters ] 

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:

  1. Verify that the database is not in use by entering the following command:
  2. proutil devel -C BUSY 
    

  3. Enter the following command to perform a full online database backup:
  4. probkup online devel /dev/rrm/0m -vs 35 -bf 20 -verbose 
    

    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:

    64 bi blocks will be dumped. 
    336 out of 336 blocks in devel will be dumped. 
    This will require 369664 bytes of backup media. 
    This backup will require a minimum of 400 blocks to restore. 
    1 volume will be required. 
    Backed up 400 blocks in 00:00:05. 
    Wrote a total of 18 backup blocks using 369664  
    bytes of media. 
    Backup complete. 
    

    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.

  5. 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