Oracle DBA Backup and Recovery Quick Reference

The fast, practical backup/recovery reference for every Oracle DBA!

If you're a working Oracle DBA, here's the Oracle backup/recovery reference you've been searching for--simple, straightforward, and incredibly easy to use! This book covers every type of Oracle backup, every major recovery scenario, and every technique and tool--including export/import, Rman, flash backup, mirror splitting, snapshotting, and more. Keep it by your desk, near your server...wherever you need fast, reliable answers right this minute!

• Covers Oracle through Oracle10g
• Essential backup and recovery concepts
• Physical, logical, closed, open, consistent, and inconsistent backups
• Export/import procedures with exp/imp and data pumps
• Rman initial configuration, repository databases, and integration with tape-library managers
• User-managed backup options
• Step-by-step recovery procedures: media, tablespace, full, and point-in-time recovery

Table of Contents

Introduction.

How To Use This Book.

Talk To Us.

Acknowledgments.

1. Concepts.

Backup Concepts. Type of Backup. Backup Schedules. Recovery Concepts. Recovery. Media Failure. Complete Recovery. Incomplete Recovery. Tablespace Point-in-Time Recovery. Export, Import, and Data Pump.

2. Export/Import and Data Pump.

Procedures-exp/imp. Export. Import. Full Database. Schema. Object. Procedures-Data Pump. New Data Pump Concepts. Feature Comparison. Full Database. Schema. Object. Reference. Exp. Imp. Expdp. Impdp.

3. RMAN Procedures.

Preconfiguration Decisions. Using a Recovery Area. Using a Recovery Catalog. Using Block Change Tracking. Initial Configuration. Creating a Recovery Area. Creating a Recovery Catalog. Persistent RMAN Settings. Database Settings Done Outside RMAN. Backup Tasks. Connecting to a Target Database. Connecting to a Recovery Catalog. Consistent (Cold) Full Database. Inconsistent (Hot) Full Database without Archived Redo Logs. Inconsistent (Hot) Full Database with Archived Redo Logs. All Archived Redo Logs. Some Archived Redo Logs. Incremental Database. Individual Tablespaces or Data Files. Current Control File. Backing Up to Both Disk and Tape. Recovery Tasks. Full Database When Control File Is Available. Full Database When Control File Is Not Available. Individual Tablespace. Restoring Datafiles to Alternate Locations. Incomplete Database Recovery Using a Current Control File. Incomplete Tablespace Recovery. Flashback Database.

4. RMAN Reference.

Reserved Words. Command Reference. @. @@. ALLOCATE CHANNEL. ALLOCATE CHANNEL FOR MAINTENANCE. ALTER DATABASE. BACKUP. BLOCKRECOVER. CATALOG. CHANGE. CONFIGURE. CONNECT. CONVERT. CREATE CATALOG. CREATE SCRIPT. CROSSCHECK. DELETE. DELETE SCRIPT. DROP CATALOG. DROP DATABASE. DUPLICATE. EXECUTE SCRIPT. EXIT. FLASHBACK. HOST. LIST. PRINT SCRIPT. QUIT. RECOVER. REGISTER. RELEASE CHANNEL. REPLACE SCRIPT. REPORT. RESET DATABASE. RESTORE. RESYNC. RUN. SEND. SET. SHOW. SHUTDOWN. SPOOL. SQL. STARTUP. SWITCH. UNREGISTER DATABASE. UPGRADE CATALOG. VALIDATE. Subclauses and Common. RMAN Catalog Views. RC_ARCHIVED_LOG. RC_BACKUP_CONTROLFILE. RC_BACKUP_CORRUPTION. RC_BACKUP_DATAFILE. RC_BACKUP_FILES. RC_BACKUP_PIECE. RC_BACKUP_REDOLOG. RC_BACKUP_SET. RC_BACKUP_SPFILE. RC_COPY_CORRUPTION. RC_CONTROLFILE_COPY. RC_DATABASE. RC_DATABASE_BLOCK_CORRUPTION. RC_DATABASE_INCARNATION. RC_DATAFILE. RC_DATAFILE_COPY. RC_LOG_HISTORY. RC_OBSOLETE_BACKUP_FILES. RC_OFFLINE_RANGE. RC_PROXY_ARCHIVEDLOG. RC_PROXY_CONTROLFILE. RC_PROXY_DATAFILE. RC_REDO_LOG. RC_REDO_THREAD. RC_RESYNC. RC_RMAN_CONFIGURATION. RC_STORED_SCRIPT. RC_STORED_SCRIPT_LINE. RC_TABLESPACE. Deprecated RMAN Commands.

Index.