4/48
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
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 Database
21-5 Initialization Parameters in a User-Managed Auxiliary Database
23-1 Data File Read Buffer Sizing Algorithm
23-2 Columns of V$SESSION_LONGOPS Relevant for RMAN
23-3 Adjusting the Level of Multiplexing
24-1 Types of Message Output
24-2 RMAN Error Message Ranges
24-3 Media Manager Error Message Ranges
24-4 Useful V$ Views for Troubleshooting
25-1 Options to Duplicate PDBs
26-1 Substitution Variables for SET NEWNAME
26-2 Results from SET NEWNAME FOR DATABASE Command
26-3 Initialization Parameters for Oracle Managed Files
26-4 Initialization Parameter Restrictions for Oracle Managed Files
26-5 Auxiliary Instance Initialization Parameters
26-6 Options to Specify Subsets of Tablespaces for the Duplicate Database
27-1 Default Initialization Parameters for the Auxiliary Instance
28-1 CHECK_DB Function Parameters
29-1 Aspects of the Database Important for dd Usage
29-2 Options for dd Command
29-3 Scenarios Involving dd Backups
29-4 OCOPY Options
30-1 User-Managed Restore Operations
30-2 Loss of Archived Redo Logs
30-3 Inconsistencies Between Data Dictionary and Control File
30-4 Media Recovery Problems
30-5 Media Recovery Solutions
30-6 Guidelines for Allowing Recovery to Permit Corrupt Blocks
31-1 Scenarios When Control Files Are Lost
31-2 Options for Creating the Control File
31-3 STATUS Column of V$LOG
31-4 Recovering After the Loss of an Online Redo Log Group
Scripting on this page enhances content navigation, but does not change the content in any way.