DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: controlfile identification error

  1. #1
    Join Date
    Oct 2000
    Posts
    449
    Hi:
    A tough situation..
    I have a db instance just created and was up and running.
    oracle 8i, no archive log and no backup yet..
    one of the QA guys accidentally ran a create database script..
    and i guess messed up a few things..
    after doing a shutdown abort, i cant even bring the databse to mount stage.. Is the db a big trash already?? Any chances..
    ORA-00205: error in identifying controlfile, check alert log for more info...
    What can be done..Any clues??


  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Check your init.ora file to make sure the control_files paramter is pointing to one of the correct control files. If the control file was toasted, you will have to do an incomplete recovery and re-create your control files.
    Jeff Hunter

  3. #3
    Join Date
    Oct 2000
    Posts
    449
    It is a toast Jeff..
    I check the location of control files and wow..
    They dont exist...
    I cannot even come to mount stage if I have to do incomplete recovery or even creating a controlfile..
    So, what's next??
    Thx..

  4. #4
    Join Date
    Oct 2000
    Posts
    449
    Continuation to the above scenario::
    The user ran the database script and when the problem occured he promptly deleted the control files manually and reran the script.. so i guess nothing can be done..
    thanks..

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    1. startup nomount
    2. issue create controlfile command (http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/statem4b.htm#2061202)
    3. shutdown immediate
    4. startup mount
    5. alter database recover until cancel using backup controlfile
    6. alter database recover cancel
    7. alter database open resetlogs
    Jeff Hunter

  6. #6
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Create only the control file and you should be able to recover it with above steps
    Thanks
    Kishore Kumar

  7. #7
    Join Date
    Oct 2000
    Posts
    449
    Jeff and sreddy:
    Please check the syntax underneath..
    tried creating a controlfile and it errors out when i did not mention the datafile name (system.dbf)..
    But when i included system.dbf again it errored out..
    where am i doing wrong??
    The logfile destination, i copied exactly from our create database script so that i will not make a mistake..

    *****

    create controlfile reuse
    database nbs
    logfile group 1 '/u02/oradata/nbs/redo01.log' size 5120k,
    group 2 '/u02/oradata/nbs/redo02.log' size 5120k,
    group 3 '/u02/oradata/nbs/redo03.log' size 5120k

    noresetlogs
    datafile '/u01/oradata/nbs/system.dbf' size 500M
    character set WE8ISO8859P1;
    [oracle-dominator]/export/home/oracle>

    SVRMGR> @/export/home/oracle/create.ctl
    create controlfile reuse
    *
    ORA-01503: CREATE CONTROLFILE failed
    ORA-01565: error in identifying file '/u01/oradata/nbs/system.dbf'
    ORA-27037: unable to obtain file status
    SVR4 Error: 2: No such file or directory
    Additional information: 3
    SVRMGR>

    thx..


  8. #8
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    st,

    Here you see my production 734 version controlfile backed up to trace. Is system file is the only one you have in the database ? do you have other files too..... you have to include all the files of database.

    ------------------from here---------------------------

    STARTUP NOMOUNT
    CREATE CONTROLFILE REUSE DATABASE "HRTS" NORESETLOGS NOARCHIVELOG
    MAXLOGFILES 32
    MAXLOGMEMBERS 4
    MAXDATAFILES 1022
    MAXINSTANCES 3
    MAXLOGHISTORY 300
    LOGFILE
    GROUP 1 (
    '/oracle/oradata/hrts/redo/log_1a.dbf',
    '/oracle2/oradata/hrts/redo/log_1b.dbf'
    ) SIZE 1M,
    GROUP 2 (
    '/oracle/oradata/hrts/redo/log_2a.dbf',
    '/oracle2/oradata/hrts/redo/log_2b.dbf'
    ) SIZE 1M,
    GROUP 3 (
    '/oracle/oradata/hrts/redo/log_3a.dbf',
    '/oracle2/oradata/hrts/redo/log_3b.dbf'
    ) SIZE 1M
    DATAFILE
    '/oracle/oradata/hrts/data/system_01.dbf',
    '/oracle/oradata/hrts/data/rollback_01.dbf',
    '/oracle3/oradata/hrts/data/tools_01.dbf',
    '/oracle3/oradata/hrts/data/users_01.dbf',
    '/oracle2/oradata/hrts/data/hr11_01.dbf',
    '/oracle3/oradata/hrts/data/hr11indx_01.dbf',
    '/oracle3/oradata/hrts/data/temp_01.dbf'
    ;

    [Edited by sreddy on 01-10-2001 at 07:43 PM]

  9. #9
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    metalink doc

    [url]http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=1012929.6[/url]

  10. #10
    Join Date
    Oct 2000
    Posts
    449
    Thanks for the links sreddy..
    It is very clear in metalink(with syntax)..
    let me ask you, once i create the control file and run it through as per the one in metalink, i dont have to follow the remaining steps of what jeff mentioned right... such as 4 to 7, coz the end of control file script includes alter db open..
    once the db is open, i am in shape, right..
    Am i making sense?? If not, please let me know..
    Ps: The logfiles and datafiles might be having an SCN and when new control file gets created how will it share the new number.. when i dont go with resetlogs..
    Thx..

Posting Permissions

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


Click Here to Expand Forum to Full Width