backup

[Jackie Wang]

hi, can anyone tell me how I can backup my oracle 8i and recover it from another machine? Thanks!

[Jackie Wang]

i saw .ORA file and some DBF file, the whole thing is about 1GB, should I duplicate all? Thanks!

[Beksy Kurian]

Several backup scripts are available in this website
http://www.dbasupport.com/oracle/scripts/Backup_Recovery/
Regards
Beksy

[Jackie Wang]

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]

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