Cannot recover database 9i to OPEN
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Cannot recover database 9i to OPEN

  1. #1
    Join Date
    Mar 2002
    Posts
    10

    Cannot recover database 9i to OPEN

    I am attempting to recover my database and I have a problem doing that.

    I tried many things and finally managed to recreate my CONTROL files from _udump_dest after using backup controlfile to trace.

    when I type RECOVER DATABASE, it said that I must use backup controlfile. So, I typed

    RECOVER DATABSSE USING BACKUP CONTROLFILE;

    This is what I got. It asked for ARCHIVELOG ARC00049.001 but I don't find it on my system or it must have got deleted for some reason. Who knows?. It's just not there. I have ARC40008.001 and earlier. How to I recover my database without the ARCHIVELOG now, that that particular one is not there?.

    spool 1.txt contents.
    SQL> recover database using backup controlfile;
    ORA-00279: change 6500935 generated at 03/15/2006 20:13:50 needed for thread 1
    ORA-00289: suggestion : E:\ORACLE\ORA92\RDBMS\ARC00049.001
    ORA-00280: change 6500935 for thread 1 is in sequence #49


    Specify log: {=suggested | filename | AUTO | CANCEL}
    E:\oracle\ora92\rdbms\ARC00049.001
    ORA-00308: cannot open archived log 'E:\oracle\ora92\rdbms\ARC00049.001'
    ORA-27041: unable to open file
    OSD-04002: unable to open file
    O/S-Error: (OS 2) The system cannot find the file specified.


    Specify log: {=suggested | filename | AUTO | CANCEL}
    AUTO
    ORA-00308: cannot open archived log 'E:\ORACLE\ORA92\RDBMS\ARC00049.001'
    ORA-27041: unable to open file
    OSD-04002: unable to open file
    O/S-Error: (OS 2) The system cannot find the file specified.


    ORA-00308: cannot open archived log 'E:\ORACLE\ORA92\RDBMS\ARC00049.001'
    ORA-27041: unable to open file
    OSD-04002: unable to open file
    O/S-Error: (OS 2) The system cannot find the file specified.


    SQL> spool off
    -----------------------------------------------------

    Note: I am not a DBA and hence do not know much or I should say that I am learning. I do not have a backup because I have archivelogs set on. I don't mind recovering at any point right now. I just need to recover the database to open it.

    I have the control files but I guess they are not in sych.

    When I type alter database using backup controlfile to trace;
    I got database altered.

    then I typed recover database;
    it says ORA-00283 recovery seesion canceled due to error
    ORA-01610 recovery using backup controlfile option must be used.
    And that's what was just done. This seems to send me in circles.

    What is it that I need to do now to OPEN the database.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    you cant recover past that point if you dont have that archive log, if your datafiles / control file are in sync then you can open resetlogs

  3. #3
    Join Date
    Mar 2002
    Posts
    10

    Canot open oracle database

    Dave,

    I don't mind recovering mt DB at ANY POINT right now.
    What I want to know is this. I recreated the control files from the dump file script. When recreating the control files, does it update the database files?.

    All that has happened is that I cannot open the database.

    Does that mean that my database is gone for ever?.

    Right now, when I start, the database starts and mounts.

    When I try to open, it says in Enterprise Manager, you should open with resetlogs. I say OK.

    Then it gives me an error : ORA-01152 file 11 was not restored from a sufficiently old backup.

    ORA-01110: data file 11; 'F:\opapps\octrn\ocl_app.dbf'

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    turn it back around - why did you do what you did?

    sounds like you are shafted

  5. #5
    Join Date
    Mar 2006
    Posts
    40
    did you try:

    recover database until cancel;

    then type cancel press enter and:

    alter database open resetlogs
    go to the oracle clinic
    Quick and easy Oracle database support and consulting

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    but the logs are missing, that will be no good

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    I'm assuming ARC40008.001 is the last log archived. You'd have to verify from your alert.log, though...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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