Chapter 12. Backup and Recovery
Strategy
One of the most important management tasks for any database is taking backups of the data. It may seem obvious, but you will be surprised how many companies jeopardize their business by taking backups infrequently, by not taking care of their backup tapes, or by not testing their backup and recovery strategy.
A data warehouse has a couple of major characteristics that influence the backup strategy:
The size of the data warehouse
The historical, and therefore static, nature of most of the data in the warehouse.
A data warehouse by its very nature is a repository of historical records, which, generally, once loaded, are not subsequently altered. Therefore, once this load has been performed and backed up, it is ...
Get Oracle 10g Data Warehousing now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
