Hello Friend's,
In this post we will discuss about error of inconsistent control file. The Error the solution to error (ORA-00600 [kcratr_scan_lastbwr] ).
so let's get started.
error recieved will be as below :
[oracle@dm01gg01 ~]$ srvctl start database -d CDBSOURCE
PRCR-1079 : Failed to start resource ora.cdbsource.db
CRS-5017: The resource action "ora.cdbsource.db start" encountered the following error:
ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [], [], [], [], [], [], [], [], []
. For details refer to "(:CLSN00107:)" in "/oracle/app/grid/diag/crs/dm01gg01/crs/trace/ohasd_oraagent_grid.trc".
CRS-2674: Start of 'ora.cdbsource.db' on 'dm01gg01' failed
Database will be in idel instance start the database in mount mode
[oracle@dm01gg01 ~]$
[oracle@dm01gg01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Wed Jul 29 09:00:28 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL> exit
Disconnected
[oracle@dm01gg01 ~]$
[oracle@dm01gg01 ~]$
[oracle@dm01gg01 ~]$ srvctl start database -d CDBSOURCE -o mount
[oracle@dm01gg01 ~]$
[oracle@dm01gg01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Wed Jul 29 09:01:15 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> select name, open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
CDBSOURC MOUNTED
SQL>
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED MOUNTED
3 PDBSOURCE MOUNTED
SQL>
Now as the database is in mount state try to recover the database until cancel with allow corruption.
SQL> alter database recover;
alter database recover
*
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-00756: recovery detected a lost write of a data block
ORA-10567: Redo is inconsistent with data block (file# 13, block# 111506, file
offset is 913457152 bytes)
ORA-10564: tablespace BIGTAB
ORA-01110: data file 13:
'+DATA/CDBSOURCE/AA66C825B554626EE055020C2959BEBA/DATAFILE/bigtab.276.1045939683
'
ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 73191
SQL> recover database using backup controlfile until cancel allow 10 corruption;
ORA-00279: change 2135377 generated at 07/28/2020 17:00:57 needed for thread 1
ORA-00289: suggestion : +DATA/CDBSOURCE/ARCHIVELOG/2020_07_29/thread_1_seq_78.310.1047027687
ORA-00280: change 2135377 for thread 1 is in sequence #78
Specify log: {=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00279: change 2137403 generated at 07/28/2020 17:07:06 needed for thread 1
ORA-00289: suggestion : +DATA
ORA-00280: change 2137403 for thread 1 is in sequence #79
ORA-00278: log file '+DATA/CDBSOURCE/ARCHIVELOG/2020_07_29/thread_1_seq_78.310.1047027687' no longer needed for this recovery
Once the recovery is completed try to open the database in resetlogs mode, if its still gives error the do the below steps.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '+DATA/CDBSOURCE/DATAFILE/system.257.1045762415'
create pfile from spfile and add _allow_resetlogs_corruption=true parameter in pfile and start database with pfile.
make sure as the database open immediately take a full backup of database.
SQL> startup mount pfile='initCDBSOURCE.ora';
ORACLE instance started.
Total System Global Area 1157627904 bytes
Fixed Size 8792008 bytes
Variable Size 889194552 bytes
Database Buffers 251658240 bytes
Redo Buffers 7983104 bytes
Database mounted.
SQL> alter database open resetlogs;
Database altered.
Now database is up and running :
[oracle@dm01gg01 dbs]$ srvctl start database -d CDBSOURCE
[oracle@dm01gg01 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Wed Jul 29 10:49:51 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> set pages 9999 lines 300
col OPEN_MODE for a10
col HOST_NAME for a30
select name DB_NAME,HOST_NAME,DATABASE_ROLE,OPEN_MODE,log_mode,version DB_VERSION,LOGINS,to_char(STARTUP_TIME,'DD-MON-YYYY HH24:MI:SS') "DB UP TIME" from v$database,v$instance;
SQL> SQL> SQL>
DB_NAME HOST_NAME DATABASE_ROLE OPEN_MODE LOG_MODE DB_VERSION LOGINS DB UP TIME
--------- ------------------------------ ---------------- ---------- ------------ ----------------- ---------- -----------------------------
CDBSOURC dm01gg01.database.com PRIMARY READ WRITE ARCHIVELOG 12.2.0.1.0 ALLOWED 29-JUL-2020 10:47:08
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBSOURCE READ WRITE NO
ConversionConversion EmoticonEmoticon