Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Newbie: how to restore db from control file + zips?

dustinh_32574Dec 27 2011 — edited Dec 27 2011

Hi Everyone. First post. First day working with anything oracle. (coming from MS T-sql background)

I was given the task of restoring a db (on a different machine) from a disc backup. The disc backup contains:

init.ora
initdw.ora
initPROD.ora
initPROD_noaq.ora
PROD_hft01.ifile.ora
090531_2100_control.bak
and many many X.dbf.gz files

I'm not sure how to go about restoring this db. What I did was install oracle database 11g server on a machine (windows server 2008 r2, 64 bit) , and I can successfully run a query (using toad) such as select * from help. So I'm pretty sure I installed things correctly, etc.

I'm assuming that I need to use RMAN, but I am seriously day 1 new to Oracle and the tutorials and FAQ's are only semi useful when I don't know the basics yet.

Any hints? I am most appreciative!

Edited by: 904666 on Dec 27, 2011 8:31 AM