Forum Stats

  • 3,769,484 Users
  • 2,252,969 Discussions
  • 7,875,053 Comments

Discussions

ORA-00205: error in identifying control file

user513296
user513296 Member Posts: 18
edited May 22, 2011 7:32AM in General Database Discussions
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>

Answers

  • Pavan Kumar
    Pavan Kumar Member Posts: 11,904 Gold Crown
    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
    user513296 Member Posts: 18
    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
    sb92075 Member Posts: 42,196 Blue Diamond
    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
    Pavan Kumar Member Posts: 11,904 Gold Crown
    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
    EdStevens Member Posts: 28,525 Gold Crown
    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
    CKPT Member Posts: 9,955 Silver Crown
    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 ?? ;-)
This discussion has been closed.