Kbase P19557: 1028 errors when restoring AI files to hot standby database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/09/2010 |
|
Status: Verified
SYMPTOM(s):
Getting Error 1028 when restoring AI files to a hot standby database
SYSTEM ERROR: Physical redo, BKUPDCTR=<number>, note updctr=<number>. (1028)
SYSTEM ERROR: Physical redo, BKUPCTR=677, note updctr=680. (1028)
area , dbkey , record type (8999)
area 10, dbkey 4512318, record type 42 (8999)
SYSTEM ERROR: Roll forward of file <file name> did not complete normally (1046)
SYSTEM ERROR: End of last note read is at file offset (1048)
SYSTEM ERROR: End of last note read is at file offset 14241414 (1048)
User <num> died with <num> buffers locked. (2523)
User 0 died with 1 buffers locked. (2523)
210 errors in database log file dealing with temporary tables.
SYSTEM ERROR: unable to read block <number> which does not exist (210).
Scan of database using dbrpr shows 1 bad fragment.
FACT(s) (Environment):
Progress 9.1C
Sun Solaris SPARC
9.1C14 version of Progress
CAUSE:
Index and record level corruption.
FIX:
Fix index corruption using idxfix online due to size of the db and the need for the db to remain online. Attempt to remove bad record using idxfix option # 6. If not possible, then will need to take database offline to fix corruption using dbrpr.