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