Hello Friend's,
In this post we will discuss about error of inconsistent control file. The solution to error (ORA-00214).
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-00214: control file '+DATA/CDBSOURCE/CONTROLFILE/current.261.1045762541' version 1442346 inconsistent with file '+FRA/CDBSOURCE/CONTROLFILE/current.256.1045762541' version 1442344
. 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
check for the database instance only asm instance is running.
[oracle@dm01gg01 ~]$ ps -ef |grep pmon
grid 3014 1 0 08:27 ? 00:00:00 asm_pmon_+ASM
oracle 4349 4258 0 08:33 pts/0 00:00:00 grep --color=auto pmon
[oracle@dm01gg01 ~]$
[oracle@dm01gg01 ~]$
[oracle@dm01gg01 ~]$
[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-00214: control file '+DATA/CDBSOURCE/CONTROLFILE/current.261.1045762541' version 1442346 inconsistent with file '+FRA/CDBSOURCE/CONTROLFILE/current.256.1045 762541' version 1442344
. 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
[oracle@dm01gg01 ~]$
[oracle@dm01gg01 ~]$
[oracle@dm01gg01 ~]$ exit
logout
[root@dm01gg01 ~]# su - grid
Last login: Wed Jul 29 08:26:36 IST 2020
[grid@dm01gg01 ~]$ asmcmd
ASMCMD>
ASMCMD> lsdg
State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 512 4096 4194304 20476 3704 0 3704 0 N DATA/
MOUNTED EXTERN N 512 512 4096 4194304 10236 1080 0 1080 0 N FRA/
ASMCMD>
ASMCMD> cd +FRA/CDBSOURCE/CONTROLFILE/
ASMCMD>
ASMCMD> ls
Current.256.1045762541
ASMCMD>
ASMCMD> rm Current.256.1045762541
ASMCMD>
ASMCMD> exit
Now switch the user to oracle and start the database in nomount state as below and restore the controlfile using higher version controlfile.
[grid@dm01gg01 ~]$
[grid@dm01gg01 ~]$ su - oracle
Password:
Last login: Wed Jul 29 08:32:57 IST 2020 on pts/0
[oracle@dm01gg01 ~]$
[oracle@dm01gg01 ~]$ rman target /
Recovery Manager: Release 12.2.0.1.0 - Production on Wed Jul 29 08:50:40 2020
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> exit
Recovery Manager complete.
[oracle@dm01gg01 ~]$
[oracle@dm01gg01 ~]$ srvctl start database -d CDBSOURCE -o nomount
[oracle@dm01gg01 ~]$
[oracle@dm01gg01 ~]$ rman target /
Recovery Manager: Release 12.2.0.1.0 - Production on Wed Jul 29 08:52:03 2020
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDBSOURC (not mounted)
RMAN>
RMAN> restore controlfile to '+FRA' from '+DATA/CDBSOURCE/CONTROLFILE/current.261.1045762541';
Starting restore at 29-JUL-20
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=44 device type=DISK
channel ORA_DISK_1: copied control file copy
Finished restore at 29-JUL-20
RMAN>
RMAN> exit
Recovery Manager complete.
check the controlfile in location and database , then shutdown database and startup in open mode.
[oracle@dm01gg01 ~]$
[oracle@dm01gg01 ~]$ exit
logout
[grid@dm01gg01 ~]$
[grid@dm01gg01 ~]$ asmcmd
ASMCMD> cd +FRA/CDBSOURCE/CONTROLFILE/
ASMCMD> ls
current.256.1047027183
ASMCMD>
ASMCMD> exit
[grid@dm01gg01 ~]$
[grid@dm01gg01 ~]$ su - oracle
Password:
Last login: Wed Jul 29 08:50:32 IST 2020 on pts/0
[oracle@dm01gg01 ~]$
[oracle@dm01gg01 ~]$
[oracle@dm01gg01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Wed Jul 29 08:54:41 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>
SQL>
SQL>
SQL> show parameter controlfiles
SQL>
SQL>
SQL> show parameter control_files;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string +DATA/CDBSOURCE/CONTROLFILE/cu
rrent.261.1045762541, +FRA/CDB
SOURCE/CONTROLFILE/current.256
.1045762541
SQL>
SQL> alter system set control_files='+DATA/CDBSOURCE/CONTROLFILE/current.261.1045762541','+FRA/CDBSOURCE/CONTROLFILE/current.256.1047027183' scope=spfile;
System altered.
SQL>
SQL> shu immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL>
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@dm01gg01 ~]$ srvctl start database -d CDBSOURCE
ConversionConversion EmoticonEmoticon