This course details the architecture and concepts that support backup and recovery. You also learn to implement various backup, failure, restore, and recovery scenarios, including data duplication using the Recovery Manager (RMAN) command-line interface.
With hands-on practices, you’ll be able to leverage your learning to accomplish backup and recovery tasks.
Contenuti
1: Course Overview
Target Audience 1-2
Prerequisites 1-3
Learning Outcomes 1-4
Course Outline 1-6
What’s next? 1-8
2: Backup and Recovery: Overview
Objectives 2-2
DBA Responsibilities 2-3
Separation of DBA Duties 2-4
Assessing Your Recovery Requirements 2-5
Categories of Failure 2-7
Statement Failure 2-8
User Process Failure 2-9
Network Failure 2-10
User Error 2-11
Instance Failure 2-12
Media Failure 2-13
Data Failures 2-14
Instance Recovery 2-16
The Checkpoint (CKPT) Process 2-17
The Redo Log Files and the Log Writer (LGWR) Process 2-18
Database Log Mode 2-19
Automatic Instance Recovery or Crash Recovery 2-20
Phases of Instance Recovery 2-21
Tuning Instance Recovery 2-22
Using the MTTR Advisor 2-24
Restoring and Recovering 2-25
Comparing Complete and Incomplete Recovery 2-26
The Complete Recovery Process 2-27
The Point-in-Time Recovery Process 2-28
Oracle Data Protection Solutions 2-30
Flashback Technology 2-31
Summary 2-32
3: Backup and Recovery Configuration
Objectives 3-2
Configuring for Recoverability 3-3
Configuring the Fast Recovery Area 3-4
Monitoring the Fast Recovery Area 3-6
Multiplexing controlfiles 3-7
Redo Log Files 3-8
Multiplexing the Redo Log 3-9
Creating Archived Redo Log Files 3-10
Archiver (ARCn) Process 3-11
Archived Redo Log Files: Naming and Destinations 3-12
Configuring ARCHIVELOG Mode 3-13
Summary 3-14
4: Using Recovery Manager (RMAN)
Objectives 4-2
Integrated Oracle Recovery Manager (RMAN) 4-3
Connecting to RMAN and a Target Database 4-4
Using SQL in RMAN 4-5
Types of RMAN Commands 4-6
Job Commands: Example 4-7
Configuring Persistent Settings for RMAN 4-8
Viewing Persistent Settings 4-10
Managing Persistent Settings 4-11
Specifying a Retention Policy 4-12
Recovery Window Retention Policy: Example 4-14
Summary 4-19
5: Backup Strategies
Objectives 5-2
Understanding Types of Backups 5-3
Backup Terminology 5-4
Understanding Types of Backups 5-5
RMAN Backup Types 5-6
Backup Solutions: Overview 5-8
Balancing Backup and Restore Requirements 5-9
Comparing Backup Strategies 5-11
Option 1: Full and Incremental Backups 5-12
Option 2: Incrementally Updated Disk Backups 5-13
Option 3: Offloading Backups Physical Standby Database in Data Guard Environment 5-14
Backing Up Read-Only Tablespaces: Considerations 5-15
Data Warehouse Backup and Recovery: Best Practices 5-16
Summary 5-18
6: Creating Database Backups
Objectives 6-2
Using RMAN Commands to Create Backups 6-3
Syntax and Clauses in RMAN 6-4
Creating Backup Sets 6-5
Creating Image Copies 6-6
Creating a Whole Database Backup 6-7
CDB Backup: Whole CDB Backup 6-8
CDB Backup: Partial CDB Backup 6-9
PDB Backup: Partial PDB Backup 6-10
Review: RMAN Backup Types 6-11
Incrementally Updated Backups 6-13
Incrementally Updated Backups: Example 6-14
Fast Incremental Backup 6-15
Maintaining the Block Change Tracking File 6-16
Monitoring Block Change Tracking 6-17
Automatic Disk-to-Disk Backup and Recovery 6-18
Oracle-Suggested Backup 6-19
Backing Up the controlfile to a Trace File 6-20
Cataloging Additional Backup Files 6-21
Reporting on Backups 6-23
Using Dynamic Views 6-24
Summary 6-25
7: Using Optional Backup Features
Objectives 7-2
Saving Backup Space with Unused Block Compression 7-3
Compressing Backups 7-4
Using RMAN Backup Compression 7-5
Using a Media Manager 7-6
Configuring Backup and Restore for Very Large Files 7-8
Backing Up and Restoring Very Large Files 7-9
Creating RMAN Multisection Backups 7-10
Creating Proxy Copies 7-11
Creating Duplexed Backup Sets Using BACKUP COPIES 7-12
