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.

I need to restore an Oracle production database (aaprod) to a test server that already is home to a test database (aatest) under a new name (bbtest). I have a cold backup of the production database

Questions: What is the appropriate approach to restoring this production database to a test server under a new database name using the cold backup?

Easy to do with SQL Server, Oracle is a new gig.

share|improve this question
    
is the underlying OS windows or Unix? –  Stuart Moore Oct 10 '12 at 19:38
    
My bad, it is Windows. –  jl01 Oct 10 '12 at 19:48
1  
How was the database backed up? Did you use RMAN or just manually copy the data files, control files, init.ora etc? –  Phil Oct 11 '12 at 4:30
    
No RMAN is involved so far. This is a manual process for the data, control, etc. –  jl01 Oct 11 '12 at 14:29
    
Do the data files for the aatest instance have identical paths as aaprod? (A different approach is needed if this is the case, as bbtest will need its data files renaming) –  Phil Oct 12 '12 at 4:21
show 1 more comment

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.