Skip to Main Content

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!

How to restore the oracle 10g database

691593Mar 18 2009 — edited Mar 18 2009
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 15 2009
Added on Mar 18 2009
6 comments
2,576 views