Question Re: ORA-00205: error in identifying control file while startup database in Technology Q&A

ORA-00205: error in identifying control file while startup database

Former Member — Wed, 16 Nov 2011 05:38:32 GMT

Dear Experts,

we are using Oracle 10g on RHEL5.4 64Bit ecc 6.0 with eph 4 i have moved all my sap data files along with Temp file.

when i startup my database getting error.

SQL> startup mount

ORACLE instance started.

Total System Global Area 535662592 bytes

Fixed Size 1334380 bytes

Variable Size 306185108 bytes

Database Buffers 222298112 bytes

Redo Buffers 5844992 bytes

ORA-00205: error in identifying control file, check alert log for more info

when i checked initSID.ora then found old location of control file.

1)/oracle/SID/sapdata1/cntrl

2)/oracle/SID/origlogA/cntrl

3)/oracle/SID/origlogB/cntrl

i have manually changed location of control file.

1)/oracle/SID/sapdata10/cntrl

2)/oracle/SID/origlogA/cntrl

3)/oracle/SID/origlogB/cntrl

SQL> Create Pfile from Spfile;

File Created.

i would like to mount my database from Pfile plese help me i execute scripts below.

SQL> STARTUP MOUNT=/oracle/SID/ORACLE_HOME/dbs/initSID.ora

invalid startup option.

or suggest me some other way so that i can startup my Database.

with Regards

Re: ORA-00205: error in identifying control file while startup database

Former Member — Wed, 16 Nov 2011 05:41:43 GMT

Dear Experts,

> we are using Oracle 10g on RHEL5.4 64Bit ecc 6.0 with eph 4 i have moved all my sap data files along with Temp file.

> when i startup my database getting error.

You should not move any files manually because control file has location of all files. If you move it manually then control file will not recognize it. This process is not supported.

Thanks

Sunny

Re: ORA-00205: error in identifying control file while startup database

Former Member — Wed, 16 Nov 2011 06:05:04 GMT

Hi,

Can you re-create your controlfile so that it has updated information post movement of datafiles.

Post this try to start your database.

Steps:

1) Startup database in mount state

2) SQL> alter system backup controlfile to trace

3) check whether the path of each datafile is correct in the trace file or not. If required modify the same.

4) Create a control.sql file using the updated trace file

5) create new controlfiles using control.sql script.

In case you want to start your database using pfile use the command

STARTUP MOUNT pf=/oracle/SID/ORACLE_HOME/dbs/initSID.ora

Hope this helps.

Regards,

Deepak Kori

Re: ORA-00205: error in identifying control file while startup database

Former Member — Wed, 16 Nov 2011 06:45:22 GMT

Hi,

>> we are using Oracle 10g on RHEL5.4 64Bit ecc 6.0 with eph 4 i have moved all my sap data files along with Temp file.

How did you performed this operation? You should do this operation with "alter database rename file" command. So, if you didn't execute this command, relocate the datafiles and controlfiles to the old location. Then, open the database respectfully and move datafiles by using the statement, below. After that, shutdown the database again and copy the files physically to the new location. Under this circumstance, if you are able to open the database with the current control files, you don't need to re-create them.

alter database rename file '<source_datafile_full_path>' to '<destination_datafile_full_path>';

Best regards,

Orkun Gedik

Re: ORA-00205: error in identifying control file while startup database

Former Member — Wed, 16 Nov 2011 07:20:12 GMT

Thanks Deepak for Reply

Earlier

i have startup database in Mount state

SQL> alter system backup controlfile to trace

checked path of each datafile is correct in the trace file.

I have converted sapdata1 to sapdata10 and checked in InitSID.ora file first location of control file is picking old sapdata file.

rest of the 2 control file location is correct.

Steps to Create Control file

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE "QAS" NORESETLOGS ARCHIVELOG

MAXLOGFILES 255

MAXLOGMEMBERS 3

MAXDATAFILES 254

MAXINSTANCES 50

MAXLOGHISTORY 1168

LOGFILE

GROUP 1 ('/oracle/SID/origlogA/log_g11m1.dbf','/oracle/QAS/mirrlogA/log_g11m2.dbf') SIZE 75M,

STANDBY LOGFILE

DATAFILE

'/oracle/SID/sapdata10/system_1/system.data1'

'/oracle/SID/sapdata10/undo_1/undo.data1'

