Search This Blog

Wednesday, March 28, 2007

Control File Inconsistent


Database Version : 10.1.0.2.0
OS Windows
NoArchivelog Mode



SQL> startup
ORACLE instance started.

Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145488364 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
ORA-00214: controlfile 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\DB01\CONTROL02.CTL'
version 1302 inconsistent with file
'C:\ORACLE\PRODUCT\10.1.0\ORADATA\DB01\CONTROL01.CTL' version 1292


SQL> shutdown abort
ORACLE instance shut down.
SQL> --FIRST DELETE "control01.ctl" and create new one from "control02.ctl"
SQL> startup
ORACLE instance started.

Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145488364 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
Database mounted.
Database opened.
SQL>

No comments: