Re: Need help for backuping Oracle on a RAID5 tower (AIX)

I think you are thinking of sparce files. Files that are preallocated space on the disk but do not use all of it. (hence the name sparce) Sysbackup will not restore sparce files correctly but I believe tar or cpio will. I have not used thee for a long time but I think one will work. If not you need to get a backup program that handles sparce files correctly.

Matt Reller
mreller_at_gofast.net

Geoffrey C Marshall wrote:

> Sylvain Falardeau wrote:
>
> > Problem:
> > --------
> >
> > When backuping a Oracle database (6 files of 1Gig with the AIX
> > Filesystem)
> > with SYSBACK (AIX backup utilities), we can't restore it without
> > "inconsistencies" of filesystem:
> >
> > ls -l indicate 6 files of 1G in the 8G filesystem.
> > df -k indicate 40% of filesystem space used!!!
> >
> > When calling Oracle support, he says that some backup utilities trunc
> > nulls in files (like tar). But the guy don't say anything about
> > SYSBACK.
> >
> > If anyone exprienced some problems with this type of hardware and
> > Oracle
> > database, please e-mail me your solution for safe backup. :) :)
>
> I don't have the specific experience of Oracle and AIX, but
> I know the problem. Unix allows a user to create 'large' files
> that only have a few bytes of data (You can do this by creating
> a file then using fseek b4 writing). This give you files with
> 'holes' in them. Most software (including 'cp') will destroy
> these files, in that the copy does not have the 'holes' and
> therefore the data is at the wrong place in the file.
>
> You can test this by using 'cp'. If the resultant file
> is not the same size then you have that problem.
>
> I know of no way around this, except to use utilities
> for your backup that can manage the 'holes'.
>
> Geoff...
> _______________________________________________________________________
> Geoffrey C. Marshall
> (a.k.a) count_at_ozemail.com.au
> _______________________________________________________________________
> SAGITTARIUS (Nov 22 - Dec 21)
> You are optimistic and enthusiastic. You have a reckless
> tendency to rely on luck since you lack talent. The majority
> of Sagittarians are drunks or dope fiends or both. People
> laugh at you a great deal.
> _______________________________________________________________________
> _
>
> ------------------------------------------------------------------------
>
> Geoffrey Marshall <count_at_ozemail.com.au>
>
> Geoffrey Marshall
> <count_at_ozemail.com.au>
> 8, Fairy Dell Road Work: +613 9752 6503
> Tecoma Home: +613 9752 6503
> Victoria Netscape Conference Address
> 3160 Netscape Conference DLS Server
> Australia
> Additional Information:
> Last Name Marshall
> First Name Geoffrey
> Version 2.1
Received on Wed Sep 17 1997 - 00:00:00 CDT