'/oracle/SID/sapdata10/sysaux_1/sysaux.data1'

'/oracle/SID/sapdata20/sr3_1/sr3.data1'

'/oracle/SID/sapdata20/sr3_2/sr3.data2'

'/oracle/SID/sapdata20/sr3_3/sr3.data3'

'/oracle/SID/sapdata20/sr3_4/sr3.data4'

'/oracle/SID/sapdata20/sr3_5/sr3.data5'

'/oracle/SID/sapdata20/sr3_6/sr3.data6'

'/oracle/SID/sapdata20/sr3_7/sr3.data7'

'/oracle/SID/sapdata20/sr3_8/sr3.data8'

'/oracle/SID/sapdata20/sr3_9/sr3.data9'

'/oracle/SID/sapdata20/sr3_10/sr3.data10'

'/oracle/SID/sapdata30/sr3701_1/sr3701.data1'

'/oracle/SID/sapdata30/sr3701_2/sr3701.data2'

'/oracle/SID/sapdata30/sr3701_3/sr3701.data3'

'/oracle/SID/sapdata30/sr3701_4/sr3701.data4'

'/oracle/SID/sapdata40/sr3usr_1/sr3usr.data1'

'/oracle/SID/sapdata40/sr3db_1/sr3db.data1'

'/oracle/SID/sapdata40/sr3db_2/sr3db.data2'

'/oracle/SID/sapdata40/sr3db_3/sr3db.data3'

CHARACTER SET UTF8

;

i execute these steps same as way to create control file or some changes in that.

Please suggest correct way to create control file.

With Regards

Re: ORA-00205: error in identifying control file while startup database

Former Member — Wed, 16 Nov 2011 07:39:39 GMT

Hi,

The steps are fine. Now could you paste the error details from alert_SID.log file once you start your database.

Need to know the error in detail.

Regards,

Deepak Kori

Re: ORA-00205: error in identifying control file while startup database

Former Member — Wed, 16 Nov 2011 08:34:32 GMT

Thanks,LOG of alert_SID.log control_files = /oracle/PRD/origlogA/cntrl/cntrlPRD.dbf, /oracle/PRD/origlogB/cntrl/cntrlPRD.dbf, /oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf, control_file_record_keep_time= 30, Mon Nov 14 08:24:52 2011

CREATE DATABASE PRD CONTROLFILE REUSE MAXLOGFILES 255 MAXLOGMEMBERS 3 MAXLOGHISTORY 1000 MAXDATAFILES 254 MAXINSTANCES 50 NOARCHIVELOG CHARACTER SET UTF8 NATIONAL CHARACTER SET UTF8 DATAFILE '/oracle/PRD/sapdata1/system_1/system.data1' SIZE 350M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M EXTENT MANAGEMENT LOCAL DEFAULT TEMPORARY TABLESPACE PSAPTEMP TEMPFILE '/oracle/PRD/sapdata1/temp_1/temp.data1' SIZE 570M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M UNDO TABLESPACE PSAPUNDO DATAFILE '/oracle/PRD/sapdata1/undo_1/undo.data1' SIZE 700M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M SYSAUX DATAFILE '/oracle/PRD/sapdata1/sysaux_1/sysaux.data1' SIZE 200M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M

LOGFILE GROUP 1 ('/oracle/PRD/origlogA/log_g11m1.dbf',

'/oracle/PRD/mirrlogA/log_g11m2.dbf') SIZE 50M REUSE ,GROUP 2 ('/oracle/PRD/origlogB/log_g12m1.dbf',

'/oracle/PRD/mirrlogB/log_g12m2.dbf') SIZE 50M REUSE ,GROUP 3 ('/oracle/PRD/origlogA/log_g13m1.dbf',

'/oracle/PRD/mirrlogA/log_g13m2.dbf') SIZE 50M REUSE ,GROUP 4 ('/oracle/PRD/origlogB/log_g14m1.dbf',

'/oracle/PRD/mirrlogB/log_g14m2.dbf') SIZE 50M REUSEMon Nov 14 08:24:53 2011Database mounted in Exclusive Mode

Mon Nov 14 08:25:06 2011Successful mount of redo thread 1, with mount id 1830841300

Assigning activation ID 1830841300 (0x6d206bd4) Thread 1 opened at log sequence 1

