Backup and Recovery

This is probably the least understood and often most heatedly debated DBA topic in data warehousing. Without intentionally bashing other books regarding Oracle data warehousing, let me say, that in general, the advice is short-sighted, covering only Oracle methods for backup and recovery. I genuinely mean no disrespect to these other authors, but I've never used and never advise DBAs to use Oracle tools for backup and recovery when dealing with databases this big. There are better methods out there. To simply ask whether it's hot or cold backups and then use Oracle's RMAN to do it is a disservice to your customers. You may have other options that are far superior—if you just look.

Ask yourself what your backup and recovery ...

Get Oracle® DBA Guide to Data Warehousing and Star Schemas 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.