HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Database not able to startup showing control file is inconsistent with another

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
startupshowingfilecontrolinconsistentwithdatabaseanothernotable

Problem

Our windows server 2008 R2 is shutdown due to power failure. When I am trying to startup Oracle 11g database its shows an error.

SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> startup mount
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shut immediate
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 3206836224 bytes
Fixed Size                  2180024 bytes
Variable Size            2415922248 bytes
Database Buffers          771751936 bytes
Redo Buffers               16982016 bytes
ORA-00214: control file 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL01.CTL'
version 145627 inconsistent with file
'D:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\CONTROL02.CTL' version 145625


Can any one help me how to resolve this issue?

Solution

You should be able to resolve this by copying CONTROL01.CTL over CONTROL02.CTL since the first one has a higher version number. Make a copy of CONTROL02.CTL in case it does not work

Context

StackExchange Database Administrators Q#123917, answer score: 2

Revisions (0)

No revisions yet.