Q:
media recovery
Installation, Migration, Windows, Security, Oracle, SQL, Architecture/Design, DB2, PHP, Database, XML, Oracle administration, Performance/Tuning, Availability, Oracle development, Oracle Database Versions, Business Process Execution Language, BPEL, Java/J2EE, Service-Oriented Architecture, SOA, 7 and earlier, Backup & recovery, Oracle 9i, Oracle 10g, Oracle 8i 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.
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.
ASKED:
Apr 7 2007 5:04 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
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.
