Introduction Lesson Objectives 1-2 Course Objectives 1-3 Suggested Schedule 1-4 What Is Covered in the DBAI Course 1-5 Course Examples: The HR Schema 1-6 Oracle Database 10g: The Database for the Grid 1-7 Database Architecture: Review 1-8 | Preface 1 Introduction Lesson Objectives 1-2 Course Objectives 1-3 Suggested Schedule 1-4 What Is Covered in the DBAI Course 1-5 Course Examples: The HR Schema 1-6 Oracle Database 10g: The Database for the Grid 1-7 Database Architecture: Review 1-8 Oracle Memory Structures 1-9 Oracle Processes 1-11 Reviewing Oracle Instance Management 1-12 Physical Database Structure 1-14 Oracle Managed Files (OMF) 1-16 Logical and Physical Database Structures 1-17 Database Architecture: Summary of Structural Components 1-19 Summary 1-20 2 Configuring Recovery Manager Objectives 2-2 Backup and Recovery: Review 2-3 Features of Recovery Manager 2-4 Recovery Manager Components 2-6 Steps for Configuring RMAN 2-8 RMAN Repository Data Storage: Comparison of Options 2-9 Backup Destinations 2-11 Media Management 2-12 Using a Flash Recovery Area with RMAN 2-14 Monitoring the Flash Recovery Area with EM 2-16 Flash Recovery Area Space Usage 2-17 V$FLASH_RECOVERY_AREA_USAGE 2-18 Backing Up the Flash Recovery Area | Preface 1 Introduction Lesson Objectives 1-2 Course Objectives 1-3 Suggested Schedule 1-4 What Is Covered in the DBAI Course 1-5 Course Examples: The HR Schema 1-6 Oracle Database 10g: The Database for the Grid 1-7 Database Architecture: Review 1-8 Oracle Memory Structures 1-9 Oracle Processes 1-11 Reviewing Oracle Instance Management 1-12 Physical Database Structure 1-14 Oracle Managed Files (OMF) 1-16 Logical and Physical Database Structures 1-17 Database Architecture: Summary of Structural Components 1-19 Summary 1-20 2 Configuring Recovery Manager Objectives 2-2 Backup and Recovery: Review 2-3 Features of Recovery Manager 2-4 Recovery Manager Components 2-6 Steps for Configuring RMAN 2-8 RMAN Repository Data Storage: Comparison of Options 2-9 Backup Destinations 2-11 Media Management 2-12 Using a Flash Recovery Area with RMAN 2-14 Monitoring the Flash Recovery Area with EM 2-16 Flash Recovery Area Space Usage 2-17 V$FLASH_RECOVERY_AREA_USAGE 2-18 Backing Up the Flash Recovery Area 2-20 Benefits of Using a Flash Recovery Area 2-21 Setting Parameters That Affect RMAN 2-22 RMAN Usage Considerations 2-24 Connection Types with RMAN 2-25 Starting RMAN 2-26 Additional RMAN Command-Line Arguments 2-27 Configuring Persistent Settings for RMAN 2-28 Configuring RMAN Settings by Using EM 2-29 Control File Autobackups 2-30 Retention Policies 2-32 Managing Persistent Settings 2-34 Channel Allocation 2-35 Automatic and Manual Channel Allocation 2-36 Contents iii Channel Control Options 2-37 Summary 2-39 Practice Overview: Configuring RMAN 2-40 3 Using Recovery Manager Objectives 3-2 Issuing Recovery Manager Commands 3-3 Types of RMAN Commands 3-5 Job Commands: Example 3-6 RMAN Commands: Overview 3-7 BACKUP Command 3-9 Backup Constraints 3-10 Parallelization of Backup Sets 3-11 Compressed Backups 3-13 Image Copy 3-14 Tags for Backups and Image Copies 3-16 BACKUP Command Options 3-17 Backing Up Archived Redo Logs 3-19 Whole Database Backup 3-21 RMAN Backup Types 3-22 .