Posts tagged: ORA-00600:[Kccrbl_stale] at Startup Mount

Jan 23 2010

ORA-00600:[Kccrbl_stale] at Startup Mount

ORA-00600:[Kccrbl_stale] at Startup Mount
Scenario:
One of our Test Database was running on Unix with 10g Rel1.
Due to power outage database went down when the sever comes up
and we tried to startup the database but we got ORA-600 with
first argument as “Kccrbl_stale”.

Reason: Control file header is corrupted.

Solution :
Anyone solution based on the backup method you use
1. Restore the backup of controlfile and do complete recovery
2. Recreate control file from using the script generated
3. Recreate the control file manually with “NORESETLOGS”

Alibi3col theme by Themocracy