gentle correction: oracle6 had "hot" backup capability... ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, October 04, 2002 9:48 AM
Oracle 6 and prior releases required cold backups. Hot backups became available in version 7. The trend appears RMAN is the new way! Still waiting for Robert Freeman's new book :). Gene >>> [EMAIL PROTECTED] 10/04/02 10:03AM >>> 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: 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: Tim Gorman 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).