Current log# 1 seq# 1 mem# 0: /oracle/PRD/origlogA/log_g11m1.dbf

Current log# 1 seq# 1 mem# 1: /oracle/PRD/mirrlogA/log_g11m2.dbf,m Successful open of redo thread 1

Mon Nov 14 08:25:06 2011 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Mon Nov 14 08:25:06 2011 SMON: enabling cache recovery

Mon Nov 14 08:25:06 2011

create tablespace SYSTEM datafile '/oracle/PRD/sapdata1/system_1/system.data1' SIZE 350M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M

EXTENT MANAGEMENT LOCAL online

Mon Nov 14 08:25:09 2011

Incremental checkpoint up to RBA [0x1.3.0], current log tail at RBA [0x1.3.0]

Mon Nov 14 08:25:15 2011

Completed: create tablespace SYSTEM datafile '/oracle/PRD/sapdata1/system_1/system.data1' SIZE 350M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M

EXTENT MANAGEMENT LOCAL online

Mon Nov 14 08:25:15 2011

create rollback segment SYSTEM tablespace SYSTEM

storage (initial 50K next 50K)

Completed: create rollback segment SYSTEM tablespace SYSTEM

storage (initial 50K next 50K)

Mon Nov 14 08:25:19 2011

CREATE UNDO TABLESPACE PSAPUNDO DATAFILE '/oracle/PRD/sapdata1/undo_1/undo.data1' SIZE 700M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M

Mon Nov 14 08:25:36 2011

Successfully onlined Undo Tablespace 1.

Completed: CREATE UNDO TABLESPACE PSAPUNDO DATAFILE '/oracle/PRD/sapdata1/undo_1/undo.data1' SIZE 700M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M

Mon Nov 14 08:25:36 2011

create tablespace SYSAUX datafile '/oracle/PRD/sapdata1/sysaux_1/sysaux.data1' SIZE 200M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M

EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online

Completed: create tablespace SYSAUX datafile '/oracle/PRD/sapdata1/sysaux_1/sysaux.data1' SIZE 200M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M

EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online

Re: ORA-00205: error in identifying control file while startup database

Former Member — Wed, 16 Nov 2011 08:43:35 GMT

Furher Log

ALTER DATABASE MOUNT

MMNL started with pid=12, OS id=4432

Wed Nov 16 18:49:19 2011

ORA-00202: control file: '/oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

Wed Nov 16 18:49:19 2011

ORA-205 signalled during: ALTER DATABASE MOUNT...

Wed Nov 16 18:49:27 2011

Shutting down instance (abort)

License high water mark = 1

Instance terminated by USER, pid = 4433

Wed Nov 16 18:55:40 2011

Starting ORACLE instance (normal)

Wed Nov 16 18:55:40 2011

Specified value of sga_max_size is too small, bumping to 1191182336

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 3

Autotune of undo retention is turned on.

Version: 10.2.0.4.0.

ALTER DATABASE MOUNT

Wed Nov 16 18:26:27 2011

ORA-00202: control file: '/oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

Wed Nov 16 18:26:27 2011

ORA-205 signalled during: ALTER DATABASE MOUNT...

Wed Nov 16 18:27:46 2011

Shutting down instance (abort)

License high water mark = 1

Instance terminated by USER, pid = 4328

Wed Nov 16 18:49:18 2011

Re: ORA-00205: error in identifying control file while startup database

Former Member — Wed, 16 Nov 2011 09:10:33 GMT

> Wed Nov 16 18:49:19 2011

> ORA-00202: control file: '/oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf'

> ORA-27037: unable to obtain file status

> Linux-x86_64 Error: 2: No such file or directory

> Additional information: 3

Does control file present at location '/oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf' ?

Thanks

Sunny

Re: ORA-00205: error in identifying control file while startup database

Former Member — Wed, 16 Nov 2011 14:30:18 GMT

Dear Experts,

connected to idle instance

changed in location of control file in INITSID.ORA

SQL> startup pfile='/oracle/SID/oracle_home/dbs/initSID.ora';

ORACLE instance started.

Total System Global Area 535662592 bytes

Fixed Size 1334380 bytes

Variable Size 306185108 bytes

Database Buffers 222298112 bytes

Redo Buffers 5844992 bytes

ORA-00214: control file '/oracle/SID/origlogA/cntrl/cntrlPRD.dbf' version 3253

