Kbase P20785: What are the steps to perform an offline non-Progress backup
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/10/2003 |
|
Status: Unverified
GOAL:
What are the steps to perform an offline non-Progress backup?
FIX:
A single backup scenario will not suit every situation, therefore this is only a basic guide on the recommended steps to perform.
1. Shutdown all brokers currently running against the database. This includes Webspeed, DataServer, AppServer, Database, and any other brokers that connect to this database.
2. Truncate the database bi file using the following command:
proutil dbname -C truncate bi
3. Backup your database using your preferred backup method.
4. Grow your bi file using the "bigrow" option of the proutil command.
5. Restart your database.
Truncating the bi file is done so that it reduces the size of your O/S backup.
Growing the bi file is done afterward due to performance penalty inflicted by the previous bi truncation. By pre-growing the bi file after the backup you can eliminate this performance penalty. The performance penalty occurs when the database is running and users are performing transactions that require the bi file to be extended.
You will need to read the documentation regarding how to use the proutil bigrow utility as there are certain calculations that you need to perform. It will also allow you to better understand the command and it's purpose. You may determine that you do not need to perform a bigrow command if your bi file is small or you are using fixed bi extents and are not using a variable extent.