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.