inconsistent with file '/oracle/SID/origlogA/cntrl/cntrlPRD.dbf' version 3218

please suggest what should do

regards

Re: ORA-00205: error in identifying control file while startup database

Former Member — Wed, 16 Nov 2011 15:37:10 GMT

Thanks Marius.Burger

i have followed same steps as u mentioned Earlier.

checked INITSID.ora file all correct location mentioned of controlfile.

SQL> startup mount

ORACLE instance started.

Total System Global Area 535662592 bytes

Fixed Size 1334380 bytes

Variable Size 306185108 bytes

Database Buffers 222298112 bytes

Redo Buffers 5844992 bytes

ORA-00205: error in identifying control file, check alert log for more info

when i checked initSID.ora then found old location of control file

Pls suggest.

Regards

Re: ORA-00205: error in identifying control file while startup database

Former Member — Wed, 16 Nov 2011 15:44:53 GMT

Hi,

Paste the detailed error from alert_SID.log

Regards,

Deepak Kori

Re: ORA-00205: error in identifying control file while startup database

Former Member — Wed, 16 Nov 2011 16:24:15 GMT

SQL> show parameter control_file;

NAME TYPE

VALUE

control_file_record_keep_time integer

control_files string

/oracle/PRD/origlogA/cntrl/cntrlPRD.dbf,

/oracle/PRD/origlogB/cntrl/cntrlPRD.dbf,

/oracle/PRD/sapdata10/cntrl/cntrlPRD.dbf

SQL> startup pfile='/oracle/PRD/102_64/dbs/initPRD.ora';

ORA-01081: cannot start already-running ORACLE - shut it down first

SQL> shutdown immediate

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> STARTUP PFILE='/oracle/PRD/102_64/dbs/initPRD.ora';

ORACLE instance started.

Total System Global Area 1191182336 bytes

Fixed Size 2083496 bytes

Variable Size 603981144 bytes

Database Buffers 570425344 bytes

Redo Buffers 14692352 bytes

Database mounted.

ORA-01122: database file 1 failed verification check

ORA-01110: data file 1: '/oracle/PRD/sapdata10/system_1/system.data1'

ORA-01207: file is more recent than control file - old control file

SQL>

Re: ORA-00205: error in identifying control file while startup database

Former Member — Wed, 16 Nov 2011 16:35:41 GMT

Hi,


ORA-01207:  ORA-01207 file is more recent than controlfile - old controlfile

Cause: The control file change sequence number in the datafile is greater than the number in the control file. This implies that the wrong control file is being used. Note that repeatedly causing this error can make it stop happening without correcting the real problem. Every attempt to open the database will advance the control file change sequence number until it is great enough.

Action: Use the current control file or do BACKUP CONTROLFILE RECOVERY to make the control file current. Be sure to follow all restrictions on doing a BACKUP CONTROLFILE RECOVERY.

You must run the RECOVER command after restoring a backup control file, even if no datafiles have been restored.

You must open the database with the RESETLOGS option after performing either complete or point-in-time recovery with a backup control file.

Hope this helps.

Regards,

Deepak Kori

Re: ORA-00205: error in identifying control file while startup database

Former Member — Fri, 18 Nov 2011 08:40:11 GMT

Hi User,

As per you question below :

Dear Experts,

connected to idle instance

changed in location of control file in INITSID.ORA

SQL> startup pfile='/oracle/SID/oracle_home/dbs/initSID.ora';

ORACLE instance started.

Total System Global Area 535662592 bytes

Fixed Size 1334380 bytes

Variable Size 306185108 bytes

Database Buffers 222298112 bytes

Redo Buffers 5844992 bytes

ORA-00214: control file '/oracle/SID/origlogA/cntrl/cntrlPRD.dbf' version 3253

inconsistent with file '/oracle/SID/origlogA/cntrl/cntrlPRD.dbf' version 3218

please suggest what should do

regards

It seems that you have control files of different version in the location specified.

This may happen if you have restored your database due to which one of the controlfiles have been modified (eg. /oracle/SID/sapdata1/cntrl/cntrlPRD.dbf) but the other controlfile locations are untouched. (eg. /oracle/SID/saparch/cntrlPRD.dbf)

Also, in such cases after you make changes (copy the new version on control files) please ensure that the old version is renamed or deleted.

Hope this helps.

Regards,

Nilesh J