ORA-600 [KTBCONVERTREDO_1]
After ora-4030 errors and sequence of ora-600 ktbConvertRedo_1
and led to an instance crash. Restarting database didn't help
(database was up ~ 5minutes).
We tried also switchover to physical standby but unfortunately
we received the same error.
Smon generated trace and if you carefully look in trace there is
a object_id. When we tried
run queries on this object then we received the same error.
Bingo!!! Object had been corrupted.
luckily that was table with logs from application and we can
easy drop table and recreate empty structure.
In metalink I found information that event 10153 should be set
to see object_id but without that in alertlog this information was.
OdpowiedzUsuńHi, Amazing your article you know I'm too lazy to sign up an account just for comment your article. it's really good and helping dude. thanks!
Oracle Training in Delhi