Thursday, September 24, 2009

ORA-00214: controlfile xxx version yyy inconsistent with file zzzz.

My database server was crashed and when I try start the database, it show error.

SQL> startup
ORACLE instance started.

Total System Global Area 536870912 bytes
Fixed Size 780056 bytes
Variable Size 275519720 bytes
Database Buffers 260046848 bytes
Redo Buffers 524288 bytes
ORA-00214: controlfile '/oracle/product/10.2.0/oradata/emrep/control01.ctl'
version 61130 inconsistent with file
'/oracle/product/10.2.0/oradata/emrep/control02.ctl' version 61127

resolve by
look in the version of checkpoint in control file which one is lastest update.
In this situation 'control01.ctl' is the lastest update so I will change init file to use only 'control01.ctl'

Existing:
*.control_files='/oracle/product/10.2.0/oradata/emrep/control01.ctl','/oracle/product/10.2.0/oradata/emrep/control02.ctl','/oracle/product/10.2.0/oradata/emrep/control03.ctl'

New:
*.control_files='/oracle/product/10.2.0/oradata/emrep/control01.ctl'


SQL> shutdown immediate
SQL> startup pfile=inittatshuya.ora
ORACLE instance started.

Total System Global Area 536870912 bytes
Fixed Size 780056 bytes
Variable Size 275519720 bytes
Database Buffers 260046848 bytes
Redo Buffers 524288 bytes
Database mounted.
Database opened.



You should to shutdown again and copy control01.ctl to control02.ctl and control03.ctl.
and change your init file to the old.

No comments: