Your Doorstep to the Temple of Oracle

Oracle EBS

Crash recovery fails Ora-600 [Kcrf_rsw_init-2]

Posted by appsdba11i on November 15, 2011

HI friends.

recently one of our client Test DB crahsed & datafiles corrupted. so we restored a backup(hot snap)
and we got this error while recovering database

ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [kcrf_rsw_init_2], [207], [202],
[2], [], [], [], [], [], [], [], []

Cause :
========

During instance recovery the current online redolog header is read and it compare the information in the header against
the information in the controlfile – if the information in the controlfile is corrupt or out of sync then
ORa-00600 [kcrf_rsw_init-2] is raised.

Solution
============
1) SQL>STARTUP MOUNT

2) Find current online redolog with following query

SQL>SELECT F.MEMBER, V.THREAD#, V.SEQUENCE#, V.GROUP#, V.STATUS
FROM V$LOG V, V$LOGFILE F WHERE V.GROUP# = F.GROUP#;

3) use this redologs for recovery

SQL>RECOVER DATABASE USING BACKUP CONTROFILE UNTIL CANCEL;

When prompted for the log sequence supply the name of the current online redolog then reopen:

4)Once after log applied,open the database

SQL>ALTER DATABASE OPEN RESETLOGS;

Reference Note :
==================
Crash recovery fails Ora-600 [Kcrf_rsw_init-2] (Doc ID 1313954.1)

Thanks
Reddy

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

 
%d bloggers like this: