DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Urgent!!! ORA-01113 file 1 needs media recovery

  1. 02-12-2002, 01:03 PM #1
    samdba's Avatar
    samdba
    samdba is offline Advisor
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620

    Question

    Hi there,

    We are on 805/NT. I am performing Cold backup recovery test on Testing server.

    I did the following.

    1. Shutdown database/instance.
    2. Zipped all datafiles, control files, redo log files and everything.
    3. Renamed all *.dbf files and redo log files to *.bdf files as if they are deleted.
    4. Unzipped everything from zip file zipped in step 2.
    5. Tried to start the database. It gave foll. message.

    ORA-01113 file 1 needs media recovery.
    ORA-01110: data file 1: 'E:\...system1.dbf'.

    Now, I have one database in *.bdf form on to the server itself and another database in zip form.

    What are the options available to me do to cleanly startup the database.

    Thanks in Adv.



    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart
    Reply With Quote Reply With Quote
  2. 02-12-2002, 01:30 PM #2
    samdba's Avatar
    samdba
    samdba is offline Advisor
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    I checked that I did not unzip one copy of control file. Is it due to that it gives the error?

    If yes, I can delete unzipped files and again do unzip with both copies of control files.

    pl. advise ASAP.

    Thanks,
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart
    Reply With Quote Reply With Quote
  3. 02-12-2002, 01:38 PM #3
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134
    Sam, this one is clearly over my head but I am fairly certain that you need ALL control files for the DB to open.

    MH
    I remember when this place was cool.
    Reply With Quote Reply With Quote
  4. 02-12-2002, 01:50 PM #4
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134
    My Bad; You only need one copy of the control file to open, since they are so small why not just copy it over without zipping it. This way you are eliminating that as a possible cause of corruption.

    Have you tried renaming the datafile to .DBF, if that is specified in the control file, than that is what oracle is looking for, no?

    MH
    I remember when this place was cool.
    Reply With Quote Reply With Quote
  5. 02-12-2002, 01:55 PM #5
    samdba's Avatar
    samdba
    samdba is offline Advisor
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Hi,
    I commented another control file in init.ora and tried to open the DB with only one control file which was unzipped. but still giving the same err. msg.

    Thanks,
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart
    Reply With Quote Reply With Quote
  6. 02-13-2002, 07:09 AM #6
    anandkl
    anandkl is offline Senior Advisor
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Retry to unzip all the files you ziped in you first step.Make sure all the files are there as it was earlier.Then start up the database it should work..

    cheese
    anandkl
    anandkl
    Reply With Quote Reply With Quote
  7. 02-13-2002, 07:29 AM #7
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Are you sure the database closed cleanly, did you shut it down with an immediate or normal?

    It might be worth checking the alert log to make sure.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!
    Reply With Quote Reply With Quote
  8. 02-13-2002, 10:16 AM #8
    samdba's Avatar
    samdba
    samdba is offline Advisor
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Jovery,

    Database was closed with 'immediate' option.

    Will this create problem when we restore and try to open the database next time?

    Thanks,
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart
    Reply With Quote Reply With Quote
  9. 02-13-2002, 11:51 AM #9
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Immediate should not cause you any problems with recovery, but I have seen this problem before when the DBA used shutdown abort.

    Does the original database still work okay when you copy the files back?

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!
    Reply With Quote Reply With Quote
  10. 02-25-2002, 10:03 AM #10
    ac
    ac is offline Member
    Join Date
    Nov 2000
    Posts
    178
    Hi Samba,

    Did you solve the problem and if yes how?. Coincidentally I have the same error message as you did in the beginning but I didn't do any zip etc.

    AC
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width