Question

  Asked: Apr 7 2007   5:04 AM GMT
  Asked by: sukaina


media recovery


Oracle, Database, DB2, Windows, Oracle administration, Architecture/Design, Availability, Backup & recovery, Installation, Migration, Performance/Tuning, Security, Oracle Database Versions, Oracle 10g, 7 and earlier, Oracle 8i, Oracle 9i, Oracle development, Business Process Execution Language, BPEL, Java/J2EE, PHP, Service-Oriented Architecture, SOA, SQL, XML

Hi,
Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files & tablespaces offline and renamed with new physical location. when bringing online I was getting error as "need media recovery". Please Guide me.
Regards.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



best is to create a link betwwen c: and S:
Is db in archivelogmode?
Was db in restricted mode?
Did you enter the recovery command ie "recover database;" to actually recover.
Initsid.ora locations need changing.
Hard to diagnose further.
Keep me in the loop please.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Oracle, Database and Microsoft Windows.

Looking for relevant Oracle Whitepapers? Visit the SearchOracle.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register