RE: RMAN - questions.. Rob Freeman?
Resending, just wondering if there any Shark FlashCopy users out there. So far, it doesn't look good. Gene [EMAIL PROTECTED] 02/06/03 05:03PM Excellent thread on VLDB and backups. I know EMC BCVs/Timefinder works for quick disk backups from experience. However, EMC is not an option, we are a IBM shop w/ Shark storage, Raid-5. The IBM reps say flashcopy works the same if not better than EMC BCVs. Question, is this pure marketing slop or does flashcopy work as advertised? I have seen many mentions and experience w/ EMC but have never seen flashcopy mentioned here. Thanks for any insight to flashcopy you can provide. Lisa - I am using timed statistics, AIX 4.3.3 ML 8, Oracle 8.1.7.0and no problems here. Welcome back to the Unix world :) [EMAIL PROTECTED] 02/05/03 04:35PM Is this all live OLTP type data, or might some of the data be maderead-only? How much will the data be growing and changing (if not a greatdeal then look into incrementals). I can't begin to guess at the timerequired those numbers are all factors of:1. # of backup devices you will be backing up to (I'd suggest several,minimum of probably 6).2. Speed of backup devices.3. Speed of infrastructure from DB to the backup devices.Given a best case, lots of backup devices to backup to in parallel, fastfast infrastructure and really fast (and expensive) equipment, you couldbackup 1TB in an hour or two... Realisticly, much much longer, perhapsupwards of 10-12+ hours at a moderate price range. You could stagger thesebackups over the week, backup some tablespaces and all archived redo logs onday one, other tablespaces and archived redo logs on day two and so on. Thisstaggered approach will reduce the overhead associated with a large, longlasting backup.Recovery of a TB will take a while of course, be prepared for that whennegotiating your SLA's.A product like BMC's timefinder makes a good primary backup/recoverysolution.-Original Message-To: Multiple recipients of list ORACLE-LSent: 2/5/2003 2:16 PMI am considering doing an rman to disk backup and recovery solution fora500G-- grow to 1terabytedatabase. Monster HP servers ... up t0 16 cpu, upto 10,000 concurrentusersThis rman would be the secondary recovery solution (Timefinder isthefirst).Anybody know time frames I might be able to restore/backup 500Gig to1terabyteof database from disk? I will perform it before it goes live but I would like get aball park idea of restore times before hand so we can determine if itcanfit in the SLA requirements. Any parameters to focus on to improve performance other thanallocating channels?Thanks for any helpBrian Spears-Original Message-Sent: Wednesday, February 05, 2003 9:53 AMTo: Multiple recipients of list ORACLE-LCheck out the doc's at tahiti.oracle.com and look up the parameternoprompt.Robert-Original Message-To: Multiple recipients of list ORACLE-LSent: 2/5/2003 5:48 AMHello List,I think my question is very simple...How to execute RMAN command DELETE OBSOLETE from script withoutconfirmation question to remove obsolete backupsautomatically?Many thanks for your help.-- Best regards,Alex mailto:[EMAIL PROTECTED]__Do You Yahoo!?Everything you'll ever need on one web pagefrom News and Sport to Email and Music Chartshttp://uk.my.yahoo.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Alex Andriyashchenko INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Freeman Robert - IL INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Spears, Brian INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from
RE: RMAN - questions.. Rob Freeman?
enter theme from Jaws No shark flash-copy usage here I think your going to need a bigger boat! Cheers! Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 2/7/2003 3:23 PM Resending, just wondering if there any Shark FlashCopy users out there. So far, it doesn't look good. Gene [EMAIL PROTECTED] 02/06/03 05:03PM Excellent thread on VLDB and backups. I know EMC BCVs/Timefinder works for quick disk backups from experience. However, EMC is not an option, we are a IBM shop w/ Shark storage, Raid-5. The IBM reps say flashcopy works the same if not better than EMC BCVs. Question, is this pure marketing slop or does flashcopy work as advertised? I have seen many mentions and experience w/ EMC but have never seen flashcopy mentioned here. Thanks for any insight to flashcopy you can provide. Lisa - I am using timed statistics, AIX 4.3.3 ML 8, Oracle 8.1.7.0 and no problems here. Welcome back to the Unix world :) [EMAIL PROTECTED] 02/05/03 04:35PM Is this all live OLTP type data, or might some of the data be made read-only? How much will the data be growing and changing (if not a great deal then look into incrementals). I can't begin to guess at the time required those numbers are all factors of: 1. # of backup devices you will be backing up to (I'd suggest several, minimum of probably 6). 2. Speed of backup devices. 3. Speed of infrastructure from DB to the backup devices. Given a best case, lots of backup devices to backup to in parallel, fast fast infrastructure and really fast (and expensive) equipment, you could backup 1TB in an hour or two... Realisticly, much much longer, perhaps upwards of 10-12+ hours at a moderate price range. You could stagger these backups over the week, backup some tablespaces and all archived redo logs on day one, other tablespaces and archived redo logs on day two and so on. This staggered approach will reduce the overhead associated with a large, long lasting backup. Recovery of a TB will take a while of course, be prepared for that when negotiating your SLA's. A product like BMC's timefinder makes a good primary backup/recovery solution. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 2/5/2003 2:16 PM I am considering doing an rman to disk backup and recovery solution for a 500G-- grow to 1terabyte database. Monster HP servers ... up t0 16 cpu, upto 10,000 concurrent users This rman would be the secondary recovery solution (Timefinder is the first). Anybody know time frames I might be able to restore/backup 500Gig to 1terabyte of database from disk? I will perform it before it goes live but I would like get a ball park idea of restore times before hand so we can determine if it can fit in the SLA requirements. Any parameters to focus on to improve performance other than allocating channels? Thanks for any help Brian Spears -Original Message- Sent: Wednesday, February 05, 2003 9:53 AM To: Multiple recipients of list ORACLE-L Check out the doc's at tahiti.oracle.com and look up the parameter noprompt. Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 2/5/2003 5:48 AM Hello List, I think my question is very simple... How to execute RMAN command DELETE OBSOLETE from script without confirmation question to remove obsolete backups automatically? Many thanks for your help. -- Best regards, Alex mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: Alex Andriyashchenko INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com 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.net http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com 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
RE: RMAN - questions.. Rob Freeman?
This is ok for tape restores but not for disk restore...but thanks Rob. Brian Spears -Original Message- Sent: Wednesday, February 05, 2003 4:36 PM To: Multiple recipients of list ORACLE-L Take a look at this link, it might be helpful... http://portal1.legato.com/resources/whitepapers/W012.pdf Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 2/5/2003 2:16 PM I am considering doing an rman to disk backup and recovery solution for a 500G-- grow to 1terabyte database. Monster HP servers ... up t0 16 cpu, upto 10,000 concurrent users This rman would be the secondary recovery solution (Timefinder is the first). Anybody know time frames I might be able to restore/backup 500Gig to 1terabyte of database from disk? I will perform it before it goes live but I would like get a ball park idea of restore times before hand so we can determine if it can fit in the SLA requirements. Any parameters to focus on to improve performance other than allocating channels? Thanks for any help Brian Spears -Original Message- Sent: Wednesday, February 05, 2003 9:53 AM To: Multiple recipients of list ORACLE-L Check out the doc's at tahiti.oracle.com and look up the parameter noprompt. Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 2/5/2003 5:48 AM Hello List, I think my question is very simple... How to execute RMAN command DELETE OBSOLETE from script without confirmation question to remove obsolete backups automatically? Many thanks for your help. -- Best regards, Alex mailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko 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.net -- Author: Freeman Robert - IL 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.net -- Author: Spears, Brian 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.net -- Author: Freeman Robert - IL 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.net -- Author: Spears, Brian 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
RE: RMAN - questions.. Rob Freeman?
Thanks Dennis... Ya.. its all on disk and problably only a test with some tuning is going to give me realistic picture. I am going to try it on NETAPPS new disaster recovery SAN solution Brian Spears -Original Message- Sent: Wednesday, February 05, 2003 3:50 PM To: Multiple recipients of list ORACLE-L Brian - Hopefully Robert will have a chance to respond to your question, but if I might make some suggestions, I think your recovery time has two components: 1. If the backup files are not on disk, the time to locate the tape, load the files. 2. RMAN recovery time. I think you will just have to perform some tests on your equipment. There are several tunable RMAN parameters that will make a great deal of difference (or not), depending on your hardware. There are many different types of recovery. Some recoveries may require very little data from RMAN, others may require a lot. You need to outline (and eventually test) for the different types of recovery scenarios. Overall, my experience has been that RMAN offers very fast performance, usually limited just by disk speeds. But what impresses me may not meet your needs. I'm easily impressed. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 05, 2003 2:16 PM To: Multiple recipients of list ORACLE-L I am considering doing an rman to disk backup and recovery solution for a 500G-- grow to 1terabyte database. Monster HP servers ... up t0 16 cpu, upto 10,000 concurrent users This rman would be the secondary recovery solution (Timefinder is the first). Anybody know time frames I might be able to restore/backup 500Gig to 1terabyte of database from disk? I will perform it before it goes live but I would like get a ball park idea of restore times before hand so we can determine if it can fit in the SLA requirements. Any parameters to focus on to improve performance other than allocating channels? Thanks for any help Brian Spears -Original Message- Sent: Wednesday, February 05, 2003 9:53 AM To: Multiple recipients of list ORACLE-L Check out the doc's at tahiti.oracle.com and look up the parameter noprompt. Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 2/5/2003 5:48 AM Hello List, I think my question is very simple... How to execute RMAN command DELETE OBSOLETE from script without confirmation question to remove obsolete backups automatically? Many thanks for your help. -- Best regards, Alex mailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko 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.net -- Author: Freeman Robert - IL 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.net -- Author: Spears, Brian 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: RMAN - questions.. Rob Freeman?
Thanks Peter... Ya, I will be moving it between Netapp san and EMC disk. Brian Spears -Original Message- Sent: Wednesday, February 05, 2003 4:14 PM To: Multiple recipients of list ORACLE-L You will only know what your system is capable of It is very dependant on the disk arrays and no of scsi or fibre channels you have to support those disks Also RAID level will be a big contributor How long does it take to copy say a 500MB file from location to location. check it out this way. see what throughput you are reporting in sar or glance or similar Test this between the filesystem your db is on and where you want to put the backup to disk -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Spears, Brian [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06-02-2003 06:16 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RMAN - questions.. Rob Freeman? I am considering doing an rman to disk backup and recovery solution for a 500G-- grow to 1terabyte database. Monster HP servers ... up t0 16 cpu, upto 10,000 concurrent users This rman would be the secondary recovery solution (Timefinder is the first). Anybody know time frames I might be able to restore/backup 500Gig to 1terabyte of database from disk? I will perform it before it goes live but I would like get a ball park idea of restore times before hand so we can determine if it can fit in the SLA requirements. Any parameters to focus on to improve performance other than allocating channels? Thanks for any help Brian Spears -Original Message- Sent: Wednesday, February 05, 2003 9:53 AM To: Multiple recipients of list ORACLE-L Check out the doc's at tahiti.oracle.com and look up the parameter noprompt. Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 2/5/2003 5:48 AM Hello List, I think my question is very simple... How to execute RMAN command DELETE OBSOLETE from script without confirmation question to remove obsolete backups automatically? Many thanks for your help. -- Best regards, Alex mailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko 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.net -- Author: Freeman Robert - IL 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.net -- Author: Spears, Brian 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
RE: RMAN - questions.. Rob Freeman?
Excellent thread on VLDB and backups. I know EMC BCVs/Timefinder works for quick disk backups from experience. However, EMC is not an option, we are a IBM shop w/ Shark storage, Raid-5. The IBM reps say flashcopy works the same if not better than EMC BCVs. Question, is this pure marketing slop or does flashcopy work as advertised? I have seen many mentions and experience w/ EMC but have never seen flashcopy mentioned here. Thanks for any insight to flashcopy you can provide. Lisa - I am using timed statistics, AIX 4.3.3 ML 8, Oracle 8.1.7.0and no problems here. Welcome back to the Unix world :) [EMAIL PROTECTED] 02/05/03 04:35PM Is this all live OLTP type data, or might some of the data be maderead-only? How much will the data be growing and changing (if not a greatdeal then look into incrementals). I can't begin to guess at the timerequired those numbers are all factors of:1. # of backup devices you will be backing up to (I'd suggest several,minimum of probably 6).2. Speed of backup devices.3. Speed of infrastructure from DB to the backup devices.Given a best case, lots of backup devices to backup to in parallel, fastfast infrastructure and really fast (and expensive) equipment, you couldbackup 1TB in an hour or two... Realisticly, much much longer, perhapsupwards of 10-12+ hours at a moderate price range. You could stagger thesebackups over the week, backup some tablespaces and all archived redo logs onday one, other tablespaces and archived redo logs on day two and so on. Thisstaggered approach will reduce the overhead associated with a large, longlasting backup.Recovery of a TB will take a while of course, be prepared for that whennegotiating your SLA's.A product like BMC's timefinder makes a good primary backup/recoverysolution.-Original Message-To: Multiple recipients of list ORACLE-LSent: 2/5/2003 2:16 PMI am considering doing an rman to disk backup and recovery solution fora500G-- grow to 1terabytedatabase. Monster HP servers ... up t0 16 cpu, upto 10,000 concurrentusersThis rman would be the secondary recovery solution (Timefinder isthefirst).Anybody know time frames I might be able to restore/backup 500Gig to1terabyteof database from disk? I will perform it before it goes live but I would like get aball park idea of restore times before hand so we can determine if itcanfit in the SLA requirements. Any parameters to focus on to improve performance other thanallocating channels?Thanks for any helpBrian Spears-Original Message-Sent: Wednesday, February 05, 2003 9:53 AMTo: Multiple recipients of list ORACLE-LCheck out the doc's at tahiti.oracle.com and look up the parameternoprompt.Robert-Original Message-To: Multiple recipients of list ORACLE-LSent: 2/5/2003 5:48 AMHello List,I think my question is very simple...How to execute RMAN command DELETE OBSOLETE from script withoutconfirmation question to remove obsolete backupsautomatically?Many thanks for your help.-- Best regards,Alex mailto:[EMAIL PROTECTED]__Do You Yahoo!?Everything you'll ever need on one web pagefrom News and Sport to Email and Music Chartshttp://uk.my.yahoo.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Alex Andriyashchenko INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Freeman Robert - IL INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Spears, Brian INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line
RE: RMAN - questions.. Rob Freeman?
Oops... didn't catch the disk backup bit. Backing up 1TB to disk?? Wow! Still, the same rules would apply. lots of disks to spread the backup IO over :-) RF -Original Message- Brian Sent: Thursday, February 06, 2003 10:39 AM To: Multiple recipients of list ORACLE-L This is ok for tape restores but not for disk restore...but thanks Rob. Brian Spears -Original Message- Sent: Wednesday, February 05, 2003 4:36 PM To: Multiple recipients of list ORACLE-L Take a look at this link, it might be helpful... http://portal1.legato.com/resources/whitepapers/W012.pdf Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 2/5/2003 2:16 PM I am considering doing an rman to disk backup and recovery solution for a 500G-- grow to 1terabyte database. Monster HP servers ... up t0 16 cpu, upto 10,000 concurrent users This rman would be the secondary recovery solution (Timefinder is the first). Anybody know time frames I might be able to restore/backup 500Gig to 1terabyte of database from disk? I will perform it before it goes live but I would like get a ball park idea of restore times before hand so we can determine if it can fit in the SLA requirements. Any parameters to focus on to improve performance other than allocating channels? Thanks for any help Brian Spears -Original Message- Sent: Wednesday, February 05, 2003 9:53 AM To: Multiple recipients of list ORACLE-L Check out the doc's at tahiti.oracle.com and look up the parameter noprompt. Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 2/5/2003 5:48 AM Hello List, I think my question is very simple... How to execute RMAN command DELETE OBSOLETE from script without confirmation question to remove obsolete backups automatically? Many thanks for your help. -- Best regards, Alex mailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko 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.net -- Author: Freeman Robert - IL 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.net -- Author: Spears, Brian 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.net -- Author: Freeman Robert - IL 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.net -- Author: Spears, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: RMAN - questions.. Rob Freeman?
I am considering doing an rman to disk backup and recovery solution for a 500G-- grow to 1terabyte database. Monster HP servers ... up t0 16 cpu, upto 10,000 concurrent users This rman would be the secondary recovery solution (Timefinder is the first). Anybody know time frames I might be able to restore/backup 500Gig to 1terabyte of database from disk? I will perform it before it goes live but I would like get a ball park idea of restore times before hand so we can determine if it can fit in the SLA requirements. Any parameters to focus on to improve performance other than allocating channels? Thanks for any help Brian Spears -Original Message- Sent: Wednesday, February 05, 2003 9:53 AM To: Multiple recipients of list ORACLE-L Check out the doc's at tahiti.oracle.com and look up the parameter noprompt. Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 2/5/2003 5:48 AM Hello List, I think my question is very simple... How to execute RMAN command DELETE OBSOLETE from script without confirmation question to remove obsolete backups automatically? Many thanks for your help. -- Best regards, Alex mailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko 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.net -- Author: Freeman Robert - IL 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.net -- Author: Spears, Brian 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).
RE: RMAN - questions.. Rob Freeman?
You will only know what your system is capable of It is very dependant on the disk arrays and no of scsi or fibre channels you have to support those disks Also RAID level will be a big contributor How long does it take to copy say a 500MB file from location to location. check it out this way. see what throughput you are reporting in sar or glance or similar Test this between the filesystem your db is on and where you want to put the backup to disk -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Spears, Brian [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06-02-2003 06:16 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RMAN - questions.. Rob Freeman? I am considering doing an rman to disk backup and recovery solution for a 500G-- grow to 1terabyte database. Monster HP servers ... up t0 16 cpu, upto 10,000 concurrent users This rman would be the secondary recovery solution (Timefinder is the first). Anybody know time frames I might be able to restore/backup 500Gig to 1terabyte of database from disk? I will perform it before it goes live but I would like get a ball park idea of restore times before hand so we can determine if it can fit in the SLA requirements. Any parameters to focus on to improve performance other than allocating channels? Thanks for any help Brian Spears -Original Message- Sent: Wednesday, February 05, 2003 9:53 AM To: Multiple recipients of list ORACLE-L Check out the doc's at tahiti.oracle.com and look up the parameter noprompt. Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 2/5/2003 5:48 AM Hello List, I think my question is very simple... How to execute RMAN command DELETE OBSOLETE from script without confirmation question to remove obsolete backups automatically? Many thanks for your help. -- Best regards, Alex mailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko 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.net -- Author: Freeman Robert - IL 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.net -- Author: Spears, Brian 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
RE: RMAN - questions.. Rob Freeman?
Brian - Hopefully Robert will have a chance to respond to your question, but if I might make some suggestions, I think your recovery time has two components: 1. If the backup files are not on disk, the time to locate the tape, load the files. 2. RMAN recovery time. I think you will just have to perform some tests on your equipment. There are several tunable RMAN parameters that will make a great deal of difference (or not), depending on your hardware. There are many different types of recovery. Some recoveries may require very little data from RMAN, others may require a lot. You need to outline (and eventually test) for the different types of recovery scenarios. Overall, my experience has been that RMAN offers very fast performance, usually limited just by disk speeds. But what impresses me may not meet your needs. I'm easily impressed. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 05, 2003 2:16 PM To: Multiple recipients of list ORACLE-L I am considering doing an rman to disk backup and recovery solution for a 500G-- grow to 1terabyte database. Monster HP servers ... up t0 16 cpu, upto 10,000 concurrent users This rman would be the secondary recovery solution (Timefinder is the first). Anybody know time frames I might be able to restore/backup 500Gig to 1terabyte of database from disk? I will perform it before it goes live but I would like get a ball park idea of restore times before hand so we can determine if it can fit in the SLA requirements. Any parameters to focus on to improve performance other than allocating channels? Thanks for any help Brian Spears -Original Message- Sent: Wednesday, February 05, 2003 9:53 AM To: Multiple recipients of list ORACLE-L Check out the doc's at tahiti.oracle.com and look up the parameter noprompt. Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 2/5/2003 5:48 AM Hello List, I think my question is very simple... How to execute RMAN command DELETE OBSOLETE from script without confirmation question to remove obsolete backups automatically? Many thanks for your help. -- Best regards, Alex mailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko 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.net -- Author: Freeman Robert - IL 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.net -- Author: Spears, Brian 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.net -- Author: DENNIS WILLIAMS 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
RE: RMAN - questions.. Rob Freeman?
Is this all live OLTP type data, or might some of the data be made read-only? How much will the data be growing and changing (if not a great deal then look into incrementals). I can't begin to guess at the time required those numbers are all factors of: 1. # of backup devices you will be backing up to (I'd suggest several, minimum of probably 6). 2. Speed of backup devices. 3. Speed of infrastructure from DB to the backup devices. Given a best case, lots of backup devices to backup to in parallel, fast fast infrastructure and really fast (and expensive) equipment, you could backup 1TB in an hour or two... Realisticly, much much longer, perhaps upwards of 10-12+ hours at a moderate price range. You could stagger these backups over the week, backup some tablespaces and all archived redo logs on day one, other tablespaces and archived redo logs on day two and so on. This staggered approach will reduce the overhead associated with a large, long lasting backup. Recovery of a TB will take a while of course, be prepared for that when negotiating your SLA's. A product like BMC's timefinder makes a good primary backup/recovery solution. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 2/5/2003 2:16 PM I am considering doing an rman to disk backup and recovery solution for a 500G-- grow to 1terabyte database. Monster HP servers ... up t0 16 cpu, upto 10,000 concurrent users This rman would be the secondary recovery solution (Timefinder is the first). Anybody know time frames I might be able to restore/backup 500Gig to 1terabyte of database from disk? I will perform it before it goes live but I would like get a ball park idea of restore times before hand so we can determine if it can fit in the SLA requirements. Any parameters to focus on to improve performance other than allocating channels? Thanks for any help Brian Spears -Original Message- Sent: Wednesday, February 05, 2003 9:53 AM To: Multiple recipients of list ORACLE-L Check out the doc's at tahiti.oracle.com and look up the parameter noprompt. Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 2/5/2003 5:48 AM Hello List, I think my question is very simple... How to execute RMAN command DELETE OBSOLETE from script without confirmation question to remove obsolete backups automatically? Many thanks for your help. -- Best regards, Alex mailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko 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.net -- Author: Freeman Robert - IL 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.net -- Author: Spears, Brian 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.net -- Author: Freeman Robert - IL 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
RE: RMAN - questions.. Rob Freeman?
Take a look at this link, it might be helpful... http://portal1.legato.com/resources/whitepapers/W012.pdf Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 2/5/2003 2:16 PM I am considering doing an rman to disk backup and recovery solution for a 500G-- grow to 1terabyte database. Monster HP servers ... up t0 16 cpu, upto 10,000 concurrent users This rman would be the secondary recovery solution (Timefinder is the first). Anybody know time frames I might be able to restore/backup 500Gig to 1terabyte of database from disk? I will perform it before it goes live but I would like get a ball park idea of restore times before hand so we can determine if it can fit in the SLA requirements. Any parameters to focus on to improve performance other than allocating channels? Thanks for any help Brian Spears -Original Message- Sent: Wednesday, February 05, 2003 9:53 AM To: Multiple recipients of list ORACLE-L Check out the doc's at tahiti.oracle.com and look up the parameter noprompt. Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 2/5/2003 5:48 AM Hello List, I think my question is very simple... How to execute RMAN command DELETE OBSOLETE from script without confirmation question to remove obsolete backups automatically? Many thanks for your help. -- Best regards, Alex mailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko 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.net -- Author: Freeman Robert - IL 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.net -- Author: Spears, Brian 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.net -- Author: Freeman Robert - IL 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).