media recovery
7 and earlier, Architecture/Design, Availability, Backup & recovery, BPEL, Business Process Execution Language, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle administration, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, Service-Oriented Architecture, SOA, SQL, Windows, 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.
Software/Hardware used:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
