Kbase P25006: How to recover when Bi file grows to 2GB with error 9452.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/01/2005 |
|
Status: In Research
GOAL:
How to recover when Bi file grows to 2GB with error 9452.
FIX:
1. Take a backup of the database as it is now using PROBKUP and the -norecover parameter.
probkup -norecover db-name destination-device
2. Create a new-db.st file with 2 additional bi extents (one 2GB fixed and
the last a variable).
3. PRODEL the existing database.
4. PROREST dbname new-db.st
5. Start the database in single user mode to go through crash recovery.
6. When this is successful the database is ready for use unless the additional bi files are to be removed. To remove the additional bi files continue with step 7.
7. Truncate the bi file:
proutil db-name -C truncate bi
8. To reduce the number of bi extents use the following command.
prostrct remove db-name bi
execute this command once for each bi extent to be removed. The last or variable extent is the first one removed.
9. Once the proper number of fixed bi extents is reached, created a add.st file to add one variable bi extent. Use the prostrct add command to add the variable extent.
prostrct add db-name add.st
10. Database is ready for use with proper number of bi files.