Very Computer

by **Fukeride** » Sat, 25 Jan 2003 20:56:54

Hello,
some oracle 9i tablespaces have exceeded 2 GB file size.
As there are 2 GB file size limits both
in cpio and tar and pax, I no longer can backup them to tape.
Is the split command the only workaround.
Any help greatly appreciated.

--
H. Fukerider Arch. BDA

by **Chris Watkin** » Sat, 25 Jan 2003 21:00:22

> Hello,
> some oracle 9i tablespaces have exceeded 2 GB file size.
> As there are 2 GB file size limits both
> in cpio and tar and pax, I no longer can backup them to tape.
> Is the split command the only workaround.
> Any help greatly appreciated.

> --
> H. Fukerider Arch. BDA

Use fbackup instead?

--
Chris

by **Paul Sur** » Sun, 26 Jan 2003 03:08:06

Quote:> Is the split command the only workaround

Yep there is. Even seen it a few years ago. Try a web search with

oracle tar cpio limit

Paul

by **rick rhode** » Sun, 26 Jan 2003 09:21:56

online.com:

Quote:> Hello,
> some oracle 9i tablespaces have exceeded 2 GB file size.
> As there are 2 GB file size limits both
> in cpio and tar and pax, I no longer can backup them to tape.
> Is the split command the only workaround.
> Any help greatly appreciated.

I believe out on itrc I saw a patch for 11i that allows tar to handle
files up to 8gb. Also, you can installed gnu tar which handles files
bigger than 2gb.

by **Frank Slootwe** » Tue, 28 Jan 2003 19:03:23

> Hello,
> some oracle 9i tablespaces have exceeded 2 GB file size.
> As there are 2 GB file size limits both
> in cpio and tar and pax, I no longer can backup them to tape.
> Is the split command the only workaround.
> Any help greatly appreciated.

> --
> H. Fukerider Arch. BDA

cpio, tar, pax, etc. are inappropriate for backing up today's systems
because they are too limited, lack error-recovery features, etc.. As
Chris mentions, you should at least use fbackup, and preferably a more
suitable backup product like HP's OmniBack.

by **Ulrich Wind** » Tue, 28 Jan 2003 21:45:44

Does split support large files then? ;-)

> > Is the split command the only workaround

> Yep there is. Even seen it a few years ago. Try a web search with

> oracle tar cpio limit

> Paul

by **Ulrich Wind** » Tue, 28 Jan 2003 21:44:52

See my thread on large files: There are patches for tar and cp
available, but not for full terabyte-sized files (tar only supports
8GB).

Ulrich

> Hello,
> some oracle 9i tablespaces have exceeded 2 GB file size.
> As there are 2 GB file size limits both
> in cpio and tar and pax, I no longer can backup them to tape.
> Is the split command the only workaround.
> Any help greatly appreciated.

> --
> H. Fukerider Arch. BDA

by **Frank Slootwe** » Tue, 28 Jan 2003 22:47:17

> Does split support large files then? ;-)

Well, actually it does. See the "HP-UX Large Files White Paper" I
mentioned in your recent thread ("2GB filesize limits in HP-UX11i
(11.11) 64 bit").

>> > Is the split command the only workaround

>> Yep there is. Even seen it a few years ago. Try a web search with

>> oracle tar cpio limit

>> Paul

by **Frank Slootwe** » Tue, 28 Jan 2003 22:49:45

>> Does split support large files then? ;-)

> Well, actually it does. See the "HP-UX Large Files White Paper" I
> mentioned in your recent thread ("2GB filesize limits in HP-UX11i
> (11.11) 64 bit").

OOPS. That was this thread. I meant to say "VxFS -o largefile and
system support for HP-UX 11i/64".

>>> > Is the split command the only workaround

>>> Yep there is. Even seen it a few years ago. Try a web search with

>>> oracle tar cpio limit

>>> Paul

by **Ian Springe** » Wed, 29 Jan 2003 00:17:46

Quote:> See my thread on large files: There are patches for tar and cp
> available, but not for full terabyte-sized files (tar only supports
> 8GB).

Here are a few more details on these patches (I'll be adding this to the
faq):
Because of industry standards and interoperability goals, neither tar, cpio,
pax, nor dump support the archival of files larger than 2GB. fbackup,
however, does support the archival of large files. However, the following
patches can be applied to 11.11 to remove the file size limitation from the
tar or pax commands:

o tar: PHCO_26423

o pax: PHCO_26422

> Ulrich

> > Hello,
> > some oracle 9i tablespaces have exceeded 2 GB file size.
> > As there are 2 GB file size limits both
> > in cpio and tar and pax, I no longer can backup them to tape.
> > Is the split command the only workaround.
> > Any help greatly appreciated.

> > --
> > H. Fukerider Arch. BDA

by **Alan D Johnso** » Wed, 29 Jan 2003 12:22:03

>>See my thread on large files: There are patches for tar and cp
>>available, but not for full terabyte-sized files (tar only supports
>>8GB).

> Here are a few more details on these patches (I'll be adding this to the
> faq):
> Because of industry standards and interoperability goals, neither tar, cpio,
> pax, nor dump support the archival of files larger than 2GB. fbackup,
> however, does support the archival of large files. However, the following
> patches can be applied to 11.11 to remove the file size limitation from the
> tar or pax commands:

> o tar: PHCO_26423

> o pax: PHCO_26422

>>Ulrich

>>>Hello,
>>>some oracle 9i tablespaces have exceeded 2 GB file size.
>>>As there are 2 GB file size limits both
>>>in cpio and tar and pax, I no longer can backup them to tape.
>>>Is the split command the only workaround.
>>>Any help greatly appreciated.

>>>--
>>>H. Fukerider Arch. BDA

Isn't pax a posix tool? shouldn't it be able to deal with larger
files/archives? I know we have had this discussion before :-),... but I
would think that the limitations should have been overcome, wouldn't it
be nice if we had a utility that REALLY worked between systems... ha ha.

