Book description
Master Oracle Recovery Master
Protect your databases from hardware, software, and operator failures using the detailed information in this Oracle Press guide. Oracle RMAN 11g Backup and Recovery explains how to configure databases, generate accurate archives, and carry out system restores. Work from the command line or Oracle Enterprise Manager, automate the backup process, perform Oracle Flashback recoveries, and integrate cloud computing technology. This authoritative resource also shows you how to create reports, optimize performance, and implement third-party administration utilities.
- Set up, configure, and maintain Oracle Recovery Manager (Oracle RMAN)
- Manage physical and virtual media with Oracle Secure Backup
- Work with Oracle RMAN catalogs, packages, and control files
- Use the Amazon Web Services cloud as an offsite storage solution
- Create online, offline, and incremental system backups
- Perform full and partial Oracle RMAN database restores
- Correct user-induced errors with Oracle Flashback
- Product clone and standby databases on local or remote servers
- Use Oracle Real Application Clusters and synch and split technology
For a complete list of Oracle Press titles, visit www.OraclePressBooks.com
Table of contents
- Cover Page
- Oracle RMAN 11g Backup and Recovery
- Copyright Page
- Contents
- Acknowledgments
- Introduction
-
PART I Getting Started with RMAN in Oracle Database 11g
- 1 Oracle Database 11g Backup and Recovery Architecture Tour
-
2 Introduction to the RMAN Architecture
- Server-Managed Recovery
- The RMAN Utility
- The Network Topology of RMAN Backups
- The Database Control File
- The RMAN Server Processes
- The SYS Packages Used by RMAN
- Backing Up the Data Block
- RMAN in Memory
- The Recovery Catalog
- The Auxiliary Database
- Compatibility Issues
- The RMAN Process: From Start to Finish
- The Flash Recovery Area
- Summary
-
PART II Setup Principles and Practices
-
3 RMAN Setup and Configuration
- Configuring Your Database to Run in ARCHIVELOG Mode
- The Oracle Database 11g Fault Diagnosability Infrastructure
- The RMAN Command Line
- Configuring the Database for RMAN Operations
- Configuring RMAN Default Settings
- Summary of RMAN Configuration Tasks
- Other Backup and Recovery Setup and Configuration Considerations
- Summary
- 4 Media Management Considerations
- 5 Oracle Secure Backup
- 6 Backing Up to Amazon Web Services Using the Oracle Secure Backup Cloud Module
- 7 Enhancing RMAN with VERITAS NetBackup
- 8 Configuring HP Data Protector for Oracle
- 9 RMAN and Tivoli Storage Manager
-
10 Using the Recovery Catalog
- What Is the Recovery Catalog?
- Merging Multiple Recovery Catalogs
- Recovery Catalog Maintenance
- Backing Up the Recovery Catalog
-
Recovery Catalog Views
- RC_ARCHIVED_LOG (V$ARCHIVED_LOG)
- RC_BACKUP_CONTROLFILE (V$BACKUP_DATAFILE)
- RC_BACKUP_CORRUPTION (V$BACKUP_CORRUPTION)
- RC_BACKUP_DATAFILE (V$BACKUP_DATAFILE)
- RC_BACKUP_FILES (V$BACKUP_FILES)
- RC_BACKUP_PIECE (V$BACKUP_PIECE)
- RC_BACKUP_REDOLOG (V$BACKUP_REDOLOG)
- RC_BACKUP_SET (V$BACKUP_SET)
- RC_BACKUP_SPFILE (V$BACKUP_SPFILE)
- RC_CONTROLFILE_COPY (V$DATAFILE_COPY)
- RC_COPY_CORRUPTION (V$COPY_CORRUPTION)
- RC_DATABASE (V$DATABASE)
- RC_DATABASE_BLOCK_CORRUPTION (V$DATABASE_BLOCK_CORRUPTION)
- DATABASE_INCARNATION (V$DATABASE_INCARNATION)
- RC_DATAFILE (V$DATAFILE)
- RC_DATAFILE_COPY (V$DATAFILE_COPY)
- RC_LOG_HISTORY (V$LOG_HISTORY)
- RC_OFFLINE_RANGE (V$OFFLINE_RANGE)
- RC_REDO_LOG (V$LOG, V$LOGFILE)
- RC_REDO_THREAD (V$THREAD)
- RC_RESYNC
- RC_RMAN_CONFIGURATION (V$RMAN_CONFIGURATION)
- RC_TABLESPACE (V$TABLESPACE)
- RC_TEMPFILE (V$TEMPFILE)
- Catalog Views Intended for Use by Oracle Enterprise Manager
-
11 RMAN Backups
- Benefits of RMAN Backups vs. Scripted Backups
- RMAN Compatibility Issues
- Monitoring RMAN Backup Status
- Offline RMAN Database Backups
-
Backup Command Options
- Multisection Backups
- Compression
- Tags and Restore Points
- Limiting Backup Impacts
- Limiting the Size of a Backup Set
- Backing Up to a Specific Device Type
- Modifying the Retention Policy for a Backup Set
- Archive Log Deletion Policies
- Overriding the configure exclude Command
- Checking the Database for Errors with the backup Command
- Skipping Offline, Inaccessible, or Read-Only Datafiles
- Forcing a Backup of Read-Only Datafiles
- Backing Up Datafiles Based on Their Last Backup Time
- Making Copies of Backups on Your RMAN Copier
- Capturing the Elusive Control File
- Introducing the set Command
- Online RMAN Database Backups
- Copies
- Incremental RMAN Backups
- Getting Started
- Summary
- 12 RMAN Restore and Recovery
-
3 RMAN Setup and Configuration
-
PART III Using RMAN Effectively
-
13 Using Oracle Enterprise Manager for Backup and Recovery
- Oracle Enterprise Manager: The New Paradigm
- Grid Control
- Database Control
- Configuring Backup Settings in Enterprise Manager
- Configuring Recovery Settings
- Configuring Recovery Catalogs in OEM
- Database Backups from Enterprise Manager
- Performing Recovery in Enterprise Manager
- Backup Management and Reporting
- Database Cloning from Enterprise Manager
- Summary
- 14 RMAN Advanced Recovery Topics
- 15 Surviving User Errors: Flashback Technologies
- 16 Maintaining RMAN
- 17 Monitoring and Reporting on RMAN
- 18 Performance Tuning RMAN Backup and Recovery Operations
-
13 Using Oracle Enterprise Manager for Backup and Recovery
-
PART IV RMAN in the Oracle Ecosystem
- 19 Duplication: Cloning the Target Database
- 20 RMAN and Data Guard
- 21 RMAN and Real Application Clusters
-
22 RMAN in Sync and Split Technology
- Sync and Split: Broken Mirror Backups
- Oracle Databases on Sync and Split Volumes
- Benefits of the Split Mirror Backup
-
RMAN and Sync and Split
- Registering Split Mirror Copies with RMAN
- Taking RMAN Backups from the Split Mirror
- RMAN Workshop: Configure RMAN to Back Up from the Split Mirror
- Getting Sync and Split Functionality from Oracle Software
- Using a Standby Database, Flashback Database, and Incremental Apply for Sync and Split
- Benefits of the Oracle Sync and Split Solution
- Oracle-Integrated Shadow Copy Services for Windows
- Summary
-
23 RMAN in the Workplace: Case Studies
- Before the Recovery
-
Recovery Case Studies
- Case #1: Recovering from Complete Database Loss (NOARCHIVELOG Mode) with a Recovery Catalog
- Case #2: Recovering from Complete Database Loss (NOARCHIVELOG Mode) Without a Recovery Catalog
- Case #3: Recovering from Complete Database Loss (ARCHIVELOG Mode) Without a Recovery Catalog
- Case #4: Recovering from Complete Database Loss (ARCHIVELOG Mode) with a Recovery Catalog
- Case #5: Recovering from the Loss of the SYSTEM Tablespace
- Case #6: Recovering Online from the Loss of a Datafile or Tablespace
- Case #7: Recovering from Loss of an Unarchived Online Redo Log
- Case #8: Recovering Through resetlogs
- Case #9: Completing a Failed Duplication Manually
- Case #10: Using RMAN Duplication to Create a Historical Subset of the Target Database
- Case #11: Recovering from a Lost Datafile (ARCHIVELOG Mode) Using an Image Copy in the Flash Recovery Area
- Case #12: Recovering from Running the Production Datafile Out of the Flash Recovery Area
- Case #13: Using Flashback Database and Media Recovery to Pinpoint the Exact Moment to Open the Database with resetlogs
- Summary
-
PART V Appendixes
-
A RMAN Syntax Reference Guide
- RMAN Reserved Words
- RMAN Command List
- RMAN Specifier and Operands Lists
- RMAN Command List Syntax Details
- @ Command
- @@ Command
- advise failure Command
- allocate channel Command
- allocate channel for maintenance Command
- alter database Command
- backup Command
- catalog Command
- change Command
- configure Command
- connect Command
- convert Command
- create catalog Command
- create script Command
- crosscheck Command
- delete Command
- delete script Command
- drop catalog Command
- drop database Command
- duplicate Command
- execute script Command
- exit Command
- flashback database Command
- grant Command
- host Command
- import catalog Command
- list Command
- print script Command
- quit Command
- recover Command
- register database Command
- release channel Command
- repair failure Command
- replace script Command
- report Command
- reset database Command
- restore Command
- resync catalog Command
- revoke Command
- run Command
- send Command
- set Command
- show Command
- shutdown Command
- spool Command
- SQL Command
- startup Command
- switch Command
- transport tablespace Command
- unregister database Command
- upgrade catalog Command
- validate Command
- RMAN Subclauses Syntax Details
- allocOperandList
- archivelogRecordSpecifier
- completedTimeSpec
- connectStringSpec
- datafileSpec
- deviceSpecifier
- fileNameConversionSpec
- forDbUniqueNameOption
- foreignlogRecordSpecifier
- formatSpec
- keepOption
- listObjList
- maintQualifier
- maintSpec
- obsOperandList
- recordSpec
- tempfileSpec
- toDestSpec
- untilClause
- B RMAN Scripting Examples
- C Setting Up an RMAN Test Environment
-
A RMAN Syntax Reference Guide
- Index
Product information
- Title: Oracle RMAN 11g Backup and Recovery
- Author(s):
- Release date: May 2010
- Publisher(s): McGraw Hill Computing
- ISBN: 9780071628617
You might also like
book
Oracle Database 10g RMAN Backup & Recovery
The Most Complete Guide to Maximizing Oracle Recovery Manager Deploy a rock-solid data backup and disaster …
book
Pro Oracle Database 11g Administration
Pro Oracle Database 11g Administration is a book focused on results. Author Darl Kuhn draws from …
book
Oracle Database 11g New Features
FOREWORD by Tom Kyte Your Must-Have Guide to Everything New in Oracle Database 11 g Realize …
book
Oracle Database 11g: New Features for DBAs and Developers
Oracle Database 11g : New Features for DBAs and Developers is a comprehensive, example-laden review of …