Recover using backup controlfile
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Recover using backup controlfile

  1. #1
    Join Date
    Jan 2003
    Location
    Bahrain
    Posts
    109

    Recover using backup controlfile

    Hi all,

    Disk which contains all of my controlfile got corrupted.

    Steps Followed
    ---------------

    1) Shutdown the database
    2) Copied the yesterday controlfile binary backup to init.ora control fie location
    3) startup mount
    4) recover datbase using backup controlfile(Selected auto option. It applied all the archive log files)
    5) alter database open reselogs;

    Now getting the following error


    alter database open resetlogs
    *
    ERROR at line 1:
    ORA-01113: file 1 needs media recovery
    ORA-01110: data file 1:

    Please guide me how to reover my database in this situation.

    Thanks,
    Seelan

  2. #2
    Join Date
    Jan 2003
    Location
    Bahrain
    Posts
    109
    Hi,

    Again I issued the command

    recover database using backup controlfile;


    it was asking for non existent archive log file

    I have pasted the one logile from each group and media recovery got completed.

    Now the datbase is up

    Seelan

  3. #3
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Nice job Seelan.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  4. #4
    Join Date
    Jun 2006
    Posts
    259
    Since your DB is now up.

    Issue the following: alter database backup controlfile to trace;
    Next look at the udump trace file that is created....

    You didn't have to do "alter database open resetlogs"....

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