I agree with you Ruth. Ray, this may be something that your local DBA read in an older manual someplace.
Have your DBA start reading about Rman. If he/she needs to see it in a book, it might change his/her mind. Tom Mercadante Oracle Certified Professional -----Original Message----- Sent: Friday, October 04, 2002 11:18 AM To: Multiple recipients of list ORACLE-L 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" <[EMAIL PROTECTED]> 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. > > > > > > >>> [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). -- 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: 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).