List of Tables

• 1-1 Feature Comparison of Backup Techniques
• 2-1 Common Backup Options
• 2-2 FOR RECOVER OF COPY Options
• 2-3 LIST Options for Backups
• 2-4 Additional LIST Options
• 2-5 REPORT Options
• 3-1 Components of the RMAN Environment
• 4-1 Overview of RMAN Database Connections
• 4-2 Values in Examples
• 5-1 Commands to Configure the Default Device Type
• 5-2 Files in the Fast Recovery Area
• 5-3 Initialization Parameters for the Fast Recovery Area
• 5-4 Criteria to Determine an Identical File
• 5-5 Effect of Redundancy Setting on Backup Optimization
• 6-1 Channel Control Options
• 8-1 Sample Archived Redo Log Records
• 8-2 Effect of Basic Script When Run Daily
• 8-3 Effect of Advanced Script When Run Daily
• 9-1 Effects of Daily and Weekly Scripts
• 9-2 BACKUP ... SKIP Options
• 10-1 LIST Objects
• 10-2 Most Common LIST Options
• 10-3 REPORT Options
• 11-1 V$SYSSTAT Statistics
• 11-2 RMAN Deletion Commands
• 12-1 Typical Recovery Catalog Space Requirements for 1 Year
• 15-1 Detection, Repair, and Monitoring of Block Corruption
• 20-1 RMAN TSPITR Entities
• 20-2 TS_PITR_OBJECTS_TO_BE_DROPPED View
• 20-3 Order of Precedence for Naming Files
• 20-4 Default Initialization Parameters for the RMAN-Managed Auxiliary Instance
• 20-5 Initialization Parameters in a User-Managed Auxiliary Instance
• 21-1 Datafile Read Buffer Sizing Algorithm
• 21-2 Columns of V$SESSION_LONGOPS Relevant for RMAN
• 21-3 Adjusting the Level of Multiplexing
• 22-1 Types of Message Output
• 22-2 RMAN Error Message Ranges
• 22-3 Media Manager Error Message Ranges
• 22-4 Useful V$ Views for Troubleshooting
• 24-1 Substitution Variables for SET NEWNAME
• 24-2 Results from Example 24-3 SET NEWNAME DATABASE Command
• 24-3 Initialization Parameters for Oracle Managed Files
• 24-4 Initialization Parameter Restrictions for Oracle Managed Files
• 24-5 Auxiliary Instance Initialization Parameters
• 24-6 Options to Specify Subsets of Tablespaces for the Duplicate Database
• 25-1 Default Initialization Parameters
• 26-1 CHECK_DB Procedure Parameters
• 27-1 Aspects of the Database Important for dd Usage
• 27-2 Options for dd Command
• 27-3 Scenarios Involving dd Backups
• 27-4 OCOPY Options
• 28-1 User-Managed Restore Operations
• 28-2 Loss of Archived Redo Logs
• 28-3 Inconsistencies Between Data Dictionary and Control File
• 28-4 Media Recovery Problems
• 28-5 Media Recovery Solutions
• 28-6 Guidelines for Allowing Recovery to Permit Corruption
• 29-1 Scenarios When Control Files Are Lost
• 29-2 Options for Creating the Control File
• 29-3 STATUS Column of V$LOG
• 29-4 Recovering After the Loss of an Online Redo Log Group