Home > TroubleShooting, Uncategorized > ORA-00214: control file ‘/u01/oracle/oradb/control01.ctl’ version 1316

ORA-00214: control file ‘/u01/oracle/oradb/control01.ctl’ version 1316

Symptoms

When starting the database, it returned the messages.

SQL> startup
ORACLE instance started.

Total System Global Area 4275781632 bytes
Fixed Size                  2220200 bytes
Variable Size            2298482520 bytes
Database Buffers         1962934272 bytes
Redo Buffers               12144640 bytes
ORA-00214: control file ‘/u01/oracle/oradb/control01.ctl’ version 1316
inconsistent with file ‘/opt/oracle/flash_recovery_area/oradb/control02.ctl’
version 1138

Fix Procedures

1. Startup nomount

SQL> startup nomount
ORACLE instance started.

Total System Global Area 4275781632 bytes
Fixed Size                  2220200 bytes
Variable Size            2298482520 bytes
Database Buffers         1962934272 bytes
Redo Buffers               12144640 bytes

2. Change control_files setting

SQL> alter system set control_files=’/u01/oracle/oradb/control01.ctl’ scope=spfile;

System altered.

3. Restart the database

SQL> shutdown immediate
ORA-01507: database not mounted

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

Total System Global Area 4275781632 bytes
Fixed Size                  2220200 bytes
Variable Size            2298482520 bytes
Database Buffers         1962934272 bytes
Redo Buffers               12144640 bytes
Database mounted.
Database opened.
SQL>
SQL> show parameter spfile

NAME                                 TYPE        VALUE
———————————— ———– ——————————
spfile                               string      /opt/oracle/product/11g/dbs/sp
fileoradb.ora
SQL> show parameter control

NAME                                 TYPE        VALUE
———————————— ———– ——————————
control_file_record_keep_time        integer     7
control_files                        string      /u01/oracle/oradb/control01.ct

Advertisements
  1. Hyeongwoo Jung
    April 4, 2014 at 7:14 am

    Wow!!!!!!!!!!! i’m korean!!! 그래서 한글로 할께요 uu DB BACKUP 테스트를 해보려고 날려서 안됫는데 저런 오류가…… 그런데 이렇게 해결이 !!!!! 정말 고맙습니다. 오류가 난이유를 대충 알겠네요 감사합니다 !!! You are expert!!!

    • April 4, 2014 at 2:08 pm

      Hyeongwoo,

      Thank you. Your comment encourage me share more on my blog.

      Regards/Jeff Wong

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: