4/47

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
• 7-1 V$SYSSTAT Statistics
• 9-1 Sample Archived Redo Log Records
• 9-2 Effect of Basic Script When Run Daily
• 9-3 Effect of Advanced Script When Run Daily
• 10-1 Effects of Daily and Weekly Scripts
• 10-2 BACKUP ... SKIP Options
• 11-1 LIST Objects
• 11-2 Most Common LIST Options
• 11-3 REPORT Options
• 12-1 RMAN Deletion Commands
• 13-1 Typical Recovery Catalog Space Requirements for 1 Year
• 16-1 Detection, Repair, and Monitoring of Block Corruption
• 21-1 RMAN TSPITR Entities
• 21-2 TS_PITR_OBJECTS_TO_BE_DROPPED View
• 21-3 Order of Precedence for Naming Files
• 21-4 Default Initialization Parameters for the RMAN-Managed Auxiliary Instance
• 21-5 Initialization Parameters in a User-Managed Auxiliary Instance
• 22-1 Data File Read Buffer Sizing Algorithm
• 22-2 Columns of V$SESSION_LONGOPS Relevant for RMAN
• 22-3 Adjusting the Level of Multiplexing
• 23-1 Types of Message Output
• 23-2 RMAN Error Message Ranges
• 23-3 Media Manager Error Message Ranges
• 23-4 Useful V$ Views for Troubleshooting
• 25-1 Substitution Variables for SET NEWNAME
• 25-2 Results from Example 25-3 SET NEWNAME DATABASE Command
• 25-3 Initialization Parameters for Oracle Managed Files
• 25-4 Initialization Parameter Restrictions for Oracle Managed Files
• 25-5 Auxiliary Instance Initialization Parameters
• 25-6 Options to Specify Subsets of Tablespaces for the Duplicate Database
• 26-1 Default Initialization Parameters for the Auxiliary Instance
• 27-1 CHECK_DB Function Parameters
• 28-1 Aspects of the Database Important for dd Usage
• 28-2 Options for dd Command
• 28-3 Scenarios Involving dd Backups
• 28-4 OCOPY Options
• 29-1 User-Managed Restore Operations
• 29-2 Loss of Archived Redo Logs
• 29-3 Inconsistencies Between Data Dictionary and Control File
• 29-4 Media Recovery Problems
• 29-5 Media Recovery Solutions
• 29-6 Guidelines for Allowing Recovery to Permit Corrupt Blocks
• 30-1 Scenarios When Control Files Are Lost
• 30-2 Options for Creating the Control File
• 30-3 STATUS Column of V$LOG
• 30-4 Recovering After the Loss of an Online Redo Log Group