0 pts.
 media recovery
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.

Software/Hardware used:
ASKED: April 7, 2007  5:04 AM
UPDATED: April 10, 2007  3:29 AM

Answer Wiki:
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.
Last Wiki Answer Submitted:  April 10, 2007  3:29 am  by  Geoffreyhalleds   0 pts.
All Answer Wiki Contributors:  Geoffreyhalleds   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _