How to restore the oracle 10g database
691593Mar 18 2009 — edited Mar 18 2009Hi all,
I am very new to oracle. I have experience in mssql and mysql previously.
Now we have a oracle application to work . I have an oracle database backup (mydata.bak) taken it from my client's oracle database 10g enterprise edition. Now I want to restore the .bak file at my place . I had installed oracle 10g enterprise edition. After that I had created a datbase called praveen by selecting archivelogmode. The database had created . I am able to login through enterprise manager for this praveen database instance.
Now I want to restore the backup file mydata.bak file into praveen database. May I know how to proceed further?
Please anybody help me out?
And basically what is the backup file format in oracle . As I know for mysql it is .sql and for MSsql it is .bak.
Plz buddies anybody help me out. It is very urgent