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/
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