Progress
Database Administration
Guide and Reference
Performing a Non-Progress Backup
When performing a backup using an operating system utility instead of the Progress Backup utility, you must perform the following extra steps:
- Be sure to back up all the proper files. For a list of files to back up, see the "Identifying Files For Back Up" section in Backup and Recovery Strategies."
- Make sure that the database is not used during the backup. Otherwise, the backup will be invalid. You can do this either by using the PROQUIET command to create a database quiet point or by shutting down the server and making any single-user session inactive.
- After you perform and verify the backup, mark the database as backed up.
Follow these steps:
- Shut down the database server.
Before you back up the database, you must shut down the database server. See "Starting Up and Shutting Down," for information about shutting down the database.
- Verify that the database is not 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 detailed information, see the description of the PROUTIL BUSY utility in Database Administration Utilities."
- Make a note of the last entry in the log file. You will use this information later to verify that the database is not used during the backup.
- Back up the database.
Use an operating system backup utility to back up the database files. Table 6–2 in "Backup and Recovery Strategies," lists the backup options available for each operating system. Ensure that your backup technique backs up the entire file. On many UNIX systems, certain utilities (for example,
cpio
) back up only the first part of files that are larger than a specified size (controlled by the ULIMIT parameter). Backups of only the first portion of a database file are of no value.- Verify that the backup is valid.
First, compare the last entry in the log file against the entry you noted in Step 3. If an entry has been added to the log file since you checked in Step 3, the database might have been used. If the database was used during the backup, then the backup is invalid. You must perform another backup.
Second, verify that you have backed up the entire database. The PROBKUP utility automatically backs up the proper files; with an operating system utility, you must make sure the proper files are included in the backup.
- Mark the database as backed up.
After you have verified the backup, use the RFUTIL MARK BACKEDUP utility to mark the database as backed up:
For more information, see the description of the RFUTIL utility in Database Administration Utilities."
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |