RE: Backup DB files to the Tape

Stephen,

The para. about "pax" vis-a-vis "tar" versus "cpio" was interesting ! I never knew that -- though the names do make sense now ! Hemant

At 06:39 AM 18-12-02 -0800, you wrote:

>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).

Hemant K Chitale
My web site page is : http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

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).