Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 10.0.2.0.3. Thoughts? Thanks.

share|improve this question
add comment

1 Answer 1

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
add comment

Your Answer

 
discard

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.