ORA-00600: Internal Error Code, Arguments: [krccckp_scn_low]

Symptoms:

After converting from Snapshot Standby to Physical Standby, managed recovery fails:

ORA-00600: internal error code, arguments: [krccckp_scn_low], [723613753], [71234534], [], [], [], [], [], [], [], [], []

Errors are reported when the Standby database is opened in READ-ONLY with Real Time Apply.

Solution:
1. Disable block change tracking in standby database:
ALTER DATABASE DISABLE BLOCK CHANGE TRACKING;
2. Bounce the Standby databsae and start MRP using real-time apply
4. Verify logs are getting shipped and applied
5. Bounce the Standby again
6. Enable block change tracking:
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
  • January 5, 2019 | 23 views
  • Comments