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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.