This week's book giveaway is in the OCPJP forum.
We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes backup Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "backup" Watch "backup" New topic
Author

backup

Jackie Wang
Ranch Hand

Joined: Apr 18, 2002
Posts: 315
hi, can anyone tell me how I can backup my oracle 8i and recover it from another machine? Thanks!
Jackie Wang
Ranch Hand

Joined: Apr 18, 2002
Posts: 315
i saw .ORA file and some DBF file, the whole thing is about 1GB, should I duplicate all? Thanks!
Beksy Kurian
Ranch Hand

Joined: Jul 11, 2001
Posts: 254
Several backup scripts are available in this website
http://www.dbasupport.com/oracle/scripts/Backup_Recovery/
Regards
Beksy
Jackie Wang
Ranch Hand

Joined: Apr 18, 2002
Posts: 315
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

Joined: Jul 11, 2001
Posts: 254
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: backup