patternMinor
Database not able to startup showing control file is inconsistent with another
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.
Can any one help me how to resolve this issue?
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 145625Can 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 workContext
StackExchange Database Administrators Q#123917, answer score: 2
Revisions (0)
No revisions yet.