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
UPDATED:
April 10, 2007 3:29:42 AM GMT
RELATED QUESTIONS
- moving datafiles to different locations
- Performing a Virtual Server to Physical Server Migration
- How to operating with Multiple Member PF in RPG ?
- How to install Lotus Domino 7 on Ubuntu 8.10
- RPG/400 error
- Reading logical with different key fields scenario
- encryption and decryption WIN XP PRO SP2 PRE-INSTALL FROM DELL
- How do I create a report from 12 lpars listing tapes used from daily backup
- CL400/OPNQRY
- What does your social media staff look like?
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.
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.
0 pts.
To see other answers submitted to the Answer Wiki View Answer History.
