Currently Oracle Development is working on the patch fix. This issue occurs on 11.2.0.2 Linux when multiple restore points created while the database is opened.
DIAGNOSTIC ANALYSIS
===================
Errors ORA-600 [kclchkblk_4] and ORA-600 [2662] After Recovery of
Database (Doc ID 275902.1)
BUG: 3517013 10.1.0.2 RDBMS 10.1.0.2 BUFFER CACHE PRODID-5 PORTID-23
ORA-600
Abstract: GSIST: OPEN DB RESETLOG AFTER FLASHBACK DB FAILS ORA-600
[KCLCHKBLK_4], [1904]
DIAGNOSTIC ANALYSIS
===================
Errors ORA-600 [kclchkblk_4] and ORA-600 [2662] After Recovery of
Database (Doc ID 275902.1)
BUG: 3517013 10.1.0.2 RDBMS 10.1.0.2 BUFFER CACHE PRODID-5 PORTID-23
ORA-600
Abstract: GSIST: OPEN DB RESETLOG AFTER FLASHBACK DB FAILS ORA-600
[KCLCHKBLK_4], [1904]
Initially, Oracle Support suggested us to drop and re-create the temp since the symptom seems to be similar to the below description, but it doesn't work for us. Oracle Developer is working on the fix patch..
Internal Problem Description:
Flashback will move back the recent scn, but it will not touch temporary
files, so it is possible to read a temporary file, and find a block
scn which is greater than the recent scn.
Internal Problem Description:
Flashback will move back the recent scn, but it will not touch temporary
files, so it is possible to read a temporary file, and find a block
scn which is greater than the recent scn.
Hello !
ReplyDeleteDid you get the patch from the support ?
I get the same issue.