Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 07-02-2006, 11:08 PM   #1
Registered: Feb 2004
Posts: 259

Rep: Reputation: 30
Oracle 10 G Database Backup & Restore


I Have Installed FEDORA CORE 3 with Oracle 10g installed on it. As I am taking the full backup weekly of database oracle 10g by using exp command. The file which is generated become .dmp extension. Now I would like to know in the same ref that In case the PC was crashed and I want to restore the database from .dmp file by using imp command what steps I have to do ?

1. Whether I have to create the same user which I have been created to export the database ?
2. Whether I can directly resore the databse by using imp command after simply installing linux & oracle.

As I have tried 2nd step I got error that the restore process terminated .

Can any body help me in detail ?
Old 07-02-2006, 11:21 PM   #2
Registered: Oct 2005
Location: Australia
Distribution: slackware 12.1
Posts: 753

Rep: Reputation: 32
AFAIK, the database name, oracle_sid and the characterset should be same. The RMAN tool is better than that. Also you can try the cold backup method of backup.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Backup & Restore Groups and Users jorasmi Slackware 2 03-28-2005 02:24 AM
How to backup & restore the MBR in linux? sgzlit Linux - Newbie 7 03-02-2005 09:07 PM
Backup & Restore chaitu_iiit Linux - Software 2 10-30-2004 12:10 AM
Backup & Restore plan using tar markcasazza Linux - Newbie 1 04-14-2004 01:11 PM
Had to restore database from backup - about 5 minutes lost jeremy LQ Suggestions & Feedback 0 01-21-2001 10:31 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 05:47 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration