Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Oracle server died. Built a new VM and mapped out the volumes to the SAN. Installed the same version of Oracle on the new server and applied the same patches. How can I "register" or "attached" the oracle files > control, redo and DBF files to the new server? Oracle 10g Thoughts? Thanks.

share|improve this question

If your files are visible and accessible on the new server as they were on the old one, restore a pfile or an spfile (found in $ORACLE_HOME/dbs/ ) from the old server and use that to start the database.

If needed you can generate an editable pfile from the spfile to check the path's of the controlfiles. Easiest is when all path's are the same otherwise, you really need a dba to get you going.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.