Kbase 19999: Determining the Number of Areas in a V9.x PROBKUP
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Restoring from a Progress backup (prorest)
Restore failed. (1618)
Unequal number of user areas detected in the target database. (6770)
Source database contains <number> and target database contains <number>. (6771)
!!! ERROR - Database restore utility FAILED !!! (8564)
CAUSE:
The area configuration in the backup and the target database are not exactly the same.
When restoring from backup in Progress Version 9.x the areas defined in the source database must also exist in the target database.
FIX:
The following command can be used to determine what areas are contained in the backup:
$ prorest <db> <backup-file> -list
For example:
prorest test mybackup.bck -list
In the example, it is not important what database name is used, or even if the database exists. You will see the following output:
$ prorest test mybackup.bck -list
Area Name: Schema Area
Size: 19968, Records/Block: 32, Area Number: 6
Area Name: Info Area
Size: 2560, Records/Block: 32, Area Number: 7
Area Name: Order Area
Size: 2560, Records/Block: 32, Area Number: 8
This information provides the area numbers and the number of records per block. The total number of blocks in the area is determined by dividing the area size by the records/block. You still must know the block size of the database from which the backup was made.