LinuxQuestions.org
View the Most Wanted LQ Wiki articles.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
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.

Notices

Reply
 
Search this Thread
Old 07-02-2006, 11:08 PM   #1
rajaniyer123
Member
 
Registered: Feb 2004
Location: BARODA, GUJARAT
Posts: 259

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


hi

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
prozac
Member
 
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.
 
  


Reply


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


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

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