COntrol file failure
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: COntrol file failure

  1. #1
    Join Date
    Feb 2002
    Posts
    36
    Hi friends,
    By mistake I deleted the control file. But I have a old copy of that, with that I started the database. Instance started but finally, it gives error #ora01102-cannot mount the db in EXCLUSIVE mode. How can I open the DB in the situation. Pl help me.Thanks in advance.
    Bye
    Siva

  2. #2
    Join Date
    Aug 2001
    Posts
    390
    If you have backup copy from the back to the right location, if not copy from one of your control file and rename it to the file that was deleted( I hope you have more than one file).

    shutdown the database and start up, you won't have any problem.


  3. #3
    Join Date
    Feb 2001
    Posts
    389
    if u have multiple controlfiles , then u can just copy from the mirrored copy, else startup nomount and
    recreate the controlfile using create controlfile.

  4. #4
    Join Date
    Feb 2002
    Posts
    36
    thanks gpsingh and mike73,
    The problem is I dont have backup copy of the file that I deleted. I have very old one, with that I have problem So I created te control in Nomount stage by using following script

    create controlfile database "test" noresetlogs
    maxlogfiles 32
    maxlogmembers 2
    maxdatafiles 1
    maxloghistory 1815
    logfile
    group 1 'c:\oracledb\log1test.ora',
    group 2 'c:\oracledb\log2test.ora'
    datafile
    'c:\oracledb\systest.ora'
    ;

    I end up with follwoing errors, control file creation failed and
    ora-01158, Database already mounted,
    I started the database with Nomount only.
    I dont know Where I went wrong. Pl hlep me
    bye
    siva

  5. #5
    Join Date
    Mar 2002
    Posts
    60
    Try shutdown abort;

    and then startup nomount again..


  6. #6
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    After creating the controlfile, shutdown the database, execute the controlfile

    kishore
    Thanks
    Kishore Kumar

  7. #7
    Join Date
    Feb 2001
    Posts
    389
    there must be another message accompanying this message , reuse before database keyword
    and be sure u have the current logfiles.
    then do startup nomount and create the controlfle.I hope the database is not already corrupt.

  8. #8
    Join Date
    Feb 2002
    Posts
    36
    Is the control file script correct?, I have not disturbed any other file.Only I deleted was control file.
    repeatedly I am getting similar error message

    bye
    Siva

  9. #9
    Join Date
    Mar 2002
    Posts
    60
    Send other error messages in detail...
    There should be some more messages..

  10. #10
    Join Date
    Feb 2002
    Posts
    36
    this waht I have done

    SVRMGR> startup pfile=c:\oracledb\inittest.ora nomount
    ORACLE instance started.
    Total System Global Area 8509232 bytes
    Fixed Size 46136 bytes
    Variable Size 7529208 bytes
    Database Buffers 409600 bytes
    Redo Buffers 524288 bytes

    SVRMGR> @c:\oracledb\control.sql
    create controlfile database "test" noresetlogs
    *
    ORA-01503: CREATE CONTROLFILE failed
    ORA-01158: database already mounted
    SVRMGR>

    this is what I got, I have no error message.
    Pl help me
    BYe
    siva

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