We have an Oracle 8.1.7 server installed on a Win2K box in a dev environment with data in it. However, somebody did something on it which cause all Oracle services disappeared and thus the oracle server in unusable condition. Luckily, all the data files, log files, control files are intact.
How can I recover this database? Actually, all I need is the data inside that database. Can I use those files to create a new instance on my other Oracle server instead of recovering it from the original machine?
Just to clarify --
1. Since my other Oracle server(9i) already has all the file structures set up, how do I replicate the file structure on the original server as you suggested in the previous post? Or you really mean just copy the data files, control files and init.ora file to the correct places in the new server?
2. Will this work if the original server is 8i while the new server is 9i?
3. Which doc can I look to find more info on Oradim?