Register your product to gain access to bonus material or receive a coupon.
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!
Download the Sample
Chapter related to this title.
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.
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.
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.
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.
Download the Index
file related to this title.