ORA-00600: Internal Error Code, Arguments: /ORA-10567 Reported Shortly After converting Snapshot Database to Physical Standby and Starting Managed recovery
Last updated on NOVEMBER 29, 2017
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 11.2 to 12.2]
Information in this document applies to any platform.
Primary and Standby Configuration.
The sequence of events leading up to the ORA-00600: is this:
1. alter database convert to snapshot standby;
2. open read write
3. alter database convert to physical standby;
4. start media recovery
5. after a short time, media recovery fails with ORA-00600:
The ORA-10564 shows the problematic block is in the SYSAUX tablespace.
ORA-10567: Redo is inconsistent with data block (file# 200, block# 12256, file offset is 1004019712 bytes)
ORA-10564: tablespace SYSAUX
ORA-01110: data file 200: '+ORCL/ORCL/datafile/sysaux.8755.939329185'
ORA-10560: block type '0'
ORA-00600: internal error code, arguments: , , ,
The ORA600 tracefile includes these msgs:
- KCOX_FUTURE: CHANGE IN FUTURE OF BLOCK
- RECOVERY STUCK AT BLOCK <block#> OF FILE <file#>
> Direct Load insert might be involved(When in Snapshot database mode)
Call stack :- kcbr_mapply_change <- kcbrapply <- kcbr_apply_pending <- krp_slave_apply
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms