Oracle Database Move
Posted on 2009-07-09
I have a scenario where I need to replicate a live Oracle 10G Database onto a staging environment. While I asked the IT staff controlling the origin database to give me a copy, they apparently copied the files from the running database.
As such, I have 5 .DBF files, 3 REDOXX.LOG files and 3 CONTROLXX.CTL files.
I am running a fresh install of Oracle 10G at my end. I now need these files to work on this installation. How do I go about restoring these files. Else should I actually have to stop the source database to take these copies ?
OS Platfform is Win 2k3 SP2
Any help is appreciated. I am really running out of ideas here.