Home > IT Answers > Oracle > media recovery
Help

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
Help

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

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Apr 10 2007  3:29 AM GMT  by geoffreyhalleds




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.


RSS - Discussions Help

Discuss This Answer


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