| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to backup a data warehouse?
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...
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gorman
INET: Tim_at_SageLogix.com
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: ListGuru_at_fatcity.com (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). Received on Wed May 08 2002 - 11:52:26 CDT
 |
 |