Db Error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Db Error

  1. #1
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401

    Db Error

    Guys,

    I was running a query and got the following error
    end of communication channel !!

    I did the following to recover my DB:(linux)
    1/renamed all my instance folders and re installed and removed the new ctl and dbf files from the new folders and copied the old ones to the new folder.In the past i did this it worked fine

    I got the follwing messages this time after i started the DB

    SVRMGR> alter database recover until cancel;
    alter database recover until cancel
    *
    ORA-00279: change 1722310635758 generated at 11/16/02 14:20:29 needed for thread
    1
    ORA-00289: suggestion : /u01/app/oracle/product/8.0.5/dbs/arch1_65536.dbf
    ORA-00280: change 1722310635758 for thread 1 is in sequence #65536
    SVRMGR> alter database open resetlogs;
    alter database open resetlogs
    *
    ORA-01153: an incompatible media recovery is active
    SVRMGR> quit
    Server Manager complete.


    any advise!!Any little help also much appreciated!!!

    Thank you

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    I don't understand the connection between the "end-of-file on communication chanel" error, and the reason for needing a db recovery. Why were you doing the recovery?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401

    DBERROR -urgen

    I am sorry to confuse you all


    Pls suggest what do i need to do when i get the following error or suggest me what it means

    SVRMGR> alter database recover until cancel;
    alter database recover until cancel
    *
    ORA-00279: change 1722310635758 generated at 11/16/02 14:20:29 needed for thread
    1
    ORA-00289: suggestion : /u01/app/oracle/product/8.0.5/dbs/arch1_65536.dbf
    ORA-00280: change 1722310635758 for thread 1 is in sequence #65536
    SVRMGR> alter database open resetlogs;
    alter database open resetlogs
    *
    ORA-01153: an incompatible media recovery is active
    SVRMGR> quit
    Server Manager complete.

  4. #4
    Join Date
    Jan 2001
    Posts
    216
    3 years down the lane and I am getting the same error while recovering a database.. While searching user forums found this thread and it was unanswered. How to get around this?

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    version os and full errors that you are getting. Plus what you did to get the error

  6. #6
    Join Date
    Jan 2001
    Posts
    216
    I was attempting to practice cloning a database. Found the problem, bad syntax
    One that did not work (due to missing archivelog)-
    recover database using backup controlfile until cancel;

    One that did work (prmpted for cancel)-
    recover database until cancel using backup controlfile;

    All is well now. Thanks!

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