Tuesday 9 September 2014

ORA-00214 error code in oracle database

Issue:
ORA-00214: control file '/u01/app/oradata/soaclone/control02.ctl' version 88384
inconsistent with file '/u01/app/oradata/soaclone/control01.ctl' version 88807

Root Cause: An inconsistent set of control files was used.

Solution: 
[oracle@soauat132 soaclone]$ cp control02.ctl control02.ctl_bkp (for safe side)
[oracle@soauat132 soaclone]$ cp control01.ctl control01.ctl_bkp (for safe side)
[oracle@soauat132 soaclone]$ cp control01.ctl control02.ctl
[oracle@soauat132 soaclone]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/bin/
[oracle@soauat132 bin]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 10 05:54:31 2014

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1104814080 bytes
Fixed Size                  1335980 bytes
Variable Size             671092052 bytes
Database Buffers          419430400 bytes
Redo Buffers               12955648 bytes
Database mounted.
Database opened.
SQL> select name,status from v$instance,v$database;

NAME      STATUS
--------- ------------
SOACLONE  OPEN

SQL>

==============Hope it will help you==========



No comments:

Post a Comment