Progress
Database Administration
Guide and Reference
Performing an Offline Progress Backup
You can perform both full and incremental backups offline. You must perform a full backup before performing an incremental backup. Following the first full backup, you can perform any number of incremental backups. However, you should perform a full backup at least once a week.
Follow these steps to perform an offline backup, either full or incremental:
- Verify that the database is not in use.
If you are performing an offline backup, the database must not be in use. The server must be shut down and no single-user session can be active. PROBKUP does not allow access to the database during a full offline backup.
On UNIX systems that support file locking and where backup utilities (for example,
cpio
) honor file locks, an attempt to back up a database in use causes the utility to hang, waiting for the Progress session to end. On all other systems, there is no way to prevent you from backing up a database in use.Use the PROUTIL BUSY utility to determine whether the database is in use:
The BUSY qualifier returns a code indicating whether the database is in use. You can use the codes returned by the BUSY qualifier in scripts, files, or procedures. For more information about this qualifier, see the description of the PROUTIL utility in Database Administration Utilities."
- Shut down the database server.
- Perform the offline backup.
Use PROBKUP to perform either a full or incremental offline backup. Run PROBKUP from the operating system prompt:
For more information about this qualifier, see the description of PROBKUP parameters listed earlier in this chapter, or see the description of the PROUTIL utility in Database Administration Utilities."
By default, PROBKUP performs a full backup. To perform an incremental backup, specify the incremental qualifier.
As you begin the full backup of a database, a report appears on your terminal that indicates how many:
- Bytes are required on the backup media
- Active data blocks are written to the backup media
- Blocks are dumped
- Blocks are required to restore the database
When the backup successfully completes, the report displays the total number of bytes on the backup media and how long it took to complete the backup.
NOTE: If a system failure occurs while you are performing the full backup, perform the backup again.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |