Hi, If my memory is good, it was in 1998-99 with Oracle 8, we were using stored proc with dynamic pl/sql. I do not recall that it was taking long. Everything was done with dynamic pl/sql : tablespace creation, partition creation,...
Our partitions were not big, between 200M and 800M. St�phane --- [EMAIL PROTECTED] a �crit�: > > Stephane, > > So, what process did you use to switch over a > non-read-only partition > to read-only on a monthly basis? How quickly were > you able to > make the switch? > > How large were your partitions? > > Thanks, > > Cherie > > > > > > paquette stephane > > > <stephane_paquette@ To: > Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > yahoo.com> cc: > > > Sent by: > Subject: Re: How to backup a data warehouse? > > [EMAIL PROTECTED] > > > > > > > > > 05/08/02 01:49 PM > > > Please respond to > > > ORACLE-L > > > > > > > > > > > > > I've tested a setup like the one Tim is describing. > We tested backuping with RMAN using incremental and > doing conventional hot backup. We were partitionned > by > month and each partition was in its own tablespace. > Only the current month was active so the rest was in > read only mode. > Since volume was not too big , we were still able to > do a nice clean full backup during the weekends. > > > > --- Tim Gorman <[EMAIL PROTECTED]> a �crit�: > The > short answer is that it becomes important to > > make use of the features of 1) range-partitioning, > > 2) read-only tablespaces, and 3) incremental > backups > > with RMAN, and 4) a honking big tape library using > > media-management software. > > > > Range-partitioning allows tables and indexes to be > > spread across multiple tablespaces, usually by > time. > > As data ages, inserts/updates/deletes tends to > > cease; it is usually the newest data that has > > insert/update/delete activity upon it. > > > > Therefore, as data ages, you can set the > tablespace > > in which the partitions are located to read-only. > > As tablespaces are set to read-only, you can > remove > > them from the regular backup list. It is > important > > to take 2-3 additional backups for archival > > retention after setting to read-only, but the > > regularly scheduled backups can now ignore those > > tablespaces. Generally, I recommend partitioning > > according to your loading scheme (i.e. daily > loads, > > thus daily partitions) and storing those > partitions > > in tablespaces according to your scheme for > setting > > them read-only (i.e. if setting read-only on a > > quarterly basis after aged 6 months, then create > > "quarterly" tablespaces to house all of the > > partitions from all partitioned objects in that > > quarter). > > > > The advantages of RMAN's incremental backup > > mechanisms should be obvious, but its usefulness > > depends on the nature of the application. At the > > very least, incremental backups will "supplement" > > the effects of the > partitioning/read-only-tablespace > > scheme illustrated above. Using RMAN's > incremental > > backup mechanism, at worst you would be getting > the > > equivalent of a level-0 or "full" backup, if every > > block was modified during every backup cycle. I > > hope that would be an unlikely scenario, though... > > ----- Original Message ----- > > From: Terrian, Tom > > To: Multiple recipients of list ORACLE-L > > Sent: Wednesday, May 08, 2002 9:38 AM > > Subject: How to backup a data warehouse? > > > > > > How do you guys backup your data warehouses? > Our > > warehouse is suppose to top out around 3.5TB. It > > seems that the traditional hot/cold backup methods > > will not be able to keep up. How do you guys do > it? > > > > > > > > Thanks, > > > > Tom Terrian > > > > > > > > > > > > > > ===== > St�phane Paquette > DBA Oracle, consultant entrep�t de donn�es > Oracle DBA, datawarehouse consultant > [EMAIL PROTECTED] > > ___________________________________________________________ > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et > en fran�ais ! > Yahoo! Mail : http://fr.mail.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: =?iso-8859-1?q?paquette=20stephane?= > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > 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: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > 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 > === message truncated === ===== St�phane Paquette DBA Oracle, consultant entrep�t de donn�es Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___________________________________________________________ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en fran�ais ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
