DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 20 of 20

Thread: Control File-Urgent

  1. #11
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well unfortunately I think your databse's gone for good

  2. #12
    :D
    Try a RECOVER DATABASE
    and then put CANCEL
    Cross your fingers and open it, if you can't, sorry, It's asistolic (dead).
    I guess that's why you must put a timeout in log switch.
    Ramon Caballero, DBA, rcaballe@yahoo.com

  3. #13
    Join Date
    Nov 2000
    Posts
    157
    HI

    WHEN I AM USING THE RECOVER DATABASE UNTIL CANCEL THE ERROR MESSAGE IS:

    ORA-00283:RECOVERY SESSION CANCELLED DUE TO ERRORS.
    ORA-01610:RECOVERY USING THE BACKUP CONTROLFILE OPTION MUST BE DONE.

    ANY IDEA TO RESOLVE THIS

    THANKS
    RAVI
    ravi

  4. #14
    SQL> recover database using backup controlfile until cancel;
    Ramon Caballero, DBA, rcaballe@yahoo.com

  5. #15
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    er I didnt know you can use until cancel option in noarchive mode databases :0

  6. #16
    Join Date
    Nov 2000
    Posts
    157
    Hi

    when i am using recover database using backup controlfile until cancel.The error message is:

    ora-00279: change 32498 generated at 03/09/01 needed for thread 1
    ora-00289: suggestion: d:\orant\rdbms73\%oracle_sid%00599.001
    ora-00280: change 32498 for thread 1 is in sequence #599
    specify log:<<ret>=suggested|filename\auto|cancel

    I TYPED AUTO

    ora-00308:cannot open archivedlog 'D:\orant\rdbms73\%oracle_sid%00599.001'
    ora-09202:sfisi:error identifying file
    osd-04002:unable to open file
    0/s-error:<os 2> the system cannot find the file specified;

    Any solution plz.

    Thanks for all your help
    Ravi

    ravi

  7. #17
    Put cancel.
    If you had backed up the online redo logs before the CREATE CONTROLFILE...RESETLOGS, you could apply it like archived redo logs.
    So put cancel.
    If it says the DB is inconsistent, it doesn't matter as long as you can export the data.
    Put cancel and then ALTER DATABASE OPEN RESETLOGS;
    Sorry about my english I don't know how to say in the time (ficticious, wishfull time)
    Ramon Caballero, DBA, rcaballe@yahoo.com

  8. #18
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well before do anything to this half dead database... back it up

    then do the recovery, when it asks you for the log it must be one of online redo logs, you have to guess which you should apply and type manually the file name NOT auto

  9. #19
    Join Date
    Nov 2000
    Posts
    157
    Hey ramon/pando & All

    Please First of all accept my Thanks.

    I did it.

    I deleted the previous control file which i created now and the i recreated a control file with NORESETLOGS.

    SO IT MAKES THE NEW CONTROLFILE CURRENT.

    Then i issued alter database open resetlogs.That's it.All done.

    Thank you very much
    Ravi
    ravi

  10. #20
    Join Date
    Sep 2000
    Posts
    362
    what are the side effects of Recover until Cancel ??

    Thanks
    Anurag


    [Edited by anuragmin on 03-12-2001 at 06:04 PM]

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