RE: Backup DB files to the Tape

I will add a vote for cpio. I have found it to be so reliable that I used cpio, instead of a dump utility, to back up Unix boxes. It never failed. In the past, I found that tar had filename length limitation that was shorter than what the OS permitted (80 characters iirc -- that's filename, not path). This happened when I worked in a development environment that used Rogue Wave tools. During software builds, files would be generated with ridiculously long names, and tar could not handle these. Time has passed since the days I had to backup Unix servers, but iirc cpio could correctly handle all types of special files (devices, etc.), and tar could not (as I said, iirc).

If you are just experimenting, there is another utility called pax, which is latin for peace, the idea being that it will bring peace to the Tar Wars where tar2d2 is always fighting c3pio. I get the impression that neither group was willing to abandon its favorite utility and adopt pax, so the fight goes on.

> -----Original Message-----
>
> Well for this you can use cpio command in Unix for copying
> files to Tape.
>
> Another option is using ufsdump commnand .
>
> > We have UnixWare 7.1 and I want to take backup of
> > Database files (Physical files) to my tape.
> >
> > I did use tar command:
> >
> > tar c8v1 /home/oradata
> >
> > It's working properly but the problem is:
> >
> > tar can't handle large files(larger than 2GB).
> > The total size of the DB files under /home/oradata
> > more than 2GB.
> >
> > So the result I'll get some of those files not all.
> >
> > Could any body in the list give me the alternative
> > command of tar that can handle backup of large files
> > or any other solution...
> >
> > because I want to schedule this process.
> >
> > Your help will be appreciated.
> >
> > Regards,
> > ashraf salaymeh
> > System Analyst(OCP Certified DBA)
> >
> > __________________________________________________
> > Do you Yahoo!?
> > Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> > http://mailplus.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ashraf Salaymeh
> > INET: ashraf_salaymeh_at_yahoo.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web
> hosting services
> >
> ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: dilmohan
> INET: dilmohan_at_delhi.tcs.co.in
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: slee_at_dollar.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).