Re: Backup DB files to the Tape

I do not get it.
If you put the tablespace in backup mode and then use the os utilities to copy the datafiles to tape why you can not use then for recover. Just restore the datafiles and the archive logs and do recover?

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Wednesday, December 18, 2002 7:04 PM

> I was thinking of simply copying the datafiles using the OS facilities.
> If you are putting hot backups to tape directly I am not sure that they
will
> be usable for recovery. RMAN requires a third party media manager to
handle
> backups to tape. If rman can't do it, I am not sure that homegrown scripts
> can either.
>
> Ruth
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, December 18, 2002 10:24 AM
>
>
> > Ruth,
> >
> > Does this mean hot backups don't work for UnixWare 7.1? Otherwise, cp,
> > cpio, ufsdump or any other method of copying the disk file from location
a
> > to location b should be ok, shouldn't it?
> >
> > John
> >
> >
> > -----Original Message-----
> > Sent: Wednesday, December 18, 2002 8:44 AM
> > To: Multiple recipients of list ORACLE-L
> >
> > Just remember, I you don't have the database shutdown while you back
them
> up
> > the backups will be unusable.
> >
> > Ruth
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Wednesday, December 18, 2002 1:29 AM
> >
> >
> > > Well for this you can use cpio command in Unix for copying files to
> Tape.
> > >
> > > Another option is using ufsdump commnand .
> > >
> > > Regards
> > > Dilmohan
> > >
> > > Ashraf Salaymeh wrote:
> > >
> > > > Dear List,
> > > >
> > > > 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: Ruth Gramolini
> > INET: rgramolini_at_tax.state.vt.us
> >
> > 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: John Weatherman
> > INET: john.weatherman_at_replacements.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: Ruth Gramolini
> INET: rgramolini_at_tax.state.vt.us
>
> 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.net
-- 
Author: Yechiel Adar
  INET: adar76_at_inter.net.il

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