Re: backup question

Interesting solutions to the Unix 2GB issue constantly appear on Oracle technet.

Standard Unix tools.... use a pipe to compress the export and then send the export to the pipe. You are still faced with the 2GB file limit on the compressed
export but used it sucessfully on 10GB + databases so far. When running an import you simply reverse the process. Unix is pretty clever that way :-)

Alternative is to run several separate exports. My suggestion would be

1.All SYS, SYSTEM first
2.All Schema Owners (Broken down separately if too large)
3.Everyone else.

Or you simply use a cold backup and archive the datafiles to tape :-)

Dominic Baines

Joost Mulders wrote:

> I am doing this on a HP 10.20 K series machine. Oh...Yes, and I lied a
> bit. cpio is nout wining, but cpio's manpage is. It says that cpio will
> not create archives greater than 2G. cpio IS wining when I create an
> archive on DISK which would become greater than 2G. I haven't tried
> writing to tape but the manpage does not give much hope.
>
> The question really is: should I do the hassle with cpio | tar | dd? How
> do you -oracle guys- backup databases with a size of 6 - 8 GB? using
> standard unix tools or a dedicated program.
>
> TIA
>
> Joost Mulders
Received on Tue May 25 1999 - 00:17:54 CDT