by **Fukeride** » Thu, 30 Jan 2003 00:57:34

Thanks a lot to all of you.
fbackup does the job now.

--
H. Fukerider Arch. BDA

by **Ken Gree** » Thu, 30 Jan 2003 08:16:54

> >>See my thread on large files: There are patches for tar and cp
> >>available, but not for full terabyte-sized files (tar only supports
> >>8GB).

> > Here are a few more details on these patches (I'll be adding this to the
> > faq):
> > Because of industry standards and interoperability goals, neither tar, cpio,
> > pax, nor dump support the archival of files larger than 2GB. fbackup,
> > however, does support the archival of large files. However, the following
> > patches can be applied to 11.11 to remove the file size limitation from the
> > tar or pax commands:

> > o tar: PHCO_26423

> > o pax: PHCO_26422

> >>Ulrich

> >>>Hello,
> >>>some oracle 9i tablespaces have exceeded 2 GB file size.
> >>>As there are 2 GB file size limits both
> >>>in cpio and tar and pax, I no longer can backup them to tape.
> >>>Is the split command the only workaround.
> >>>Any help greatly appreciated.

> >>>--
> >>>H. Fukerider Arch. BDA

> Isn't pax a posix tool? shouldn't it be able to deal with larger
> files/archives? I know we have had this discussion before :-),... but I
> would think that the limitations should have been overcome, wouldn't it
> be nice if we had a utility that REALLY worked between systems... ha ha.

pax when writing in tar format can't get round the limitation. The tar standard
has a 12byte field to store the filesize in, and it stores it in an octal string.
1 byte
is used for the null terminator of the string, so you've really only got 11
bytes,
these can each carry 3bits of size information, so 33bits worth (8G) is the max
size that tar can support. Anything bigger and it just isn't tar.

Cheers

Ken

by **Ian Springe** » Thu, 30 Jan 2003 08:13:55

Quote:> Here are a few more details on these patches (I'll be adding this to the
> faq):
> Because of industry standards and interoperability goals, neither tar,
cpio,
> pax, nor dump support the archival of files larger than 2GB. fbackup,
> however, does support the archival of large files. However, the following
> patches can be applied to 11.11 to remove the file size limitation from
the
> tar or pax commands:

> o tar: PHCO_26423

> o pax: PHCO_26422

It should be noted that applying the above pax patch would allow you to
archive up-to-8GB files into either tar _or_ cpio format, since pax supports
both formats.

> > Ulrich

> > > Hello,
> > > some oracle 9i tablespaces have exceeded 2 GB file size.
> > > As there are 2 GB file size limits both
> > > in cpio and tar and pax, I no longer can backup them to tape.
> > > Is the split command the only workaround.
> > > Any help greatly appreciated.

> > > --
> > > H. Fukerider Arch. BDA

by **Frank Slootwe** » Thu, 30 Jan 2003 17:02:14

>> Here are a few more details on these patches (I'll be adding this to the
>> faq):
>> Because of industry standards and interoperability goals, neither tar,
> cpio,
>> pax, nor dump support the archival of files larger than 2GB. fbackup,
>> however, does support the archival of large files. However, the following
>> patches can be applied to 11.11 to remove the file size limitation from
> the
>> tar or pax commands:

>> o tar: PHCO_26423

>> o pax: PHCO_26422

> It should be noted that applying the above pax patch would allow you to
> archive up-to-8GB files into either tar _or_ cpio format, since pax supports
> both formats.

Do you have any reference that pax would allow 8GB files in *cpio*
format? The pax patch only mentions USTAR, i.e. tar, format. If pax
would allow 8GB files in cpio format, then it would be logical for cpio
to do the same, but it doesn't. And (AFAIK), there is no patch for
cpio.

AFAIK, the problem is the c_filesize (see cpio(4)) which is still
32-bits, probably signed, i.e. 2GB max. While cpio's 'ASCII' format
("-c") would *theoretically* allow 8GB, because Longfile is written in
"%11lo" format, i.e. 11 octal digits, the fact that cpio can be used in
'binary' format (no "-c") sets the theoretical limit to 4GB (32-bits
unsigned) and the practiacl limt to 2GB (32-bits signed).

I would like to be proven wrong, but I'm afraid I'm not.

Very Computer

2GB filesize limits in HP-UX11i (11.11) 64 bit