Salesforce

PROBKUP on the standby database with -norecover fails 1119 1553

« Go Back

Information

 
TitlePROBKUP on the standby database with -norecover fails 1119 1553
URL NameP25872
Article Number000128510
EnvironmentProduct: Progress
Version: 9.x
Product: OpenEdge
Version: 10.0, 10.1A
Question/Problem Description
PROBKUP on the standby database with -norecover fails 1119 1553
PROBKUP -norecover sometimes succeeds when the bi file on the hotspare is truncated
After truncating the bi file on the standby database, the -norecover backup succeeds but subsequent roll forwards can fail as outlined in Article 000021068   
Error 1119 appears every time a PROBKUP -norecover is executed after ai's have been roll forwarded.

stack trace from _dbutil
 
dsmFatalMsgnCallBack()
bkRead()
mvBiTlBackup()
mv_bkutil()
mvutil()
Steps to Reproduce
Clarifying Information
User account performing backup has rw on all database files
Hardware and tape device examined for faults
System logs clean

Multiple bi extents
-biblocksize is not the default (8KB) blocksize
-biclustersize is not the default (524KB) clustersize
 
Error MessageSYSTEM ERROR: wrong BI blk, read <dbkey> from <dbkey> (1119)
SYSTEM ERROR: wrong BI blk, read 24833 from 12416 (1119)
The last backup was not completed successfully. (1553)
Defect NumberEnhancement OE00134073 / PSC00179799
Enhancement Number
Cause
During an offline PROBKUP operation with the -norecover option, bi files are backed up as well as the database files.

It is during the read operation of the bi file that the process goes awry according to the stack trace listed above. The 1119 message indicates the database manager tried to verify the block that was requested was the block that was read and the verification failed.

This could either indicate that there is corruption in the dbkey or block on disk or that the wrong block was read into the buffer. As this message specifically relates to the bi files, if there were indeed bi corruption, then one wouldn't be able to subsequently truncate the bi file without the -F option. In this case however, it is possible so we can safely assume that there is no bi corruption.

When the bi blocksize is changed, a misconfiguration of the bi blocks results which the backup utility is (erroneously) detecting as corruption. For further detail, refer to Article, 000020102   
Resolution
This behavior has been Enhanced in the following OpenEdge versions:
  • OpenEdge 10.1B or later where by default, only the active bi clusters (aka initialized bi blocks) are backed up with the offline probkup -norecover option
  • Upgrade to OpenEdge 11.3.0 or later where by default, only the active bi clusters (aka initialized bi blocks) are backed up during online backups. OpenEdge 11.5 or later is recommended when active bi clusters exceed 2GB. Refer to Article:
To recover from this scenario rebaseline the standby hotspare database after re-configuring the BI structure:

a. End AI on production DB

b. Re-structure the BI files:

Remove the current bi files from the database structure
$   proutil dbname -C truncate bi
$   prostrct remove dbname bi #  repeat once for each bi extent defined
$   prostrct add dbname addbi.st # where addbi.st is a structure file containing the redefinition of the bi extents

Configure the BI block size and cluster size as required:
$   proutil dbname -C truncate bi -bi <clustersize> -biblocksize <blocksize>

c. Re-enable AI on production and re-create the hotspare standby database
  • Probkup production DB
  • Start AI on production DB
  • Prorest to standby DB 
  • Roll-forward AI files
d. Test probkup -norecover
Workaround
Notes
Keyword Phrase
Last Modified Date11/20/2020 7:38 AM

Powered by