Oracle Database 10G Data Warehouse Backup And Recovery.pptVIP

Oracle Database 10g Data Warehouse Backup Recovery: Automatic, Simple, And Reliable George Lumpkin Director Product Management Oracle Corporation Tammy Bednar Sr. Product Manager Oracle Corporation Agenda Data warehouse characteristics Oracle Backup Recovery review Understand your backup and recovery requirements DW Recovery Methodology Best Practice#1 – Archivelog Mode Best Practice#2 – Use RMAN Best Practice#3 – Read-Only Tablespaces Best Practice#4 – Nologging Operations Best Practice#5 – Exclude Tablespace You can back up your data warehouse in exactly the same way as you back up your OLTP database.But … But … Your OLTP system is 50GB and your data warehouse is 5TB. Do you have the budget to buy 100X more backup hardware to support your data warehouse? Your OLTP system must be recoverable in 30 minutes. Does your data warehouse require the same recovery time? Your OLTP system contains new customer orders, so it can never lose any transactions. Does you data warehouse require zero data loss? Data Warehouse Characteristics Large amounts of data Production systems up to 10s of terabytes Lower availability requirements than OLTP Often hours or days, not minutes Data enters data warehouse via controlled processes (ETL) Data feeds can be re-run if necessary Significant portions of data warehouse may be static Older data generally does not change Agenda Data warehouse characteristics Oracle Backup Recovery review Understand your backup and recovery requirements DW Recovery Methodology Best Practice#1 – Archivelog Mode Best Practice#2 – Use RMAN Best Practice#3 – Read-Only Tablespaces Best Practice#4 – Nologging Operations Best Practice#5 – Exclude Tablespace Oracle Backup RecoveryWhat should you backup? Backup and Recovery Methods and Tools Recovery Manager Oracle’s tightly integrated utility for creating, managing, restoring and recovering databases Oracle Enterprise Manager GUI interface to Recovery Manager Oracle Data Pump (export/import) Logical