Re: Backups

I never heard that, and I never do them, except my recovery catalog database which I can shut down.

Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, October 04, 2002 10:03 AM

>
>
> One of the local dbas said to me recently that Oracle docs
> indicate that cold backups are required. I did a search and
> could not find what he was talking about. Anyone got such a
> reference?
>
>
>
>
> On Thu, Oct 03, 2002 at 09:38:20PM -0800, Jared Still wrote:
> >
> > OK, Gene, you asked for it. :)
> >
> > The context of your message suggests that a hot backup is
> > somehow more likely to be corrupted than a cold one.
> >
> > I hate to resurrect an old flame war, but...
> >
> > No, I take it back. I don't hate it a bit. ;)
> >
> > There aren't many occasions that call for a cold backup.
> >
> > I'm just curious what you believe a cold backup is buying
> > you that a hot backup won't deliver.
> >
> > Jared
> >
> > On Thursday 03 October 2002 14:54, Gene Sais wrote:
> > > wow, never a cold backup for any os,oracle, application upgrades? i
prefer
> > > to shutdown everything, backup the filesystems, let the vendor have
his
> > > way. if he screws up, its much easier to restore a complete
filesystem
> > > than a corrupted database. cold backups are a good thing. i sleep
good at
> > > nite :) soon, rman will be another backup method in my toolbox. but
when
> > > that happens, i can see hot backups going away but cold backups will
still
> > > be needed on occassion.
> > >
> > > >>> rgramolini_at_tax.state.vt.us 10/03/02 04:33PM >>>
> > >
> > > I don't do them either, 4.5 years here. Ruth
> > > ----- Original Message -----
> > > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > > Sent: Thursday, October 03, 2002 4:17 PM
> > >
> > >
> > > I haven't done nor recommended a cold backup in 3 years since I've
been
> > > using Rman. Just not needed anymore.
> > >
> > > Tom Mercadante
> > > Oracle Certified Professional
> > >
> > >
> > > -----Original Message-----
> > > Sent: Thursday, October 03, 2002 3:14 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > I still prefer cold backups when performing full OS backups.
> > >
> > > >>> RROGERS_at_galottery.org 10/03/02 02:28PM >>>
> > >
> > > Lest we not forget the archivelogs also during this backup procedure.
> > > Ron
> > >
> > > >>> rgramolini_at_tax.state.vt.us 10/03/02 01:53PM >>>
> > >
> > > I forgot about alter tablespace begin backup; etc. I am spoiled, I use
> > > rman
> > > to do online backups. No problem with recovery!
> > > Ruth
> > > ----- Original Message -----
> > > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > > Sent: Thursday, October 03, 2002 12:18 PM
> > >
> > >
> > > This doesn't sound right. Put the database in hot backup mode,
> > > backup (whether using cp to a staging point like the poster here
> > > is doing or straight to tape using dd or dump or some other utility),
> > > come out of hot backup mode. Why wouldn't you be able to recover?
> > >
> > > John P Weatherman
> > > Database Administrator
> > > Replacements Ltd.
> > >
> > >
> > >
> > > -----Original Message-----
> > > Sent: Thursday, October 03, 2002 10:18 AM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > If you want to be able to use any OS backup for restore/recovery that
> > > database must be closed when you do the backup. If it is not, you
> > > won't be
> > > able to recover.
> > >
> > > Just a thot,
> > > Ruth
> > >
> > > ----- Original Message -----
> > > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > > Sent: Thursday, October 03, 2002 9:08 AM
> > >
> > >
> > > Robyn,
> > > We used the DD method on pre 7.1 oracle with RAW devices. It worked
> > > fine except that it used a lot of tape dumping a raw device when only
> > > a
> > > small portion was used. Using a dd command to place a copy of the data
> > > on tape should not be a problem if a restoral is needed. The dd
> > > function
> > > is just another OS method of copying data to a tape. I don't know for
> > > sure but I think there might be some issues about transportability of
> > > the dd tape.
> > > Other users will know about the transportability issues.
> > > Ron
> > > ROR m???m
> > >
> > > >>> Robyn_at_iTeamTech.com 10/02/02 08:08PM >>>
> > >
> > > Hello,
> > >
> > > I need some info about backups. I am working on a customer site, and
> > > have implemented both exports and hot backups. Both jobs copy to a
> > > separate mount point, and a job scripted by another individual then
> > > moves the files to tape.
> > >
> > > Here's the problem - he's using a dd command, primarily because it
> > > provides a succinct output he can email to non-technicals. The file
> > > system is built on a 12 disk A1000 array. We've provided him with a
> > > ufsdump script, but he's doesn't want to use it. Can the system be
> > > recovered from this tape? Has anyone ever relied on a dd for a daily
> > > backup method? The system is Oracle 9i on Solaris 8.
> > >
> > > Robyn
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Robyn Anderson Sands
> > > INET: Robyn_at_iTeamTech.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: Ron Rogers
> > > INET: RROGERS_at_galottery.org
> > >
> > > 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 -- Maili
> > > ng 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.com
> > > --
> > > Author: Ron Rogers
> > > INET: RROGERS_at_galottery.org
> > >
> > > 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: Gene Sais
> > > INET: Gsais_at_co.palm-beach.fl.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: Mercadante, Thomas F
> > > INET: NDATFM_at_labor.state.ny.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: Jared Still
> > INET: jkstill_at_cybcon.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).
>
> --
> ===============================================================
> Ray Stell stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ray Stell
> INET: stellr_at_cns.vt.edu
>
> 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).