Problem while doing recovery using backup controlfile
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Problem while doing recovery using backup controlfile

  1. #1
    Join Date
    Aug 2000
    Posts
    30
    Hi all,

    1. I have created a new controlfile using the create controlfile command.

    2. while opening the db , I got the following error.
    ORA-01113 File 1 needs media recovery
    ORA-01110 data fiel 1: 'e:\test\sys1test.ora'

    3. Tried, RECOVER DATABASE USING BACKUP CONTROLFILE;

    ORA-00289 suggestion: e:\archive\tests0000000055.arc

    But the suggested file is missing , what should i do?

    Thanks in advance
    Jee

  2. #2
    Join Date
    Jun 2000
    Posts
    179
    After creating a new control file you will need to recover the database by typing ( at the server manager ) nomount mode :

    Recover Database;
    Hisham Nagia
    IT Manager For Development
    Oracle Consultant - OCP

  3. #3
    Join Date
    Nov 2000
    Posts
    245
    you can use
    RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
    press RTN for each arch log
    enter "cancel" when the file missing.

  4. #4
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Apply all the archive logs as long as they are available. If you are still concerned about database loss, you may also want to give the present redo log also. Then enter cancel and open the database. It should work.
    Thanks
    Kishore Kumar

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