Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

backup

 
Jackie Wang
Ranch Hand
Posts: 315
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi, can anyone tell me how I can backup my oracle 8i and recover it from another machine? Thanks!
 
Jackie Wang
Ranch Hand
Posts: 315
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i saw .ORA file and some DBF file, the whole thing is about 1GB, should I duplicate all? Thanks!
 
Beksy Kurian
Ranch Hand
Posts: 254
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Several backup scripts are available in this website
http://www.dbasupport.com/oracle/scripts/Backup_Recovery/
Regards
Beksy
 
Jackie Wang
Ranch Hand
Posts: 315
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Description: This script exports data and creates a dmp file.
Code:
exp80 shirish/andy
file=d:\backup\export\exp.dmp
owner=shirish grants=Y rows=Y
log=d:\backup\export\shirish.log

I am not sure how i can make it if my oracle is in c: and the directory is c:\oracle
Thanks so much
 
Beksy Kurian
Ranch Hand
Posts: 254
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Didn't understand the question clearly!
Is the export file(expdat.dmp) in a different machine? Copy the expdat.dmp file to the second machine(may be to c drive) and do an import using the imp command.

Regards
Beksy
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic