List of Tables

• 1-1 Components of the RMAN Environment
• 2-1 Backup Types
• 2-2 Criteria to Determine an Identical File
• 2-3 Backup Optimization Algorithm
• 2-4 Effect of Redundancy Setting on Backup Optimization
• 8-1 TS_PITR_OBJECTS_TO_BE_DROPPED View
• 8-2 Initialization Parameters in the Auxiliary Instance
• 9-1 Maintenance Commands and Scripts
• 9-2 Columns of V$SESSION_LONGOPS Relevant for RMAN
• 10-1 Typical Recovery Catalog Space Requirements for 1 Year
• 10-2 Records Updated During a Resynchronization
• 11-1 Datafile Read Buffer Sizing Algorithm
• 11-2 V$INSTANCE_RECOVERY Columns
• 12-1 RMAN Error Message Ranges
• 12-2 Media Manager Error Message Ranges
• 13-1 Order of Precedence for Online Redo Log Filename Generation
• 13-2 Read-Only Tablespaces in V$DATAFILE View on Duplicate Database
• 13-3 Read-Only Tablespaces in Data Dictionary Views on Duplicate Database
• 13-4 Offline Tablespaces in V$ Views on Duplicate Database
• 13-5 Offline Tablespaces in Data Dictionary Views on Duplicate Database
• 13-6 Database Name and Control File Name Initialization Parameters
• 13-7 Filename Conversion Initialization Parameters
• 13-8 Oracle Managed Files Initialization Parameter Settings
• 15-1 CHECK_DB Procedure Parameters
• 15-2 Condtitions Tested by CHECK_DB Preventing Use of CONVERT DATABASE
• 17-1 Options for dd Command
• 17-2 Scenarios Involving dd Backups
• 18-1 Scenarios When Control Files Are Lost
• 18-2 Options for Creating the Control File
• 19-1 STATUS Column of V$LOG
• 19-2 Recovery Operations in a Distributed Database Environment
• 20-1 TS_PITR_OBJECTS_TO_BE_DROPPED View
• 20-2 Auxiliary Initialization Parameters
• 21-1 Media Recovery Problems
• 21-2 Media Recovery Solutions
• 21-3 Guidelines for Allowing Recovery to Permit Corruption