How could I copy to another disk a 5Gb file?

[Carme Torca]

Hi,

I need to copy files that have more than 5Gb in another filesystems, How could I do this?

rw-r----- 1 oracle oinstall 5242896384 Sep 10 03:34 D_DPF2006T1_4.dbf

I know that if there are more than 2Gb are problems with a normal copy.

Could you help me?
Thank you!

Carmen.

[Peter Godron · Accepted solution]

Carmen,
1. As it is a dbf file is the database down?
Otherwise you may get "file in use" problems.
2. Ensure the target systems disk allows large files: grep mountpoint /etc/fstab
otherwise use SAM to change.
3. You should be able to use cp

Please let us know how you get on.

[Hemmetter]

Hi Carmen,

I dont think there's a filesize limit with cp-command.

Is your target file system created with "largefiles"-option?

check with it mkfs(1M) with -m option.
# mkfs -F vxfs -m /dev/vgXY/lvolZ

If cp is really the matter try dd(1) command.


rgds
HGH

[JIJ_1]

Hi Carmen,

2GB limitation is there for "cpio" command. In your case you can use normal "cp" command.

Regards !
JIJ

[spex]

Hi Carmen,

Older HP-UX versions of 'cpio' and 'tar' had a 2GB limit in order to remain compatible with industry standards. I believe older versions of Oracle also had a 2GB limit on the size of datafiles. Maybe you are thinking along these lines.

If you are not running in hot-backup mode, your instance must be shutdown before you can copy the datafile. If you are in hot-backup mode, you will need archivelogs for recovery.

See the "Oracle Backup and Recovery FAQ":
http://www.orafaq.com/faqdbabr.htm

PCS

[uadm26]

hi, Carmen

The "dd" it's a good and powerfull command:
Stop the Oracle Database.
dd if=/DATA/file_old.dbf of=/DATANEW/file_new.dbf bs=16k

Good Luck,
Joel