你在这里

Oracle ORA-00600 [kcrf_resilver_log_1] on restart after system crash

Posted by PDSERVICE on 11月 15, 2015 In

Oracle ORA-00600 [kcrf_resilver_log_1] on restart after system crash

----- Current SQL Statement for this session (sql_id=1h50ks4ncswfn) -----

ALTER DATABASE OPEN

----- Call Stack Trace -----

kgeasnmierr

kcrf_write_zeroblks

kcrfis

kcrfais

kcrfr_read_disk

kcrfr_read

kcrfrgv

kcratr_scan

kcratr

kctrec

kcvcrv

Cause

Unpblished Bug 9056657: BOX REBOOT DURING UPGRADE CAUSED ORA-600 [KCRF_RESILVER_LOG_1]

There has been a lost write to the online redolog as a result of the crash.

The fix for this bug will raise a more meaning log corruption error rather than an ORa-00600 error.

Instance recovery is not possible - restore the database and do point in time recovery to the most recent archivelog.

Solution

Unpublished Bug 9056657 is included in 11.2.0.2 Patch Set Release.

Backports may be requested.