RE: RE: RE: Backups
SQL Backtrack and Netbackup! No manual tracking. Restores couldn't be simpler. R. Smith -Original Message- Sent: Thursday, October 03, 2002 3:04 PM To: Multiple recipients of list ORACLE-L Richard, Distateful is being nice. Try down right horrifying is a more appriopriate description. Been There, Done that, now have three Unix SA's who handle it. Life is so grand!! Dick Goulet Reply Separator Author: Markham; Richard [EMAIL PROTECTED] Date: 10/3/2002 10:53 AM Yes I personally run Veritas Netbackup for both cold and RMAN. A fiber SAN has its added benefits as well =). I have never really explored the implications of these other utilities. My head filled with many distasteful visuals. Yes, I agree with you and I realize that I am spoiled knocking on wood. -Original Message- Sent: Thursday, October 03, 2002 1:38 PM To: Markham; Richard; Multiple recipients of list ORACLE-L I've used cpio, dd, and fbackup to do hot and cold backups before, but never again. With those utilities the burden of keeping track of what is on which tape rests with you and normally a stubby pencil pad of paper because you know what won't be available when you need to do a recovery. They do work be assured, but the administrative overhead is just not worth it anymore, even for a small shop. Get a copy of Veritas or OmniBack or some other software package that does library management for you and preferably integrates with RMAN. Life can be so much easier!! Dick Goulet Reply Separator Author: Markham; Richard [EMAIL PROTECTED] Date: 10/3/2002 10:03 AM It would be interesting to see how you would explain how either cp or dd (which know nothing of archive log mode, or the concept of hot backup, itself, none the less) is going to keep things consistent, when these utilities themselves are for point in time operations. -Original Message- Sent: Thursday, October 03, 2002 12:18 PM To: Multiple recipients of list ORACLE-L 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
RE: RE: RE: Backups
Unless: You do a point in time recovery, find out you were given the wrong time, and try to do it again. Not so simple, can't be done from the SQL*Bactrack menu. Jared Smith, Ron L. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/03/2002 01:26 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RE: RE: Backups SQL Backtrack and Netbackup! No manual tracking. Restores couldn't be simpler. R. Smith -Original Message- Sent: Thursday, October 03, 2002 3:04 PM To: Multiple recipients of list ORACLE-L Richard, Distateful is being nice. Try down right horrifying is a more appriopriate description. Been There, Done that, now have three Unix SA's who handle it. Life is so grand!! Dick Goulet Reply Separator Author: Markham; Richard [EMAIL PROTECTED] Date: 10/3/2002 10:53 AM Yes I personally run Veritas Netbackup for both cold and RMAN. A fiber SAN has its added benefits as well =). I have never really explored the implications of these other utilities. My head filled with many distasteful visuals. Yes, I agree with you and I realize that I am spoiled knocking on wood. -Original Message- Sent: Thursday, October 03, 2002 1:38 PM To: Markham; Richard; Multiple recipients of list ORACLE-L I've used cpio, dd, and fbackup to do hot and cold backups before, but never again. With those utilities the burden of keeping track of what is on which tape rests with you and normally a stubby pencil pad of paper because you know what won't be available when you need to do a recovery. They do work be assured, but the administrative overhead is just not worth it anymore, even for a small shop. Get a copy of Veritas or OmniBack or some other software package that does library management for you and preferably integrates with RMAN. Life can be so much easier!! Dick Goulet Reply Separator Author: Markham; Richard [EMAIL PROTECTED] Date: 10/3/2002 10:03 AM It would be interesting to see how you would explain how either cp or dd (which know nothing of archive log mode, or the concept of hot backup, itself, none the less) is going to keep things consistent, when these utilities themselves are for point in time operations. -Original Message- Sent: Thursday, October 03, 2002 12:18 PM To: Multiple recipients of list ORACLE-L 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
RE: RE: RE: Backups
You must be using an old version. Been there done that. Works! Ron PS: Also works on NT! -Original Message- Sent: Thursday, October 03, 2002 4:11 PM To: Multiple recipients of list ORACLE-L Unless: You do a point in time recovery, find out you were given the wrong time, and try to do it again. Not so simple, can't be done from the SQL*Bactrack menu. Jared Smith, Ron L. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/03/2002 01:26 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RE: RE: Backups SQL Backtrack and Netbackup! No manual tracking. Restores couldn't be simpler. R. Smith -Original Message- Sent: Thursday, October 03, 2002 3:04 PM To: Multiple recipients of list ORACLE-L Richard, Distateful is being nice. Try down right horrifying is a more appriopriate description. Been There, Done that, now have three Unix SA's who handle it. Life is so grand!! Dick Goulet Reply Separator Author: Markham; Richard [EMAIL PROTECTED] Date: 10/3/2002 10:53 AM Yes I personally run Veritas Netbackup for both cold and RMAN. A fiber SAN has its added benefits as well =). I have never really explored the implications of these other utilities. My head filled with many distasteful visuals. Yes, I agree with you and I realize that I am spoiled knocking on wood. -Original Message- Sent: Thursday, October 03, 2002 1:38 PM To: Markham; Richard; Multiple recipients of list ORACLE-L I've used cpio, dd, and fbackup to do hot and cold backups before, but never again. With those utilities the burden of keeping track of what is on which tape rests with you and normally a stubby pencil pad of paper because you know what won't be available when you need to do a recovery. They do work be assured, but the administrative overhead is just not worth it anymore, even for a small shop. Get a copy of Veritas or OmniBack or some other software package that does library management for you and preferably integrates with RMAN. Life can be so much easier!! Dick Goulet Reply Separator Author: Markham; Richard [EMAIL PROTECTED] Date: 10/3/2002 10:03 AM It would be interesting to see how you would explain how either cp or dd (which know nothing of archive log mode, or the concept of hot backup, itself, none the less) is going to keep things consistent, when these utilities themselves are for point in time operations. -Original Message- Sent: Thursday, October 03, 2002 12:18 PM To: Multiple recipients of list ORACLE-L 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
RE: RE: RE: Backups
Not using any version of it now. Veritas Net Backup and RMAN. When BMC purchased DataTools, the support for SQL*Backtrack really went down the tubes. I don't know if it's improved or not, but I don't really miss it now. Jared Smith, Ron L. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/03/2002 02:38 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RE: RE: Backups You must be using an old version. Been there done that. Works! Ron PS: Also works on NT! -Original Message- Sent: Thursday, October 03, 2002 4:11 PM To: Multiple recipients of list ORACLE-L Unless: You do a point in time recovery, find out you were given the wrong time, and try to do it again. Not so simple, can't be done from the SQL*Bactrack menu. Jared Smith, Ron L. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/03/2002 01:26 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RE: RE: Backups SQL Backtrack and Netbackup! No manual tracking. Restores couldn't be simpler. R. Smith -Original Message- Sent: Thursday, October 03, 2002 3:04 PM To: Multiple recipients of list ORACLE-L Richard, Distateful is being nice. Try down right horrifying is a more appriopriate description. Been There, Done that, now have three Unix SA's who handle it. Life is so grand!! Dick Goulet Reply Separator Author: Markham; Richard [EMAIL PROTECTED] Date: 10/3/2002 10:53 AM Yes I personally run Veritas Netbackup for both cold and RMAN. A fiber SAN has its added benefits as well =). I have never really explored the implications of these other utilities. My head filled with many distasteful visuals. Yes, I agree with you and I realize that I am spoiled knocking on wood. -Original Message- Sent: Thursday, October 03, 2002 1:38 PM To: Markham; Richard; Multiple recipients of list ORACLE-L I've used cpio, dd, and fbackup to do hot and cold backups before, but never again. With those utilities the burden of keeping track of what is on which tape rests with you and normally a stubby pencil pad of paper because you know what won't be available when you need to do a recovery. They do work be assured, but the administrative overhead is just not worth it anymore, even for a small shop. Get a copy of Veritas or OmniBack or some other software package that does library management for you and preferably integrates with RMAN. Life can be so much easier!! Dick Goulet Reply Separator Author: Markham; Richard [EMAIL PROTECTED] Date: 10/3/2002 10:03 AM It would be interesting to see how you would explain how either cp or dd (which know nothing of archive log mode, or the concept of hot backup, itself, none the less) is going to keep things consistent, when these utilities themselves are for point in time operations. -Original Message- Sent: Thursday, October 03, 2002 12:18 PM To: Multiple recipients of list ORACLE-L 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
