ORA-01092: ORACLE instance terminated. Disconnection forced. - Page 3
DBAsupport.com Forums - Powered by vBulletin
Page 3 of 5 FirstFirst 12345 LastLast
Results 21 to 30 of 48

Thread: ORA-01092: ORACLE instance terminated. Disconnection forced.

  1. #21
    Join Date
    Jun 2000
    Posts
    104
    hi everybody
    now I have 2 copies of control files on same disk,suppose I add one in init.ora,then does that automatically gets created during db start or I will be placing a copy in the new location and then restart db.

    all your suggestions helped alot,and regarding mts ,can anybody say is it recommended not to use mts after oracle 7.3 and if so why???

  2. #22
    Join Date
    Jul 2000
    Location
    India
    Posts
    60
    hi friends,

    i tried to give the create controfile option in svrmgrl. but it says oracle not connected. i tried connecting as internal, sys as sysdba, etc. but the same problem persists. documentation says i need OSDBA granted, but how do i do it ?

    satishpc

  3. #23
    Join Date
    Dec 2000
    Posts
    11

    Thumbs up

    Hi,
    try:
    set oracle_sid='your sid'<enter>
    svrmgrl<enter>
    svrmgr>connect internal/'your pass'
    Connected.
    svrmgr>shutdown immediate
    Database closed.
    Database dismounted.
    ORACLE instance shut down.
    svrmgr>startup mount
    Database mounted.
    svrmgr>alter dabatase backup controlfile to 'your backup path'
    Statement processed.

    then the rest it's easy.

    hope it helps

  4. #24
    Join Date
    Jul 2000
    Location
    India
    Posts
    60
    hi,

    that is a problem. when i say startup mount or startup with anything else, it shows me all the buffer size, sga etc but after redo buffers, it shows me this error

    ORA-03113: end-of-file on commumnication channel

    and after that , if i give any command , it gives me the error

    not connected to oracle

    what can i do ? this is getting more & nore interesting . i think i will learn a lot thanks to u guys.

    satish

  5. #25
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    did you try with all control files at all to see which one is corrupted?
    If all of them are corrupted your only choice will be start the instance (startup nomount) and recreate the control file

  6. #26
    Join Date
    Jul 2000
    Location
    India
    Posts
    60
    hi,

    yes i did try with all three control files. but none of them works. all three of them are of same size. does it mean all three are corrupt ? i tried recreating but that is the problem. when i connect to svrmgrl and say create control file, it gives me an error saying oracle not connected. what do i do ?

    satishpc

  7. #27
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    did you issue startup nomount
    or
    you issued startup?

    Of course they are same size, they are mirrored copies to prevent loss of any of them. Like your case (it would be very helpful if you have one control file that works isnt it :D )

    You have to issue startup nomount in order to recreate a control file.

  8. #28
    Join Date
    Jul 2000
    Location
    India
    Posts
    60
    hi ,

    tried that. works fine. great. now i am trying to create the control file. my old control files didnt work. i tried. besied, being of the same size, they are also last modified at the same time. what does that mean ? anyway, will write back as soon as i create the control file. thanks a lot.

    satish

  9. #29
    Join Date
    Nov 2000
    Posts
    212
    may use NT comp command to compare control files: they should be the same.

    how it happened control files get lost? Are you sure now that your HW/OS is OK? I saw a case how control files where lost because of disk controler problem. Then HW problem had to be fixed first before proceeding.



  10. #30
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    itīs not lost, corruption of blocks.
    Of course control files have same modified time, they are mirrored copies. Mirror means clone, if you look yourself at the mirror you see another you.... hope this helps

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