ORA-00205: error in identifying control file

user513296

SQL> startup
ORACLE instance started.

Total System Global Area 96468992 bytes
Fixed Size 1278688 bytes
Variable Size 88083744 bytes
Database Buffers 4194304 bytes
Redo Buffers 2912256 bytes
ORA-00205: error in identifying control file, check alert log for more info


SQL> SHOW PARAMETERS control_files

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string /opt/oracle/102/dbs/ora_contro
l1, /opt/oracle/102/dbs/ora_co
ntrol2
SQL> SELECT VALUE
FROM V$PARAMETER
WHERE NAME = 'control_files'
/
2 3 4
VALUE
--------------------------------------------------------------------------------
/opt/oracle/102/dbs/ora_control1, /opt/oracle/102/dbs/ora_control2

SQL>

Pavan Kumar

Hi,

Error information is very much informative.
try to check the control files existence with respect to path which you specified using different methods
If file exists - then check across whether file is correct/valid enough (not corrupted)
check for that it refers to correct control file (not of different database control file)
Check for access permission of control files to oracle user.

- Pavan Kumar N

user513296

I have checked their existence and they are not exist :

/>ls -l /opt/oracle/102/dbs/ora_control1
/opt/oracle/102/dbs/ora_control1: No such file or directory
/>ls -l /opt/oracle/102/dbs/ora_control2
/opt/oracle/102/dbs/ora_control2: No such file or directory
/>

sb92075

Then you need to make new control files as below

STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "V112" NORESETLOGS  NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 '/u01/app/oracle/oradata/v112/redo01.log'  SIZE 50M BLOCKSIZE 512,
  GROUP 2 '/u01/app/oracle/oradata/v112/redo02.log'  SIZE 50M BLOCKSIZE 512,
  GROUP 3 '/u01/app/oracle/oradata/v112/redo03.log'  SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
  '/u01/app/oracle/oradata/v112/system01.dbf',
  '/u01/app/oracle/oradata/v112/sysaux01.dbf',
  '/u01/app/oracle/oradata/v112/undotbs01.dbf',
  '/u01/app/oracle/oradata/v112/users01.dbf',
  '/u01/app/oracle/oradata/v112/example01.dbf'
CHARACTER SET AL32UTF8
;
-- Commands to re-create incarnation table
-- Below log names MUST be changed to existing filenames on
-- disk. Any one log file from each branch can be used to
-- re-create incarnation records.
-- ALTER DATABASE REGISTER LOGFILE '/u01/app/oracle/flash_recovery_area/V112/archivelog/2010_12_17/o1_mf_1_1_%u_.arc';
-- ALTER DATABASE REGISTER LOGFILE '/u01/app/oracle/flash_recovery_area/V112/archivelog/2010_12_17/o1_mf_1_1_%u_.arc';
-- Recovery is required if any of the datafiles are restored backups,
-- or if the last shutdown was not normal or immediate.
RECOVER DATABASE
-- Database can now be opened normally.
ALTER DATABASE OPEN;
-- Commands to add tempfiles to temporary tablespaces.
-- Online tempfiles have complete space information.
-- Other tempfiles may require adjustment.
ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/app/oracle/oradata/v112/temp01.dbf'
     SIZE 39845888  REUSE AUTOEXTEND ON NEXT 655360  MAXSIZE 32767M;
-- End of tempfile additions.

Pavan Kumar

hi,

Sorry for bit a late reply... as I as away @ dinner.
okay.. you have got reply from sb92075, either you can proceed with that else if you have rman backups of the existing database then you can restore the control files from latest backup. That might solve your problem. In case of abssence of catalog db or tbs totally then you have to follow as sb92075 said across.

- Pavan Kumar N

EdStevens

user513296 wrote:
I have checked their existence and they are not exist :

/>ls -l /opt/oracle/102/dbs/ora_control1
/opt/oracle/102/dbs/ora_control1: No such file or directory
/>ls -l /opt/oracle/102/dbs/ora_control2
/opt/oracle/102/dbs/ora_control2: No such file or directory
/>

And as an additional follow up to Pavan and SB ...

You made a fatal mistake in keeping both copies of the control file in the same directory. The entire purpose of multiplexing control files (and redo log files, BTW) is to minimize the possibility of losing all of them. At the VERY LEAST they should be in directories that are separate all the way back to root:

/ora01/oradata/ora_control1.ctl
/ora02/oradata/ora_control2.ctl

And ideally, in /ora01 and /ora02 will be on separate physical disks (diskgroups in a SAN) fed by separate disk controllers.

Read about multiplexed control files in the very fine Concepts Manual at http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/physical.htm#CNCPT404

CKPT

ORA-00205: error in identifying control file

Well, Lost of controlfiles.. If you have any old backup of controlfile restore it, take an trace of that controlfile, and then recreate the controlfile. There is no other option.
One more check is lost of only controlfiles or datafiles too ?? ;-)