Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2004
    Posts
    4

    Unanswered: Urgent: ORA-00205:Error in Identifying Controlfile

    Hi DB Experts,

    I have 2 databases 'db1' and 'db2' under Linux platform.
    When I perform dbstart, db1 is ok but db2 has message below

    **************************************************
    SQL> Connected to an idle instance.
    SQL> ORACLE instance started.

    Total System Global Area 101785940 bytes
    Fixed Size 450900 bytes
    Variable Size 75497472 bytes
    Database Buffers 25165824 bytes
    Redo Buffers 671744 bytes
    ORA-00205: error in identifying controlfile, check alert log for more info

    ************************************************** *
    I checked the INIT.ora has referenced to the correct path. How can I recreate my controlfiles? I can't even login into db2 database under sqlplus. Pls advise. Thanks

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    What does the alertlog tell you ????

    1.
    Check that the proper control file name is referenced in the CONTROL_FILES initialization parameter in the initialization parameter file and try again.

    2.
    When using mirrored control files, that is, more than one control file is referenced in the initialization parameter file, remove the control file name listed in the message from the initialization parameter file and restart the instance. If the message does not recur, remove the problem control file from the initialization parameter file and create another copy of the control file with a new file name in the initialization parameter file.

    HTH
    Gregg

  3. #3
    Join Date
    Sep 2004
    Posts
    4
    Hi Gregg,

    The alert log shows:

    ORA-00202:controlfile:'/opt/oracle/OraHome1/oradata/dev2/control01.ctl'
    ORA-27046:file size is not a multiple of logical block size.

    I have checked the initialization file points to the correct path and filename.
    What else can go wrong from here?

    Thanks

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    If you have NO controlfiles, you will have to recreate them (it)... If you have used "alter database backup controlfile to trace", then you can use
    that file's SQL statement (create controlfile ....)...

    If you have NOT been backing up the controlfile, you will have to create one manually (ensure you use the NORESETLOGS option.

    You will have to start the database with nomount in order accomplish this.

    Once you have created the controlfile, you will have to issue
    "recover database"

    HTH
    Gregg

  5. #5
    Join Date
    Sep 2004
    Posts
    4
    Thank you Gregg,

    But I have problem even accessing the SQLPLUS statement which means I am not even able to get connected to my dev2 host database. In that case how can I create my controlfiles? Appreciate your help.

  6. #6
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    You should be able to (depending on the Oracle version (8 or 9)
    to run either

    svrmgrl
    svrmgrl> startup nomount pfile ....

    sqlplus
    sql> startup nomount pfile ....

    Then create controlfile ...

    Gregg

  7. #7
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    The problem is that your db_block_size in the "init.ora" is too large. Try decreasing it, in 4k blocks until it works.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •