Oracle DBA Backup and Recovery Quick Reference
Published on 9. October 2003
Book
Paperback/Softback
352 pages
978-0-13-140304-8 (ISBN)
Description
The single most important task of an Oracle DBA is ensuring the integrity and recoverability of the database. This requires a thorough understanding of backup and recovery concepts as well as the details of the various methods of performing backups and restoring the database or portions of it. In early versions of the Oracle database, the choice of tools provided by Oracle was relatively limited, but with Oracle 9i, the Recovery Manager (RMAN) provides a powerful and flexible tool to manage the availability and recoverability of the database. The earlier tools, including Export and Import, are still present and play an important role in any comprehensive backup and recovery plan. This book is a quick reference guide to Oracle DBA backup and recovery that provides complete coverage of all key concepts and tools.
More details
Language
English
Place of publication
Upper Saddle River
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Height: 228 mm
Width: 153 mm
Thickness: 23 mm
Weight
561 gr
ISBN-13
978-0-13-140304-8 (9780131403048)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Persons
CHARLIE RUSSEL has extensive system administration and Oracle DBA experience, specializing in combined Windows and UNIX environments. He is co-author of more than 20 books for IT professionals, including Microsoft Windows Server 2003 Administrator's Companion (Microsoft Press) and UNIX and Linux Answers! Certified Tech Support (IDG).
ROBERT CORDINGLEY is an Oracle DBA in Austin, Texas. Together, Russel and Cordingley have co-authored Oracle DBA Scripting Quick Reference and Oracle DBA SQL Quick Reference (Prentice Hall PTR).
ROBERT CORDINGLEY is an Oracle DBA in Austin, Texas. Together, Russel and Cordingley have co-authored Oracle DBA Scripting Quick Reference and Oracle DBA SQL Quick Reference (Prentice Hall PTR).
Content
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.
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.