Solution to error ORA-00214 CRS-5017 PRCR-1079

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
Previous
Next Post »