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.
> >
> > >>> [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]>
> > 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.
> >
> > >>> [EMAIL PROTECTED] 10/03/02 02:28PM >>>
> >
> > Lest we not forget the archivelogs also during this backup procedure.
> > Ron
> >
> > >>> [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]>
> > 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" <[EMAIL PROTECTED]>
> > 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
> >
> > >>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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 [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ray Stell
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
