ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [],[], [], [], [], [], [], [], []

Cause:

After database failure , i tried to recover the database using the archivelogs but got internal errors while database open.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [],
[], [], [], [], [], [], [], []

Workaround:

When i checked the trace file , i came to find out that the archivelog header was corrupted and due to that there was a broken recover. The archivelog header was not accessible by rman.

2021-08-12 00:02:19.203221*:KRB:krb.c@2723:krbvah(): archivelog header validation failure for file /apps01/oradata/orcl19xredo01.log
2021-08-12 00:02:19.203221*:KRB:krb.c@2726:krbvah():   kcfidm()=1, fhn->kcrfhhdr.kccfhdbi=0xf15174dc, dbi_krbali=0xf15174dc
2021-08-12 00:02:19.203221*:KRB:krb.c@2730:krbvah():   ali->thr_krbali=1, fh->kcrfhthr=1
2021-08-12 00:02:19.203221*:KRB:krb.c@2733:krbvah():   ali->seq_krbali=79, fh->kcrfhrbh.kcrbhseq=1
2021-08-12 00:02:19.203221*:KRB:krb.c@2737:krbvah():   ali->bsz_krbali=512, fh->kcrfhhdr.kccfhbsz=512
2021-08-12 00:02:19.203221*:KRB:krb.c@2740:krbvah():   ali->rls_krbali=0x0000.01689d45
2021-08-12 00:02:19.203221*:KRB:krb.c@2744:krbvah():   fh->kcrfhrls=0x0000.01bb37bc
2021-08-12 00:02:19.203221*:KRB:krb.c@2746:krbvah():
2021-08-12 00:02:19.203221*:KRB:krb.c@2747:krbvah():   ali->rlc_krbali=1079310441, fh->kcrfhrlc=1080323109
2021-08-12 00:02:19.203221*:KRB:krb.c@2750:krbvah():   ali->los_krbali=0x0000.01b7e5a8
2021-08-12 00:02:19.203221*:KRB:krb.c@2753:krbvah():   fh->kcrfhlos=0x0000.01bb37bc
2021-08-12 00:02:19.203221*:KRB:krb.c@2755:krbvah():
2021-08-12 00:02:19.203221*:KRB:krb.c@2756:krbvah():   ali->lot_krbali=1080235844, fh->kcrfhlot=1080323109
2021-08-12 00:02:19.203221*:KRB:krb.c@2759:krbvah():   ali->nxs_krbali=0x0000.01bb37bb
2021-08-12 00:02:19.203221*:KRB:krb.c@2762:krbvah():   fh->kcrfhnxs=0x0000.01bb66f1
2021-08-12 00:02:19.203221*:KRB:krb.c@2764:krbvah():
2021-08-12 00:02:19.203221*:KRB:krb.c@2765:krbvah():   ali->nxt_krbali=1080313680, fh->kcrfhnxt=1080342581
2021-08-12 00:02:19.203221*:KRB:krb.c@2768:krbvah():   ali->fl2_krbali=0x0, fh->kcrfhflg=0x10800000
2021-08-12 00:02:19.203221*:KRB:krb.c@3282:krbrrat():
***
Corrupt block seq: 79 blocknum=1.
Bad header found during accessing archived log
Data in bad block - flag:1. format:34. bno:1. seq:1
beg:0 cks:62096
calculated check value: 62096

2021-08-12 00:02:19.203221*:KRB:krb.c@3346:krbrrav(): Reread of seq=79, blocknum=1, file=/apps01/oradata/orcl19xredo01.log, found same corrupt data
2021-08-12 00:02:19.203221*:KRB:krb.c@3346:krbrrav(): Reread of seq=79, blocknum=1, file=/apps01/oradata/orcl19xredo01.log, found same corrupt data
2021-08-12 00:02:19.203221*:KRB:krb.c@3346:krbrrav(): Reread of seq=79, blocknum=1, file=/apps01/oradata/orcl19xredo01.log, found same corrupt data
2021-08-12 00:02:19.203221*:KRB:krb.c@3346:krbrrav(): Reread of seq=79, blocknum=1, file=/apps01/oradata/orcl19xredo01.log, found same corrupt data
2021-08-12 00:02:19.203221*:KRB:krb.c@3346:krbrrav(): Reread of seq=79, blocknum=1, file=/apps01/oradata/orcl19xredo01.log, found same corrupt data
*** ACTION NAME:(0000003 STARTED55) 2021-08-12 00:02:19.214

2021-08-12 00:02:19.214115*:KRB:krb.c@2723:krbvah(): archivelog header validation failure for file /apps01/oradata/orcl19xredo03.log
2021-08-12 00:02:19.214115*:KRB:krb.c@2726:krbvah():   kcfidm()=1, fhn->kcrfhhdr.kccfhdbi=0xf15174dc, dbi_krbali=0xf15174dc
2021-08-12 00:02:19.214115*:KRB:krb.c@2730:krbvah():   ali->thr_krbali=1, fh->kcrfhthr=1
2021-08-12 00:02:19.214115*:KRB:krb.c@2733:krbvah():   ali->seq_krbali=78, fh->kcrfhrbh.kcrbhseq=0
2021-08-12 00:02:19.214115*:KRB:krb.c@2737:krbvah():   ali->bsz_krbali=512, fh->kcrfhhdr.kccfhbsz=512
2021-08-12 00:02:19.214115*:KRB:krb.c@2740:krbvah():   ali->rls_krbali=0x0000.01689d45
2021-08-12 00:02:19.214115*:KRB:krb.c@2744:krbvah():   fh->kcrfhrls=0x0000.01bb37bc
2021-08-12 00:02:19.214115*:KRB:krb.c@2746:krbvah():

Quick solution is to manually perform recover

--if the database is not in mount state,then mount it first
SQL> startup mount;

Perform SQLPLUS recover and open the database


SQL> recover database;
Media recovery complete.
SQL> alter database open;

Database altered.

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